Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Apply (1) filters
54 blog posts in 1 category

Running Multiple PostgreSQL Instances on a Single Host

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.

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.

MariaDB MaxScale Load Balancing on Docker: Management - Part 2

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.

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 Automate Database Failover with ClusterControl

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.

An Overview of Streaming Replication for TimescaleDB

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.

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.

Master High Availability Manager (MHA) Has Crashed! What Do I Do Now?

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.

Understanding the Effects of High Latency in High Availability MySQL and MariaDB Solutions

To insulate our database infrastructure from failures, we build redundant cluster systems. For instance, MySQL and MariaDB high availability can be implemented by master-slave as well as master-master replication solutions. There are a number of variables that affect our choice solution. In this blog, we will look into considerations around latency.