Percona

OCTOBER 10, 2023

When on-prem or DBaaS like RDS or Cloud SQL, it is relatively straightforward to apply a change. You can perform a DIRECT ALTER, use a tool such as pt-osc, or even, for certain cases where async replication is in use, perform changes on replicas and failover. HaProxy was acting as a load balancer in front of the cluster.

Database 93

Database Performance C++ Engineering 93

SQL Shack

SEPTEMBER 4, 2020

In the 18th part of the SQL Server Always On Availability Group series, we will discuss the cross-database MSDTC support in an availability group.

Availability 56

Availability Database Servers 56

SQL Shack

MAY 27, 2019

In this article, we will explore configuring Read Scale Availability Group that does not require a failover clustering configuration. It helps to scale read-only connections to the secondary replica in a cluster less configuration. It requires […].

Availability 49

Availability Servers 49

SQL Server According to Bob

FEBRUARY 9, 2020

SQL Server BDC Hints and Tips: Contained AGs, Ports, containedag_msdb, ​​ logs, ​​ … This blog ​​ post ​​ focuses on connecting to the SQL Server BDC, ​​ some ​​ helpful ​​ log files ​​ and utility outputs.

Servers 40

Servers Database Availability Azure 40

Percona

AUGUST 15, 2023

In this blog post, I provide an in-depth introduction to MySQL Replication, answering what it is, how it works , its benefits and challenges, as well as reviewing some of the MySQL replication concepts that are part of the MySQL environment (and Percona Server for MySQL specifically). Set the server-id to a unique value.

Servers 52

Servers Database Availability Traffic 52

Percona

AUGUST 30, 2023

Key elements of comprehensive database recovery plans include point-in-time recovery, high availability and failover, replication, and others (we’ll break them down in a bit). SQL Server Management Studio: This software includes backup and recovery tools for use with Microsoft SQL Server.

Database 85

Database Hardware Open Source Strategy 85

Percona

AUGUST 17, 2023

This blog post will cover the basic setup of the InnoDB ClusterSet environment, which provides disaster tolerance for InnoDB Cluster deployments by associating a primary InnoDB Cluster with one or more replicas in alternate locations/different data centers. Here, we have configured a new user "iroot" for cluster deployment.

C++ 74

C++ Availability Processing Database 74

Percona

FEBRUARY 2, 2023

These days, the typical PostgreSQL cluster consists not only of a multi-node replication cluster, which is ordinarily an asynchronous streaming replication model but can sometimes include a logical replication component. The only real limitation is that one can only publish tables from a read-write server such as the PRIMARY.

Games 87

Games Open Source Tuning Speed 87

Percona

AUGUST 25, 2023

This blog post will focus on failover and recovery scenarios inside the InnoDB Cluster and ClusterSet environment. To know more about the deployments of these topologies, you can refer to the manuals – InnoDB Cluster and Innodb ClusterSet setup. 3309' as the primary instance of cluster 'Cluster1'. MySQL 127.0.0.1:3308

Traffic 75

Traffic Database C++ Servers 75

Scalegrid

AUGUST 22, 2019

In our previous blog posts, we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by Cluster Labs and Replication Manager (repmgr) by 2ndQuadrant. Managing High Availability in PostgreSQL – Part I: PostgreSQL Automatic Failover. Patroni for PostgreSQL. Bootstrap configuration.

Availability 277

Availability Servers Network Open Source 277

Percona

FEBRUARY 24, 2023

In the Home Dashboard of PMM, a low CPU utilization on any of the database services that are being monitored could mean that the server is inactive or over-provisioned. Marked in red in Figure 1 is a server with less than 30% of CPU usage. vacuumdb is a wrapper around the SQL command VACUUM.

Cloud 117

Cloud Serverless AWS Storage 117

Percona

JULY 1, 2023

The continuous synchronization between the primary and replica ensures real-time redundancy, and if a disruption occurs in the primary, Aurora seamlessly switches to the replica with automatic failover, providing for uninterrupted availability. Failover is a manual process and may result in last-minute data loss. What is Amazon RDS?

AWS 52

AWS Database Serverless Storage 52

Scalegrid

MARCH 12, 2019

In our previous blog post, Managing High Availability in PostgreSQL – Part I , we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by ClusterLabs. repmgr is an open-source tool suite developed by 2ndQuadrant for managing replication and failover of your PostgreSQL clusters. How it Works.

Availability 147

Availability Servers Open Source Database 147

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations.

Servers 40

Servers Cache Media Hardware 40

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40