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...
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 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...
Building a MySQL or MariaDB Database Cold Standby on Amazon AWS
High Availability is a must these days as most organizations can’t allow itself to lose its data. High Availability, however, always comes with a price tag (which can vary a lot.) Any setups which require...
Running Multiple PostgreSQL Instances on a Single Host
We recently announced the release of ClusterControl 1.7.3 which includes a variety of improvements and newly added features. One of these new features is the addition of support in ClusterControl to allow a user to...
How to Use the Failover Mechanism of MaxScale
Ever since ClusterControl 1.2.11 was released in 2015, MariaDB MaxScale has been supported as a database load balancer. Over the years MaxScale has grown and matured, adding several rich features. Recently MariaDB MaxScale 2.2 was...
MariaDB MaxScale Load Balancing on Docker: Management: Part Two
This blog post is a continuation of MariaDB MaxScale Load Balancing on Docker: Deployment - Part1. In this part, we are going to focus more on management operations with advanced use cases like service control,...
Top Common Issues with MHA and How to Fix Them
In our previous blogs, we discussed MHA as a failover tool used in MySQL master-slave setups. Last month, we also blogged about how to handle MHA when it crashed. Today, we will see the top...