+--------------------------------------------+-------+
|Variable_name | Value |
+--------------------------------------------+-------+
|Rpl_semi_sync_master_clients | 1 |
|Rpl_semi_sync_master_net_avg_wait_time | 1518 |
|Rpl_semi_sync_master_net_wait_time | 3037 |
|Rpl_semi_sync_master_net_waits | 2 |
|Rpl_semi_sync_master_no_times | 0 |
|Rpl_semi_sync_master_no_tx | 0 |
|Rpl_semi_sync_master_status | ON |
|Rpl_semi_sync_master_timefunc_failures | 0 |
|Rpl_semi_sync_master_tx_avg_wait_time | 715 |
|Rpl_semi_sync_master_tx_wait_time | 715 |
|Rpl_semi_sync_master_tx_waits | 1 |
|Rpl_semi_sync_master_wait_pos_backtraverse | 0 |
|Rpl_semi_sync_master_wait_sessions | 0 |
|Rpl_semi_sync_master_yes_tx | 2 |
+--------------------------------------------+-------+
从库
mysql>INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
mysql>SHOW GLOBAL VARIABLES LIKE '%semi%';
+---------------------------------+-------+
|Variable_name | Value |
+---------------------------------+-------+
|rpl_semi_sync_slave_enabled |OFF |
|rpl_semi_sync_slave_trace_level | 32 |
+---------------------------------+-------+
mysql>SET GLOBAL rpl_semi_sync_slave_enabled=1;
mysql>STOP SLAVE;
mysql>START SLAVE;
mysql>SHOW GLOBAL STATUS LIKE '%semi%';
+----------------------------+-------+
|Variable_name | Value |
+----------------------------+-------+
|Rpl_semi_sync_slave_status | ON |
+----------------------------+-------+
永久配置在Master和Slave的my.cnf中编辑：
# OnMaster
[root@master~]# vim /etc/my.cnf
[mysqld]
rpl_semi_sync_master_enabled=1
rpl_semi_sync_master_timeout=1000# 1 second
验证
mysql>SHOW GLOBAL VARIABLES LIKE '%semi%';
+------------------------------------+-------+
|Variable_name | Value |
+------------------------------------+-------+
|rpl_semi_sync_master_enabled |ON |
|rpl_semi_sync_master_timeout |1000 |
|rpl_semi_sync_master_trace_level |32 |
|rpl_semi_sync_master_wait_no_slave | ON |
+------------------------------------+-------+
# OnSlave
[root@slave~]# vim /etc/my.cnf
[mysqld]
rpl_semi_sync_slave_enabled=1
验证
mysql>SHOW GLOBAL VARIABLES LIKE '%semi%';
+---------------------------------+-------+
|Variable_name | Value |
+---------------------------------+-------+
|rpl_semi_sync_slave_enabled | ON |
|rpl_semi_sync_slave_trace_level | 32 |
+---------------------------------+-------+