Top Rated docs

June 9, 2021

Keeping Databases Up and Running in an Outage or Slowdown

Once you see that your database environment has issues, you are in trouble. Maybe one of your replicas is out or maybe you are experiencing a significant increase in the load across your databases that...

April 27, 2021

Database Automation Best Practices in the Healthcare Industry

Database management at scale can’t be done without proper automation techniques. Long gone are the days when database administrators were naming their database servers, spend days tuning and tweaking the configuration, ensuring that everything works...

March 18, 2021

Disaster Recovery for Galera Cluster Deployed to a Hybrid Cloud

Running a Galera Cluster in a hybrid cloud should consist of at least two different geographical sites, connecting hosts in the on-premises or private cloud with the ones in the public cloud. Whether you use...

January 28, 2021

Automatic Failover of the Moodle PostgreSQL Database

One of the key aspects of high availability is the ability to quickly react to failures. It is not uncommon to manually manage databases, and have monitoring software keep an eye on database health. In...

January 20, 2021

How to Setup Automatic Failover for the Moodle MySQL Database

In a previous blog, we had discussed how to migrate a standalone Moodle setup to scalable setup based on a clustered database.  The next step you will need to think about is the failover mechanism...

December 15, 2020

How to Verify Your MySQL Backups with ClusterControl

Backups are a basic point in all Disaster Recovery Plans, but only having a backup is not enough to guarantee correct data recovery. You must need to make sure that the backup is usable, and...

November 6, 2020

Asynchronous Replication Automatic Failover in MySQL 8.0.22

  Oracle recently released MySQL 8.0.22, and this new version came with a new asynchronous connection failover mechanism. It allows a replica to automatically establish an asynchronous replication connection to a new source, in case...

October 20, 2020

Top Open Source Tools for MySQL & MariaDB Migrations

Large organizations that are using MySQL or MariaDB database platforms are often faced with a need to perform a database migration from one place to another. Regardless of the platform, type of database software (such...

October 16, 2020

Using Barman for PostgreSQL Disaster Recovery

There must be many powerful tools available as a backup and restore option for PostgreSQL in general; Barman, PgBackRest, BART are to name a few in this context. What caught our attention was that Barman...

September 15, 2020

Database Load Balancing: Distributed vs Centralized Setups

A database load balancer, or database reverse proxy, distributes the incoming database workload across multiple database servers running behind it. The goals of having database load balancers are to provide a single database endpoint to...

August 28, 2020

How to Prevent Rollbacks in MongoDB

Replication in MongoDB involves replica sets by members with an architecture of a primary and secondary members but at times with a non data bearing member called an arbiter. The replication process is that, whenever...

August 14, 2020

Video: Database Disaster Recovery with ClusterControl

This past week we debuted a series of videos on database disaster recovery. From basic backup and restore, to switchover & failover, to full cluster-to-cluster replication, these videos show how ClusterControl offers you end-to-end protection...

Subscribe below to be notified of fresh posts