Database Disaster Recovery Using Cluster-to-Cluster Replication

Replication between two clusters is not the same thing as extending a cluster to run across two datacenters. When setting up replication between two clusters, you must separate the systems to that they can operate autonomously. Replication is then used to keep them in sync, so that the slave system has an updated state and can take over. 

Disaster recovery in general relies on two key factors which are

  • Backups (and recovery)
    • Backing up and being able to recover an organization’s data / databases is the most important responsibility an (IT) operations team has.
       
  • Disaster Tolerance
    • Business critical applications and databases are usually deployed on two or more different locations whether it is in on-premise data centers or in public clouds. A switchover is then done upon failures.

A third often overlooked factor is consistently verifying that backups are actually restorable. There are several public cases where backups have been turned out to be corrupt and un-restorable when disaster actually strikes.

Cluster to Cluster Database Replication for Disaster Recovery
 

ClusterControl provides a complete enterprise grade backup management including verification. Backups can be taken as full, incremental or partial with offsite shipping to S3 compliant cloud storage providers. Offsite backups can be used to restore to a secondary site from scratch however it will take longer time (RTO) to provision and get the application/database back online. This is the most cost effective solution for applications that are not business critical.

In cases where Recovery Time Objectives - RTO is critical, database resilience is achieved by replicating from the primary database cluster in one location to a secondary database cluster in another location.

ClusterControl supports the following resilience options out of the box:

  • Active - Active clusters (Asynchronous Replication)
    • MySQL Galera
    • MySQL NDB Cluster
  • Active - Active clusters (Semi-synchronous Replication)
    • MySQL Galera
  • Active - Standby (or Master - Slave) clusters
    • MySQL Galera
    • MySQL Replication
    • PostgreSQL

Cluster-to-Cluster replication can also be used in many other use cases such as:

  • Migrating to a new datacenter
  • Geo-location performance - keep data closer to a set of users for that region
  • Replicating production to a dev/test environment for troubleshooting
  • Replicate and test a newer version of the database before doing a switchover
  • Use a secondary cluster for read-only access for reports or analytics

Hands-on PostgreSQL Cluster-to-Cluster Replication Demonstration

 

Related Resources

Explore All ClusterControl Features

Backup & Management

ClusterControl’s comprehensive backup management provides continuous data protection for your open source databases across local and cloud environments.

Monitoring & Alerting

ClusterControl provides a unified view of all your database deployments across multiple datacenters, letting you see the big picture or drilling down into individual nodes.

Deployment & Scaling

ClusterControl’s point-and-click interface lets you automate deployment and scaling of database setups securely to get production-ready environments up and running in a very short time.

Upgrades & Patching

ClusterControl ensures your databases stay up-to-date and compliant, reducing maintenance time by helping you apply upgrades and patches using battle-tested procedures.

Security & Compliance

ClusterControl ensures that your open source database deployments always adhere to the security model setups for each technology and keeps your critical data safe through encryption.

Operational Reporting

ClusterControl provides you with comprehensive operational reports on the health and stability of your database operations.

Configuration Management

ClusterControl makes configuring your databases easy by providing you battle-tested templates as well as making it easy to edit the configuration for your unique setup.

Automatic Recovery & Repair

The advanced automated failover technology in ClusterControl ensures your mission critical applications achieve high availability with zero downtime.

Performance Management

ClusterControl provides advanced monitoring and reporting features to let you easily keep a close eye on the performance of your database setups.

Cloud

ClusterControl lets you deploy and run highly-available database clusters to AWS, Microsoft Azure or Google Cloud.

ClusterControl

The only management system you’ll ever need to take control of your open source database infrastructure.