Recovery & Repair

Replicating your database cluster to a remote datacenter is key in achieving Disaster Recovery with minimal RTO and RPO, but there are other reasons like datacenter migration or geo distribution. However, if managing a cluster was not hard enough, setting up and managing replicated clusters takes complexity to another level. In this blog, we will have a peek at a new ClusterControl 1.7.4 feature that allows you to set up replication between clusters.

A hot standby is a common term in computing, especially on highly distributed systems. It's a method for redundancy in which one system runs simultaneously with an identical primary system. In this blog how you can create a Hot Standby Node on Amazon AWS for Galera Cluster 4.0 using MariaDB.

Master switches are very common operations in replication setups. They are part of every migration - from one environment to another, from older version of MySQL to more recent one. In a live production environment, you may want to reduce the impact they have on the application. If you wonder how to do it, we are here to help. In this first part we will go over the initial setup of the environment. In the upcoming next part we will explain the process of transparent master switch with ProxySQL.

Hosting your database with a cloud provider, such as Microsoft Azure, still requires you to prepare and define your disaster recovery policy. In this blog, we will cover all of the backup and restore methods Azure offers for MySQL.

Designing a large system that is fault-tolerant, highly-available, with no Single-Point-Of-Failure (SPOF) requires proper testing to determine how it would react when things go wrong. In this blog we will explore the failover and failback operations of Amazon RDS using Aurora.

In this blog post, we will analyze different failure scenarios in MongoDB production database systems, ranging from single-server issues to datacenter failover plans. We will walk you through recovery and failover procedures for the respective scenario.

Almost all cloud vendors provide some sort of high availability options in their managed relational databases. In this blog we are going to explore the failover handling for MySQL SQL nodes on Google Cloud Platform

In this blog we’ll take a look at the most common PostgreSQL failure scenarios and show you how you can solve or cope with the issues. We’ll also look at how ClusterControl can help us get back online

WordPress is, by far, the most popular CMS in the world powering millions of websites from small to large. But how can you ensure the unavailability of your database will not impact the website? In this blog post we will show how to achieve failover for your WordPress website using ClusterControl.

In this blog post, we compare automatic failover times for Amazon Aurora, Amazon RDS for MySQL, and MySQL Replication deployed and managed by ClusterControl. The type of failover that we are going to do is slave promotion in case of master goes down, where the most up-to-date slave takes over the master role in the cluster to resume the database service.

Disaster recovery environments can be expensive. Luckily, they don’t always have to be. This blog post explains how to us Amazon AWS to set up a DR solution on a shoestring budget.

The recent release of ClusterControl 1.7.3 offers new functionality which allows for a multi-postgresql installation on the same host. This type of setup can save you money and resources by running two instances on the same server. In this blog will show how to do it with ClusterControl.

A load balancer similar to the likes of ProxySQL & HAProxy, MariaDB MaxScale has its own diverse features and capabilities. MaxScale has the ability to do auto-failover which can save you from catastrophe as well as a switch over mechanism to make your life easier during maintenance. This blog explores this failover feature and how you can leverage it as part of your setup.

In the previous blog, we looked at how to deploy MaxScale on Docker, and how to use Swarm service to run multiple replicas. This part focuses more on management operations with advanced use cases like service control, configuration management, query processing, security and cluster reconciliation.

MHA (Master High Availability) is a popular failover solution used in MySQL Master-Slave topologies. It is stable and used in production by large companies such as Facebook. In this blog, we outline the most common but important issues that you might encounter when running MHA. We’ll also see how to resolve them.

It might not be possible to avoid disasters, but with some preparation, it is certainly feasible to reduce the impact on your business. Automatic failover is one of those things. The goal of database failover automation is to minimize your downtime and reduce loss of money. However, failover can not always be automated as there are risks; false positives may lead to unnecessary escalations.

In this blog, we’ll have a look components you may use to build an automated stack, and take a closer look at ClusterControl’s failover functionality.

TimescaleDB uses a stream of write-ahead log (WAL) records to keep the standby databases synchronized. In this blog, we’ll review some concepts related to Streaming Replication and how ClusterControl can help us configure it in an easy way.

In case of master failure in a MySQL Replication setup, the most updated slave can be promoted to new master and all slaves repointed to the new master. But once the failed master has been fixed, what is the best way to re-introduce it as master, so as to restore the original topology.

This blog post shows how to perform the MySQL master failback operation.

Failover is the process of moving to a healthy standby component, during a failure or maintenance event. The quicker it can be done, the faster you can be back online. If you’re looking at minimizing downtime and meet your SLAs through an automated approach for TimescaleDB, then this blog is for you.

How do I ensure that MHA (Master High Availability Manager) will always perform the failover for me? What would happen if it crashes? This blog post will answer your questions.