by Julia Vural | Jun 26, 2025 | Insight for DBAs, MySQL, Open Source, Percona Software
At Percona, we’ve always been dedicated to providing robust, open source high availability solutions that meet our users’ evolving needs. Percona XtraDB Cluster (PXC) stands as a testament to this commitment, offering a highly available and scalable solution for...
by Pete Scott | Mar 7, 2025 | Insight for DBAs, PostgreSQL
This post was originally published in July 2023 and updated in March 2025. With the average cost of unplanned downtime running from $300,000 to $500,000 per hour, businesses increasingly rely on high availability (HA) technologies to maximize application uptime....
by Roberto De Bem | Jan 22, 2025 | Insight for DBAs, MySQL
Large tables can pose challenges for many operations when working with a database. Occasionally, we may need to modify the table definition. Since RDS replication does not use asynchronous for its replication, the typical switchover procedure is not feasible. However,...
by Agustin Palazuelos | Sep 11, 2024 | Insight for DBAs, MongoDB
MongoDB high availability is essential to ensure reliability, customer satisfaction, and business resilience in an increasingly interconnected and always-on digital environment. Ensuring high availability for database systems introduces complexity, as databases are...
by Anil Joshi | Aug 14, 2024 | Insight for DBAs, MySQL, Percona Software, Storage Engine
Group replication is a fault-tolerant/highly available replication topology that ensures if the primary node goes down, one of the other candidates or secondary members takes over so write and read operations can continue without any interruptions. However, there are...
by Matthew Boehm | May 29, 2024 | Insight for DBAs, Percona Software, Valkey
In most database systems, like MySQL, PostgreSQL, and MongoDB, replication of some kind is used to create a highly available architecture. Valkey/Redis is no different in this regard. Replication is native functionality to Valkey, supporting multiple replicas, and...
by Roma Novikov | May 21, 2024 | Insight for DBAs, Monitoring, Percona Software
Ensuring your monitoring system stays up and running is vital. High availability (HA) minimizes downtime for Percona Monitoring and Management (PMM) during hardware failures, in times of disaster recovery, or increased usage of the tool. It’s not just about...
by Nurlan Moldomurov | May 8, 2024 | Insight for DBAs, Monitoring, Percona Software
Percona Monitoring and Management (PMM) has become a valuable tool for database professionals, providing comprehensive insights into database health and performance. A recent update (version 2.41.0) introduced a significant enhancement: the ability to run PMM in high...
by Michael Patrick | Feb 1, 2024 | Insight for DBAs
This blog was originally published in June 2016 but was updated in February 2024. In this blog post, we’ll look at various MySQL high availability (HA) solutions, detailing their advantages and disadvantages to equip you with the insight required for informed...
by Marco Tusa | Jan 11, 2024 | Benchmarks, MySQL, Percona Software, ProxySQL
In my previous article, Comparisons of Proxies for MySQL, I showed how MySQL Router was the lesser performing Proxy in the comparison. From that time to now, we had several MySQL releases and, of course, also some new MySQL Router ones. Most importantly, we also had...
by Daniel Guzmán Burgos | Dec 21, 2023 | Insight for DBAs, Insight for Developers, Monitoring, Percona Software
Percona Monitoring and Management (PMM) is a state-of-the-art piece of software that exists in part thanks to great open source projects like VictoriaMetrics, PostgreSQL, and ClickHouse. The integration of those projects, plus the years of Percona expertise in the...
by Pete Scott | Aug 22, 2023 | Benchmarks, Database Trends, Insight for DBAs
Estimates vary, but most reports put the average cost of unplanned database downtime at approximately $300,000 to $500,000 per hour, or $5,000 to $8,000 per minute. With so much at stake, database high availability and fault tolerance have become must-have items, but...
by Pete Scott | Jun 22, 2023 | Benchmarks, Insight for DBAs, Percona Software
To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. That doesn’t mean downtime is nonexistent, but it must be limited so that significant/irreparable damage (as defined by the business or...
by Pete Scott | Jun 12, 2023 | Insight for DBAs, MySQL, Percona Software, PostgreSQL
When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied....
by Sergey Pronin | Dec 14, 2021 | Cloud, Insight for Developers, Percona Software, PostgreSQL
Percona Distribution for PostgreSQL Operator allows you to deploy and manage highly available and production-grade PostgreSQL clusters on Kubernetes with minimal manual effort. In this blog post, we are going to look deeper into High Availability, Disaster Recovery,...
by Marco Tusa | Dec 9, 2021 | Insight for DBAs, MySQL, Percona Software
Percona XtraDB Cluster 8.0.25 (PXC) has introduced a new option to perform online schema modifications: NBO (Non-Blocking Operation). When using PXC, the cluster relies on the wsrep_OSU_method parameter to define the Online Schema Upgrade (OSU) method the node uses to...
by Marco Tusa | May 4, 2021 | Insight for DBAs, MySQL, Percona Software
AKA Cluster Error Voting… What is Cluster Error Voting (CEV)? “Cluster Error Voting is a new feature implemented by Alexey Yurchenko, and it is a protocol for nodes to decide how the cluster will react to problems in replication. When one or several nodes have...
by Marco Tusa | Apr 14, 2021 | Insight for DBAs, MySQL, Open Source, Percona Software
This blog provides high availability (HA) guidelines using group replication architecture and deployment recommendations in MySQL, based on our best practices. Every architecture and deployment depends on the customer requirements and application demands for high...
by Marco Tusa | Nov 30, 2020 | MySQL, Open Source, Percona Software, ProxySQL
How native ProxySQL stands in failover support (both v2.0.15 and v2.1.0) In recent times I have been designing several solutions focused on High Availability and Disaster Recovery. Some of them using Percona Server for MySQL with group replication, some using Percona...
by Rick Vasquez | Nov 17, 2020 | Database Trends, Insight for DBAs, Open Source, Percona Services
It’s that time of year! The Halloween decorations have come down and the leaves have started to change and the Black Friday/Cyber Monday buying season is upon us! For consumers, it can be a magical time of year, but for those of us that have worked in e-commerce or...
