semisynchronous replication

1. install. (8.0.26 이후)

1) master (source)

INSTALL PLUGIN rpl_semi_sync_source SONAME 'semisync_source.so';

 

2) replica

INSTALL PLUGIN rpl_semi_sync_replica SONAME 'semisync_replica.so';

 

2. replication enable

1) source

INSTALL PLUGIN rpl_semi_sync_replica SONAME 'semisync_replica.so';

 

2) replica

SET GLOBAL rpl_semi_sync_replica_enabled = 1;

 

 

3. io replica restart (replica)

STOP REPLICA IO_THREAD;

START REPLICA IO_THREAD;

 

restart 이후에도 유지하고 싶으면 my.cnf에 등록해야함.