原以为semi sync是5.5默认支持的。。发现原来是以插件形式工作的。。。
插件目录:mysql-5.5.20/lib/plugin/
semisync_master.so semisync_slave.so
加载插件模块:
mysql> show status like 'rpl%';
+---------------+-------------+
| Variable_name | Value |
+---------------+-------------+
| Rpl_status | AUTH_MASTER |
+---------------+-------------+
1 row in set (0.00 sec)
mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
Query OK, 0 rows affected (0.01 sec)
mysql> show variables like 'rpl%';
+------------------------------------+-------+
| Variable_name | Value |
+------------------------------------+-------+
| rpl_recovery_rank | 0 |
| 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 | ON |
+------------------------------------+-------+
5 rows in set (0.00 sec)
打开semi sync的功能:
rpl_semi_sync_master_enabled = 1
http://www.orczhou.com/index.php/2011/06/mysql-5-5-semi-sync-replication-setup-config/
这篇文章介绍的比较详细。。。。