MySQL / MariaDB DBA

High Availability & Clustering

Question

Asynchronous replicas versus a consensus-based cluster: which HA guarantee differs?

Answer

Asynchronous replication can leave acknowledged transactions absent from a failover candidate. Group Replication and Galera coordinate transactions across a group, trading write latency and operational constraints for stronger failover consistency. Use asynchronous replicas for scale-out or DR; clusters for coordinated HA. Applies to MySQL and MariaDB.

This is 6 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples