Categories
Products
Technologies
Top Rated docs

March 9, 2020

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...

March 2, 2020

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...

January 20, 2020

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...

July 10, 2018

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,...

November 21, 2017

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...

April 19, 2017

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...

Subscribe below to be notified of fresh posts