mysql的半同步复制

半同步复制

master:

mysql> install plugin rpl_semi_sync_master soname 'semisync_master.so';   #安装半同步复制的插件
Query OK, 0 rows affected (0.01 sec)

mysql> set global  rpl_semi_sync_master_enabled=ON;    #热生效：打开半同步
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like  '%semi%';
+-------------------------------------------+------------+
| Variable_name                             | Value      |
+-------------------------------------------+------------+
| rpl_semi_sync_master_enabled              | ON         |
| rpl_semi_sync_master_timeout              | 10000      |
| rpl_semi_sync_master_trace_level          | 32         |
| rpl_semi_sync_master_wait_for_slave_count | 1          |
| rpl_semi_sync_master_wait_no_slave        | ON         |
| rpl_semi_sync_master_wait_point           | AFTER_SYNC |
+