1.安装相关的插件
show plugins; 查看模块
help --uninstall; 查看卸载模块
master:
mysql> install plugin rpl_semi_sync_master soname 'semisync_master.so'; --安装 semisync_master.so插件
Query OK, 0 rows affected (0.03 sec)
slave:
root@localhost [zw3306]>install plugin rpl_semi_sync_slave soname 'semisync_slave.so'; --安装 semisync_slave.so插件
Query OK, 0 rows affected (0.00 sec)
root@localhost [zw3306]>install plugin rpl_semi_sync_master soname 'semisync_master.so';
Query OK, 0 rows affected (0.00 sec)
2.修改的参数:
set global rpl_semi_sync_master_enabled=1;
set global rpl_semi_sync_master_timeout=1000;
set global rpl_semi_sync_slave_enabled=1;
也可以直接写到配置文件 [mysqld]
master:
[mysqld]
rpl_semi_sync_master_enabled = 1
rpl_semi_sync_master_timeout = 1000 # 1 second
slave:
[mysqld]
rpl_semi_sync_slave_enabled = 1
修改了参数需要重启:
查看修改的参数
master:
mysql> show global variables like '%rpl_semi%';
+-------------------------------------------+------------+
| Variable_name | Value |
+-------------------------------------------+------------+
| rpl_semi_sync_master_enabled | ON |