Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
23 blog posts in 13 categories

How to Use the Failover Mechanism of MaxScale

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.

Top Common Issues with MHA and How to Fix Them

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.

How to Perform a Failback Operation for MySQL Replication Setup

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.

How to Achieve Automatic Failover for TimescaleDB

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.

PostgreSQL Replication for Disaster Recovery

This blog explains how to utilize streaming replication and point in time recovery to achieve high availability using failover.

Introduction to Failover for MySQL Replication - the 101 Blog

With this blog post we aim to give you an introduction to failover handling in MySQL & MariaDB by discussing what failover is, why it is unavoidable and what the difference is between failover and switchover. We also discuss the failover process in its most generic form and touch a bit on different issues that you will have to deal with in relation to the failover process.

Asynchronous Replication Between MySQL Galera Clusters - Failover and Failback

Asynchronous replication places no low latency demands on the network, so it is possible to keep Galera Clusters in sync even when they are thousands of miles apart and utilise low-cost connections. We effectively can achieve a global system of loosely-coupled clusters. However, managing the global state translates into managing failover and failback operations at both node and cluster level.

Failover for PostgreSQL Replication 101

Failover is a procedure that we hope we won’t have to use, but we must know how it works. In this blog, we will be cover the basic definitions of failover in PostgreSQL replication, and some example scenarios where failover can be useful.

Controlling Replication Failover for MySQL and MariaDB with Pre- or Post-Failover Scripts

Databases are a part of a wider mesh of infrastructure components, and as such, failover usually has some impact on more than just the database. Therefore, the failover software needs a mechanism to orchestrate changes across the infrastructure. This blog post describes how ClusterControl can be integrated with external infrastructure and tools, through the use of scripts executed during failover process.

How to Control Replication Failover for MySQL and MariaDB

Automated failover is a critical functionality in a MySQL or MariaDB replication setup, involving master-promotion and reslaving. Now, not all slaves are good master candidates, so how do you control which node gets picked? This blog introduces whitelists and blacklists.

Pages