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.