5.5
主节点
INSTALL PLUGIN rpl_semi_sync_master SONAME “semisync_master.so”;
从节点,
INSTALL PLUGIN rpl_semi_sync_slave SONAME “semisync_slave.so”;
show 插件;
显示类似说明安装成功,
|,rpl_semi_sync_master ,,, |, ACTIVE ,, |, REPLICATION ,,, |, semisync_master.so |, GPL ,, |
|,rpl_semi_sync_slave ,,,,, |, ACTIVE ,, |, REPLICATION ,,, |, semisync_slave.so , |, GPL ,,, |,,
mysql>, show variables like “%半%”;
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +
|,Variable_name ,,,,,,,,,,,,,,,,,,,,, |, Value |
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +
|,rpl_semi_sync_master_enabled ,,,,,, |, OFF , |
|,rpl_semi_sync_master_timeout ,,,,,, |, 10000 |
|,rpl_semi_sync_master_trace_level ,, |, 32岁,,,|
| |,rpl_semi_sync_master_wait_no_slave ,,, |
|,rpl_semi_sync_slave_enabled ,,,,,,, |, OFF , |
|,rpl_semi_sync_slave_trace_level ,,, |, 32岁,,,|
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + +
6,rows set 拷贝;(0.00,sec)
10 s
set GLOBAL rpl_semi_sync_master_enabled =, 1;=SET GLOBAL rpl_semi_sync_master_timeout 10000;
从节点启用半同步,重启复制线程生效
时间=SET GLOBAL rpl_semi_sync_slave_enabled 1;
STOP SLAVE IO_THREAD;
START SLAVE IO_THREAD;
show global status like rpl %的;
提醒,并掌握:
(mysqld)
rpl_semi_sync_master_enabled=1
rpl_semi_sync_master_timeout=1000, # 1,秒
提醒each 奴隶:
(mysqld)
rpl_semi_sync_slave_enabled=1
