My DBA is Sick – Database Failover Tips for SysAdmins
In case of a database failure, the best case scenario is that you have a good Disaster Recovery Plan (DRP) and a highly available environment with an automatic failover process in place. But what happens...
How ClusterControl Performs Automatic Database Recovery and Failover
ClusterControl is programmed with a number of recovery algorithms to automatically respond to different types of common failures affecting your database systems. It understands different types of database topologies and database-related process management to help...
Database Load Balancing in the Cloud – MySQL Master Failover with ProxySQL 2.0: Part Two (Seamless Failover)
In the previous blog we showed you how to set up an environment in Amazon AWS EC2 that consists of a Percona Server 8.0 Replication Cluster (in Master - Slave topology). We deployed ProxySQL and...
Failover & Failback for PostgreSQL on Microsoft Azure
It’s pretty common to use the cloud to store your data or as a failover option in the case of master failure. There are several cloud providers which allow you to store, manage, retrieve, and...
Comparing DBaaS Failover Solutions to Manual Recovery Setups
We have recently written several blogs covering how different cloud providers handle database failover. We compared failover performance in Amazon Aurora, Amazon RDS and ClusterControl, tested the failover behavior in Amazon RDS, and also on...
Failover & Failback on Amazon RDS
Previously we posted a blog discussing Achieving MySQL Failover & Failback on Google Cloud Platform (GCP) and in this blog we'll look at how it’s rival, Amazon Relational Database Service (RDS), handles failover. We will...
Using Backups to Fix Common Failure Scenarios for MongoDB
Production outages are almost guaranteed to occur at some point. Accepting this fact and analyzing the timeline and failure scenario of your database outage can help better prepare, diagnose, and recover from the next one....
Achieving MySQL Failover & Failback on Google Cloud Platform (GCP)
There are numerous cloud providers these days. They can be small or large, local or with data centers spread across the whole world. Many of these cloud providers offer some kind of a managed relational...
The Most Common PostgreSQL Failure Scenarios
There is not a perfect system, hardware, or topology to avoid all the possible issues that could happen in a production environment. Overcoming these challenges requires an effective DRP (Disaster Recovery Plan), configured according to...
Database Switchover and Failover for Drupal Websites Using MySQL or PostgreSQL
Drupal is a Content Management System (CMS) designed to create everything from tiny to large corporate websites. Over 1,000,000 websites run on Drupal and it is used to make many of the websites and applications...
Database Failover for WordPress Websites
Every profitable enterprise requires high availability. Websites & Blogs are no different as even smaller companies and individuals require their sites to stay live to keep their reputation. WordPress is, by far, the most popular...
Comparing Failover Times for Amazon Aurora, Amazon RDS, and ClusterControl
If your IT infrastructure is running on AWS, you have probably heard about Amazon Relational Database Service (RDS), an easy way to set up, operate, and scale a relational database in the cloud. It provides...