How to Rebuild an Inconsistent MySQL Slave?
MySQL slaves may become inconsistent. You can try to avoid it, but it’s really hard. Setting super_read_only and using row-based replication can help a lot, but no matter what you do, it is still possible...
How to Rebuild an Inconsistent PostgreSQL Slave
PostgreSQL Streaming Replication is a great way of scaling PostgreSQL clusters and doing it adds high availability to them. As with every replication, the idea is that the slave is a copy of the master...
Rebuilding a MySQL 8.0 Replication Slave Using a Clone Plugin
With MySQL 8.0 Oracle adopted a new approach to development. Instead of pushing features with major versions, almost every minor MySQL 8.0 version comes with new features or improvements. One of these new features is...
How to Recover MySQL Galera Cluster From an Asynchronous Slave
Introduction When running Galera Cluster, it is a common practice to add one or more asynchronous slaves in the same or in a different datacenter. This provides us with a contingency plan with low RTO,...
ClusterControl 1.5 – Automatic Backup Verification, Build Slave From Backup and Cloud Integration
At the core of ClusterControl is its automation, as is ensuring that your data is is securely backed up and ready for restoration whenever something goes wrong. Having an effective backup strategy and disaster recovery...
How to Deploy Asynchronous Replication Slave to MariaDB Galera Cluster 10.x
Combining Galera and asynchronous replication in the same MariaDB setup, aka Hybrid Replication, can be useful - e.g. as a live backup node in a remote datacenter or reporting/analytics server. We already blogged about this...