The Netflix TechBlog

SEPTEMBER 18, 2024

Central to this infrastructure is our use of multiple online distributed databases such as Apache Cassandra , a NoSQL database known for its high availability and scalability. Over time as new key-value databases were introduced and service owners launched new use cases, we encountered numerous challenges with datastore misuse.

Latency 258

Latency Storage Cache Efficiency 258

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. Not available.

Open Source 244

Open Source Tuning C++ Database 244

SQL Performance

APRIL 13, 2020

In my last post , I started to outline the process I go through when tuning queries – specifically when I discover that I need to add a new index, or modify an existing one. value ( '(@Database) [1 ]' , 'varchar(128)' ) AS DatabaseName , obj. This is where index tuning becomes an art. nodes ( '.

Tuning 137

Tuning Cache Metrics Testing 137

Scalegrid

JANUARY 10, 2025

Heading into 2024, SQL databases will remain essential in data management, increasingly using distributed systems to meet growing needs for scalability and reliability. According to 2023 statistics, 49% of web applications use an SQL-based database , with SQL having a 75% adoption rate in the IT industry.

Database 130

Database Scalability Best Practices Blockchain 130

Scalegrid

MARCH 23, 2020

While its use and importance has decreased as the inbuilt replication options improved on PostgreSQL server side, this still remains a valuable option for older versions of PostgreSQL. Follow these steps to set up Pgpool-II, enable the connection pool services you need, and connect to your PostgreSQL server. At a glance. How it works.

Cache 264

Cache Servers Architecture Processing 264

Percona

AUGUST 31, 2018

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. This is called double buffering.

Tuning 79

Tuning Database Performance Benchmarking 79

SQL Shack

NOVEMBER 23, 2020

In this article, we will talk about the query tuning features that were announced with SQL Server 2019. Introduction Sometimes, tuning the queries can be a tough task for database developers or administrators.

Tuning 76

Tuning Servers Database Development 76

Scalegrid

OCTOBER 17, 2019

In that environment, the first PostgreSQL developers decided forking a process for each connection to the database is the safest choice. It would be a shame if your database crashed, after all. Developers are often strongly discouraged from holding a database connection while other operations take place.

Architecture 200

Architecture Database Latency Servers 200

SQL Shack

MAY 8, 2020

In this article, we will continue to learn essential techniques of the SQL Server query tuning with practical examples. Query tuning is a bit complicated issue and if any database programmer wants to be successful on this topic, they can start with learning these basic methods to improve their skill.

Tuning 86

Tuning Servers Database Performance 86

Scalegrid

NOVEMBER 20, 2019

There will be a short duration (tens of seconds) during which you will lose connectivity to your database due to the failover, but this can be overcome by having application-level retries. times higher when the index creation happened on the master server. Stay tuned for my follow-on blog post with more details!

Best Practices 239

Best Practices Latency Tuning Database 239

Dynatrace

AUGUST 29, 2023

Dynatrace has announced that it has successfully achieved the Google Cloud Ready – Cloud SQL designation for Cloud SQL, Google Cloud’s fully-managed, relational database service for MySQL, PostgreSQL, and SQL Server.

Google 246

Google Cloud Design Programming 246

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server.

Tuning 67

Tuning Servers Database Best Practices 67

Dynatrace

JULY 21, 2020

With the release of OneAgent 1.197, we’re announcing the Preview of our proven, end-to-end transaction visibility and automated anomaly detection for Java applications running on the z/OS WebSphere Application Server and on z/OS WebSphere Liberty. JDBC database connections. Stay tuned! IBM Java version 7. JMS messaging.

Java 257

Java Database Programming Government 257

SQL Shack

DECEMBER 8, 2020

Gaining experience in SQL query tuning can be very difficult and complicated for database developers or administrators. For this reason, in this article, we will work on a case study and we are going to learn how we can tune its performance step by step. In this fashion, we will understand well how to approach […].

Tuning 91

Tuning Servers Database Performance 91

Percona

MARCH 23, 2023

When it comes to enterprise-level databases, there are several options available in the market, but PostgreSQL stands out as one of the most popular and reliable choices. PostgreSQL is a free and open source object-relational database management system (ORDBMS) that has existed since the mid-1990s.

Database 139

Database Open Source Traffic Small Business 139

SQL Shack

APRIL 19, 2021

In this article, we’ll show a process for SQL Server performance tuning, and several tools, tips and techniques you can use to monitor performance and take the necessary steps to improve it. SQL Server is a common platform for enterprise-grade database workloads.

Tuning 70

Tuning Servers Performance Database 70

Dynatrace

JUNE 16, 2022

A centralized approach to WAF uses a single firewall to protect many application servers against large-scale distributed attacks. Conversely, a decentralized approach protects application servers using multiple firewalls to protect against attacks that may have penetrated the network. More time for vulnerability management.

Tuning 246

Tuning Cloud Open Source Network 246

Percona

OCTOBER 10, 2023

Databases are different from a lot of software. This is not a general rule, but as databases are responsible for a core layer of any IT system – data storage and processing — they require reliability. Why choose Percona Server for MongoDB? Why release Percona Server for MongoDB 7 now?

Servers 120

Servers Availability Database Open Source 120

Dynatrace

FEBRUARY 14, 2022

Among these, you can find essential elements of application and infrastructure stacks, from app gateways (like HAProxy), through app fabric (like RabbitMQ), to databases (like MongoDB) and storage systems (like NetApp, Consul, Memcached, and InfluxDB, just to name a few). Many technologies expose their metrics in the Prometheus data format.

Technology 246

Technology Technology Metrics Infrastructure 246

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? Sysbench ran on a third server, which I’ll refer to as the application server (APP).

Tuning 145

Tuning Cache Servers Benchmarking 145

Percona

APRIL 14, 2023

Below, we outline some proactive steps for achieving cost efficiency and maintaining performant database environments amid a turbulent economy: 1. Here are a few ways you can scale down and save: Audit your systems: Auditing your system for unused servers and eliminating those servers can reduce your cloud spend.

Database 98

Database Serverless Tuning Cloud 98

Percona

AUGUST 29, 2018

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are configured according to the database server and its workload.

Tuning 79

Tuning Database Servers Processing 79

Dynatrace

MAY 17, 2023

Think about items such as general system metrics (for example, CPU utilization, free memory, number of services), the connectivity status, details of our web server, or even more granular in-application tasks like database queries. Let’s click “Apache Web Server apache” now.

Metrics 243

Metrics Database Monitoring Network 243

SQL Performance

APRIL 15, 2020

SQL Server has always provided the ability to capture actual queries in an easily-consumable rowset format – first with legacy SQL Server Profiler, later via Extended Events, and now with a combination of those two concepts in Azure SQL Database. Enter the New SQL Server Profiler. Legacy Profiler "Standard" trace events.

Azure 96

Azure Database Tuning Network 96

Dynatrace

JULY 3, 2019

Anything you want to do on a web server, you can do with PHP. Here are some statistics: PHP now accounts for about 79% of the server-side programming used on the Internet. We’ve significantly improved database sensor performance for PHP monitoring as well. So, stay tuned for news about: MongoDB sensors for PHP monitoring.

Monitoring 203

Monitoring Ecommerce Internet Internet 203

Dynatrace

SEPTEMBER 29, 2021

A standard Docker container can run anywhere, on a personal computer (for example, PC, Mac, Linux), in the cloud, on local servers, and even on edge devices. Running containers : Docker Engine is a container runtime that runs in almost any environment: Mac and Windows PCs, Linux and Windows servers, the cloud, and on edge devices.

Open Source 334

Open Source Traffic DevOps Cloud 334

SQL Server According to Bob

SEPTEMBER 9, 2019

A handful of lock types (Database, Metadata, LOGIN_STATS, …) are eligible for lock partitioning. For example: When ‘use database’ takes place the session acquires a shared lock on database. Only distinct changes require an exclusive database lock, for example a drop database.

Servers 103

Servers Database Scalability Tuning 103

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 111

Open Source Database Strategy Hardware 111

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Some servers may need a few GBs of RAM, while others may need hundreds of GBs or even terabytes of RAM. Benchmark before you decide.

Performance 144

Performance Hardware Tuning Storage 144

Dynatrace

JANUARY 26, 2021

Within this paradigm, it is possible to run entire architectures without touching a traditional virtual server, either locally or in the cloud. REST APIs, authentication, databases, email, and video processing all have a home on serverless platforms. Serverless resources are highly flexible and are customized based on the application.

Serverless 246

Serverless Efficiency Lambda AWS 246

Scalegrid

OCTOBER 7, 2019

As this open source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. of enterprise organizations on average.

Strategy 182

Strategy Cloud Java Open Source 182

The Netflix TechBlog

FEBRUARY 18, 2022

To this end, we developed a Rapid Event Notification System (RENO) to support use cases that require server initiated communication with devices in a scalable and extensible manner. This separation allows us to tune system configuration and scaling policies independently for different event priorities and traffic patterns.

Systems 334

Systems Traffic Architecture Mobile 334

Dynatrace

APRIL 8, 2021

This means that there is no need to provision or manage servers (or even containers). When using Lambda, you might soon end up using more serverless offerings, like databases, which makes emulating the same environment locally even harder. So, stay tuned for more blog posts and announcements. Auto scaling. Failure retries.

Lambda 246

Lambda AWS Serverless Monitoring 246

Dynatrace

APRIL 8, 2021

This means that there is no need to provision or manage servers (or even containers). When using Lambda, you might soon end up using more serverless offerings, like databases, which makes emulating the same environment locally even harder. So, stay tuned for more blog posts and announcements. Auto scaling. Failure retries.

Lambda 246

Lambda AWS Serverless Monitoring 246

The Netflix TechBlog

OCTOBER 8, 2024

Note: Contrary to what the name may suggest, this system is not built as a general-purpose time series database. Partitioning Scheme At Netflix’s scale, the continuous influx of event data can quickly overwhelm traditional databases. We do not use it for metrics, histograms, timers, or any such near-real time analytics use case.

Latency 237

Latency Storage Traffic Tuning 237

Percona

MAY 1, 2023

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload.

Tuning 52

Tuning Database Efficiency Performance 52

Dynatrace

SEPTEMBER 20, 2019

Stay tuned for further updates! Within minutes you can download and deploy a single Dynatrace node, (or cluster of nodes) that contains all the key components needed to run Dynatrace (no requirement for separate databases). Dynatrace Managed. So, it’s great that a FedRAMP certified offering is coming, but what about today?

Software 180

Software Software Government Logistics 180