Scalegrid

AUGUST 26, 2020

Microsoft Azure is one of the most popular cloud providers in the world, and a natural fit for database hosting on applications leveraging Microsoft across their infrastructure. MySQL is the number one open source database that’s commonly hosted through Azure instances. We measure latency in ms 95th percentile latency.

Azure 299

Azure Benchmarking Database Latency 299

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 261

Strategy Database Scalability Performance 261

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 5, 2023

Running Databases efficiently is crucial for business success Monitoring databases is essential in large IT environments to prevent potential issues from becoming major problems that result in data loss or downtime. However, horizontal scaling of these databases can take time and effort.

Database 210

Database Metrics Monitoring Servers 210

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 Database 274

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. Similar to the tutorial extension, we created an extension that performs queries against databases.

Database 276

Database Artificial Intelligence Metrics Monitoring 276

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 192

Database Monitoring Games Metrics 192

DZone

OCTOBER 9, 2022

Witness Server and Witness Directory are the most critical components of the Database Availability Group (DAG). DAG requires Witness Server or File Share Witness (FSW) and Directory to maintain the Quorum. In case of Witness Server failure, the Quorum is no longer maintained, leading to inconsistent DAG.

Servers 242

Servers Database Availability 242

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

Dynatrace

NOVEMBER 4, 2024

Monitoring the health and performance of your databases is essential to ensuring optimal application functionality. While infrastructure-level monitoring provides valuable insights, it might not reveal the root causes of database-related slowdowns. Top Queries and Execution Plans are available in the Databases app.

Database 190

Database Performance Metrics Monitoring 190

DZone

OCTOBER 26, 2021

Database Availability Group (DAG) is a built-in framework in Microsoft Exchange Server that uses continuous replication and failover clustering to ensure high availability and site resilience. In DAG, there is one active server and a copy of the database on the active server is replicated across all passive servers.

Servers 188

Servers Database Availability Performance 188

Dynatrace

DECEMBER 9, 2020

If you’re running SAP, you’re likely already familiar with the HANA relational database management system. However, if you’re an operations engineer who’s been tasked with migrating to HANA from a legacy database system, you’ll need to get up to speed quickly. Avoid false positives with auto-adaptive baselining.

Infrastructure 209

Infrastructure Database Monitoring Metrics 209

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

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 124

Database Servers Testing Programming 124

DZone

FEBRUARY 9, 2024

SQL Server Always on availability group is a great addition to SQL Server for providing high availability and disaster recovery. Always-on availability group support failover the environment for a discrete set of user databases, known as availability databases, that failover together.

Availability 288

Availability Database Servers 288

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

DZone

SEPTEMBER 25, 2023

The error is like this one: Msg 26019, Level 16, State 1, Line 1 BACKUP detected corruption in the database log. This error usually happens when you are doing a backup of the transaction log. Check the errorlog for more information. BACKUP LOG is terminating abnormally.

Database 147

Database Servers 147

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. The primary server is responsible for handling all write operations and maintaining data accuracy.

Availability 257

Availability Servers Database Open Source 257

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? pgAdmin uses too many resources.

Open Source 262

Open Source Database Azure Servers 262

High Scalability

SEPTEMBER 3, 2019

Redis , short for Remote Dictionary Server, is a BSD-licensed, open-source in-memory key-value data structure store written in C language by Salvatore Sanfillipo and was first released on May 10, 2009. Depending on how it is configured, Redis can act like a database, a cache or a message broker.

Open Source 55

Open Source Cache C++ Database 55

High Scalability

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.

Servers 187

Servers Programming Monitoring Availability 187

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.

Testing 55

Testing Network Database Servers 55

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. All of these tests were performed while the application was running and inserting data to the PostgreSQL database. Standby Server Tests. Reboot the server. Master/Primary Server Tests.

Availability 277

Availability Servers Network Testing 277

DZone

FEBRUARY 15, 2023

Nowadays, many people migrate their applications from traditional, single-server relational databases to distributed database clusters. 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.

Open Source 298

Open Source Scalability Database Servers 298

High Scalability

FEBRUARY 17, 2021

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. I have used latest versions for each NoSQL DB and have followed the recommendations to run all the databases in optimized conditions. About YCSB.

Benchmarking 308

Benchmarking Latency C++ Database 308

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

JULY 11, 2022

If you are a software developer, sooner or later you’ll have to connect to a Linux machine to perform administrative tasks, access remote database servers, or deploy applications, among other things. Getting comfortable using the command-line interface (CLI) is a must if you want to be proficient with Linux.

Virtualization 278

Virtualization Database Servers Software 278

Dynatrace

JANUARY 16, 2023

The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. On-premises data centers invest in higher capacity servers since they provide more flexibility in the long run, while the procurement price of hardware is only one of many cost factors. Databases : Among databases, Redis is the most used at 60%.

Open Source 349

Open Source Java Operating System Programming 349

High Scalability

JANUARY 8, 2020

It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. When it comes to connection pooling in the PostgreSQL world, PgBouncer is probably the most popular option.

Database 48

Database Servers Open Source Cache 48

Scalegrid

JULY 8, 2020

If the script has already performed writes to the server and must still be killed, use the SHUTDOWN NOSAVE to shutdown the server completely. In fact, this discussion applies to any high availability system that depends on polling the Redis servers for health: Long-running scripts will initially block client commands.

Servers 239

Servers Database Availability Monitoring 239

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

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 248

Latency Storage Cache Efficiency 248

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 96

Servers Database Cache C++ 96

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

Scalegrid

DECEMBER 6, 2023

In the digital age, data management has transformed from locally hosted servers to cloud solutions. The choice of self-managed cloud databases vs DBaaS is a common debate among those who are looking for the best option that will cater to their particular needs.

Database 130

Database Cloud Hardware Storage 130

DZone

NOVEMBER 21, 2023

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. Paired with Prometheus exporters, the tool can adapt to a variety of surroundings, which is one of its strongest points.

Best Practices 291

Best Practices Scalability Monitoring Database 291

DZone

MARCH 4, 2023

In any organization, it is a best security practice to have an SSL certificate installed on servers, applications, and databases. SSL Certificates and CA make communication secure between client and server or application. We will use a Windows server for it. You can use any number of SSL certificates free of cost.

Servers 130

Servers Database Systems 130