DZone

SEPTEMBER 16, 2024

As applications grow in complexity and user base, the demands on their underlying databases increase significantly. Efficient database scaling becomes crucial to maintain performance, ensure reliability, and manage large volumes of data. This cheatsheet provides an overview of essential techniques for database scaling.

Strategy 263

Strategy Database Scalability Performance 263

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 260

Latency Storage Cache Efficiency 260

Dynatrace

FEBRUARY 1, 2024

Maintaining optimal application performance is crucial for businesses, and fast databases are vital in achieving this goal. For an effective approach to database performance, it’s crucial to have a comprehensive overview of all databases, including server-side DBs.

Database 246

Database Monitoring Games Metrics 246

Scalegrid

MAY 22, 2020

MySQL does not limit the number of slaves that you can connect to the master server in a replication topology. If the data churn on the master is high, the serving of binary logs alone could saturate the network interface of the master. Ripple is an open source binlog server developed by Pavel Ivanov.

Servers 262

Servers Transportation Database Availability 262

DZone

JUNE 28, 2023

Database sharding is a powerful technique employed to manage large databases more effectively. It involves partitioning a large database into smaller, more manageable parts, known as shards. The above diagram presents a visual representation of a sharded database.

Database 232

Database Scalability Servers Performance 232

Dynatrace

SEPTEMBER 8, 2023

In part 2, we’ll show you how to retrieve business data from a database, analyze that data using dashboards and ad hoc queries, and then use a Davis analyzer to predict metric behavior and detect behavioral anomalies. However, as we highlighted previously, business data can be significantly more complex than simple metrics.

Database 290

Database Artificial Intelligence Metrics Monitoring 290

DZone

FEBRUARY 25, 2023

We will show you exactly how to deploy a Nodejs app to the server using Docker containers, RDS Amazon Aurora, Nginx with HTTPS, and access it using the Domain Name. These APIs will be used to check the status of the app, insert data in the database and fetch and display the data from the database.

AWS 274

AWS Servers Internet Internet 274

Dynatrace

DECEMBER 9, 2020

If you’re running SAP, you’re likely already familiar with the HANA relational database management system. HANA maintains all the business and analytics data that your business runs on. Today we’re proud to announce that we’ve extended our SAP monitoring capabilities to support SAP HANA databases.

Infrastructure 246

Infrastructure Database Monitoring Metrics 246

Scalegrid

MARCH 10, 2025

A graphical user interface (GUI) helps simplify how you interact with your MySQL databases. Whether youre a developer, database administrator, or data analyst, a good GUI can make everyday tasks faster, clearer, and less error-prone. Thats where MySQL GUIs come in.

Open Source 162

Open Source Database Design Cloud 162

Scalegrid

OCTOBER 18, 2024

Structured Query Language (SQL) is a simple declarative programming language utilized by various technology and business professionals to extract and transform data. Facilitating remote access to other computers or servers with easier navigation.

Open Source 147

Open Source Database Cloud Operating System 147

Scalegrid

FEBRUARY 17, 2020

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. MySQL Master Server Health Checks. Important Health Checks for your MySQL Master-Slave Servers Click To Tweet.

Servers 273

Servers Monitoring Availability Programming 273

Scalegrid

FEBRUARY 27, 2025

Incremental Backups: Speeds up recovery and makes data management more efficient for active databases. Improved JSON Handling & Security: Improved logical replication and the new MAINTAIN privilege give database administrators more control and flexibility. Start your free trial today!

Speed 130

Speed Database Storage Efficiency 130

Percona

FEBRUARY 2, 2023

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 138

Database Servers Testing Programming 138

The Netflix TechBlog

OCTOBER 8, 2024

Rajiv Shringi Vinay Chella Kaidan Fullerton Oleksii Tkachuk Joey Lynch Introduction As Netflix continues to expand and diversify into various sectors like Video on Demand and Gaming , the ability to ingest and store vast amounts of temporal data — often reaching petabytes — with millisecond access latency has become increasingly vital.

Latency 239

Latency Storage Traffic Tuning 239

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events.

Database 221

Database Traffic Transportation Open Source 221

Dynatrace

APRIL 9, 2025

A critical security threat for cloud-native architectures SSRF is a web security vulnerability that allows an attacker to make a server-side application send requests to unintended locations. SSRF can lead to unauthorized access to sensitive data, such as cloud metadata, internal databases, and other protected resources.

Java 147

Java Programming Architecture Cloud 147

Dynatrace

MAY 17, 2023

OpenTelemetry , the open source observability tool, has become the go-to standard for instrumenting custom applications to collect observability telemetry data. For this third and final part of our series, we saved the best for last: How you can enhance telemetry data even more and with less effort on your end with Dynatrace OneAgent.

Metrics 243

Metrics Database Monitoring Network 243

Scalegrid

MAY 13, 2019

MySQL Server generates several logs that can help you monitor the activities of the server. Setting Up MySQL Server Logging. Managing MySQL Server Logs: Rotate, Compress, Retain & Delete Click To Tweet. MySQL Tutorial – Configuring and Managing SSL On Your MySQL Server.

Servers 247

Servers Best Practices Efficiency Availability 247

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events.

Database 206

Database Traffic Transportation Open Source 206

Dynatrace

OCTOBER 4, 2022

Software and data are a company’s competitive advantage. But for software to work perfectly, organizations need to use data to optimize every phase of the software lifecycle. The only way to address these challenges is through observability data — logs, metrics, and traces. Teams interact with myriad data types.

Analytics 246

Analytics Software Software Storage 246

Scalegrid

SEPTEMBER 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. Why Use a GUI Tool?

Open Source 262

Open Source Database Azure Cloud 262

Scalegrid

SEPTEMBER 5, 2024

Managing High Availability (HA) in your PostgreSQL hosting is very important to ensuring your database deployment clusters maintain exceptional uptime and strong operational performance so your data is always available to your application. It reduces downtime and supports business continuity.

Availability 257

Availability Servers Database Open Source 257

Dynatrace

JANUARY 16, 2023

The study analyzes factual Kubernetes production data from thousands of organizations worldwide that are using the Dynatrace Software Intelligence Platform to keep their Kubernetes clusters secure, healthy, and high performing. The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Java, Go, and Node.js

Open Source 358

Open Source Java Operating System Programming 358

Scalegrid

DECEMBER 16, 2020

Mysqldump is a client utility that is used to perform logical backups of the MySQL database. This popular migration tool is useful for various use cases of MySQL such as: Backup and restore of databases. Migrating data from one server to another. Migrating data across different managed MySQL service providers.

Best Practices 290

Best Practices Database Servers Performance 290

DZone

FEBRUARY 15, 2023

In this article, I’m going to demonstrate how you can migrate a comprehensive web application from MySQL to YugabyteDB using the open-source data migration engine YugabyteDB Voyager. Nowadays, many people migrate their applications from traditional, single-server relational databases to distributed database clusters.

Open Source 298

Open Source Scalability Database Servers 298

Scalegrid

MAY 2, 2019

It comes as no surprise that Python developers commonly leverage MongoDB hosting , the most popular NoSQL database , for their deployments due to its flexible nature and lack of schema requirements. It is also recommended that SSL connections be enabled to encrypt the client-database traffic. Testing Failover Behavior. import pymongo.

Testing 55

Testing Network Database Servers 55

High Scalability

FEBRUARY 17, 2021

This is guest post by Sachin Sinha who is passionate about data, analytics and machine learning at scale. This article is to simply report the YCSB bench test results in detail for five NoSQL databases namely Redis, MongoDB, Couchbase, Yugabyte and BangDB and compare the result side by side. Redis Server: 5.07, x86/64.

Benchmarking 308

Benchmarking Latency C++ Database 308

DZone

JANUARY 2, 2024

Sharding, a database architecture pattern, involves partitioning a database into smaller, faster, more manageable parts called shards. Each shard is a distinct database, and collectively, these shards make up the entire database. What Is Sharding?

Architecture 270

Architecture Database Scalability Servers 270

Dynatrace

OCTOBER 7, 2021

Serverless architecture shifts application hosting functions away from local servers onto those managed by providers. This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Data Store. Serverless architecture: A primer. Application integration.

Serverless 325

Serverless AWS Lambda Storage 325

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

Dynatrace

JULY 11, 2023

But observability data (traces) can fill in the blanks to reveal useful evidence of possible exploitation, as proved by our analysis of the MoveIT vulnerability using Dynatrace. When exploiting the vulnerability, attackers can gain remote code injection capabilities in the MOVEit server and modify or steal sensitive data from its database.

Database 189

Database Government Servers Games 189

Dynatrace

JANUARY 11, 2023

To stay competitive in an increasingly digital landscape, organizations seek easier access to business analytics data from IT to make better business decisions faster. As organizations add more tools, it creates a demand for common tooling, shared data, and democratized access. These technologies generate a crush of observability data.

Analytics 246

Analytics Strategy Storage Technology 246

DZone

NOVEMBER 21, 2023

Thanks to its expressive query language (PromQL), scalability, and configurable data format, it remains one of the most popular tools for data collection. With the help of exporters, Prometheus can provide insightful data and effectively monitor a variety of services, including databases, web servers, and custom-made applications.

Best Practices 291

Best Practices Scalability Monitoring Database 291

Percona

NOVEMBER 1, 2023

MySQL Server – Community Edition The problem applies to all versions of the upstream MySQL Community up to 8.0.23. Here is an example scenario you may end up here: mysql > select @@version,@@version_comment; + --+ + | @@version | @@version_comment | + --+ + | 5.7.43 | MySQL Community Server (GPL) | + --+ + 1 row in set (0.00

Servers 117

Servers Database Cache C++ 117

DZone

OCTOBER 1, 2023

As a distributed database, your data is partitioned into “shards” which are then allocated to one or more servers. Because of this sharding, a read or write request to an Elasticsearch cluster requires coordinating between multiple nodes as there is no “global view” of your data on a single server.

Open Source 257

Open Source Tuning Analytics Scalability 257

Dynatrace

JANUARY 11, 2023

As cloud and big data complexity scales beyond the ability of traditional monitoring tools to handle, next-generation cloud monitoring and observability are becoming necessities for IT teams. With agent monitoring, third-party software collects data and reports from the component that’s attached to the agent. Database monitoring.

Cloud 295

Cloud Monitoring Best Practices Infrastructure 295

Scalegrid

AUGUST 22, 2019

On the first node, Patroni initializes the database, obtains the leader lock from DCS, and ensures the node is being run as the master. This section contains the PostgreSQL-specific parameters like authentication, directory paths for data, binary and config, listen ip address etc. Standby Server Tests. Reboot the server.

Availability 277

Availability Servers Network Testing 277