31.10.2 配置半同步复制
1.配置主库
(1)在主库上安装rpl_semi_sync_master插件。
mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
Query OK, 0 rows affected (0.12 sec)
(2)查看主库上的rpl_semi_sync_master插件是否已经激活。
mysql> SELECT plugin_name, plugin_status
-> FROM information_schema.plugins
-> WHERE plugin_name LIKE '%semi%';
+----------------------+---------------+
| plugin_name | plugin_status |
+----------------------+---------------+
| rpl_semi_sync_master | ACTIVE |
+-----