Recovery & Repair

In this blog post, we are going to walk you through the deployment of a cluster of two MariaDB shards using ClusterControl. We are going to deploy a handful of MariaDB servers (for redundancy and availability) to host a partitioned table based on a range of a selected shard key.

Append-only File, even if not enabled by default, has quite some importance in Redis. This blog sheds some light on why AOF was implemented in Redis and what it can be used for

In this blog post, we will look into how to perform hash slot maintenance operations for a Redis Cluster, which is commonly required for cluster scaling on the Redis Community server.

For a scalable and highly available setup app, Redis should be deployed in a centralized approach, or into a different tier called cache tier. This allows Redis instances to work together as a dedicated cache provider for the applications, decoupling the applications from the local Redis dependencies. In this example, we are going to deploy a simple highly available Redis architecture with Sentinel.

MySQL replication is easy to set up, but also easy to break! What do you do when replication stops, and will not restart? In cases where replication cannot be restarted, how do you failover to a new master? This blog post discusses some of the common replication issues in MySQL setups, and how to fix them with ClusterControl.

In this blog post we will discuss some options that you have to keep most of your application running even if your database environment suffers from a partial outage or from a slowdown.

Managing database deployments for high availability can be challenging when done manually. It is nearly impossible to take care of all aspects of databases like backups, security, and high availability without automation for industries that can't afford any downtime, like the healthcare industry. This blog discusses important points of database automation in the healthcare industry.

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 unbreakable private cloud or public cloud platforms, Disaster Recovery (DR) is indeed a key component in the business continuity when disaster strikes. In this blog post, we will look into different ways of designing your Galera Clusters for fault tolerance in a hybrid cloud environment.

Auto failover for your Moodle PostgreSQL database is an important part of high availability. In this blog, we are going to look into automatic failover for the Moodle PostgreSQL database using ClusterControl.

High availability Moodle requires a highly available database, and automatic failover plays a central role in minimizing the time to recover from a database failure. In this blog post, we will discuss how you can implement automatic failover for MySQL.

Backups are important in all Disaster Recovery Plans, but they don’t have any value if they are not usable. In this blog, we will see how to verify if your MySQL Backup is good to use in an easy way by using ClusterControl.

Oracle recently released MySQL 8.0.22, it included a new asynchronous connection failover mechanism which allows a replica to automatically establish an asynchronous replication connection to a new source, in case its existing one fails. 

Database migrations can be a hefty job to handle. This blog looks at tools which are freely available either to be used or to be extended in order to achieve your desired data migration activities.

Barman is a popular PostgreSQL backup and restore tool. Its feature-rich functionality set makes it a perfect consideration for disaster recovery deployments. The blog explores that side of this useful PostgreSQL tool.

Load balancers can be deployed into a number of topologies to achieve high availability for the database service with zero single-point-of-failure (SPOF). This blog post covers the pros and cons of distributed or centralized setup for your database load balancers.

A rollback is an operation which returns a database to a previous state. In this blog we will explore the features of MongoDB that help you prevent rollbacks.

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 in the event of an outage or catastrophe.

While temporary tables are short-lived, temporal tables on the other hand are designed to give access to the data over time. In this blog, we will take a look at temporal tables in MariaDB and how to use them.

Page fault errors occur at the moment MongoDB wants to get data that is not available in active memory of the database hence forced to read from disk, creating latency. This blog explores this issue and how to fix it.

In a PostgreSQL multi-cloud environment, if your primary node fails on your main cloud provider, you must be able to promote the standby node in a secondary one to keep the system running. In this blog, you will see why you need failover, how to do it manually, and how ClusterControl does it.

A multi-cloud environment is useful for geo-distributed topologies or even as part of a disaster recovery plan, but there is a risk of split-brain in this kind of scenario. In this blog, we will see what a split-brain is and how ClusterControl can help you to avoid this important issue.