Group Replication
MySQL Group Replication provides synchronous, multi-primary replication with built-in conflict detection and automatic failover.
MySQL
Advanced
5 min read
Group Replication
Example
-- my.cnf for Group Replication
-- plugin_load_add = group_replication.so
-- group_replication_group_name = "UUID-here"
-- group_replication_start_on_boot = off
-- group_replication_local_address = "host:33061"
-- group_replication_group_seeds = "host1:33061,host2:33061,host3:33061"
-- Enable plugin
INSTALL PLUGIN group_replication SONAME "group_replication.so";
-- Bootstrap (first member only)
SET GLOBAL group_replication_bootstrap_group = ON;
START GROUP_REPLICATION;
SET GLOBAL group_replication_bootstrap_group = OFF; Pro Tip
Group Replication requires odd number of members (3, 5, 7) for quorum-based consensus.