Mysql 半同步复制

mysql5.5半同步插件是由谷歌提供，具体位置/usr/local/mysql/lib/plugin/下，一个是master用的semisync_master.so，一个是slave用的semisync_slave.so

安装半同步master插件

mysql> install plugin rpl_semi_sync_master soname 'semisync_master.so';

开启半同步插件

mysql> set global rpl_semi_sync_master_enabled=1;

设置同步超时时间

mysql> set global rpl_semi_sync_master_timeout=10000;

修改配置文件

[root@localhost data]# cat /etc/my.cnf

[mysqld]

server-id=1

log-bin=master

log-bin-index=master

rpl_semi_sync_master_enabled=1

rpl_semi_sync_master_timeout=10000

启动服务：

service mysqld restart

slave端配置：

安装半同步slave插件：

mysql> install plugin rpl_semi_sync_slave soname 'semisync_slave.so';

开启半同步插件

mysql> set global rpl_semi_sync_slave_enabled=1;

修改配置文件：

[root@localhost data]# cat /etc/my.cnf

[mysqld]

server-id=2

rpl_semi_sync_slave_enabled=1

重新启动服务：

service mysqld restart

查询状态

master

mysql> SHOW GLOBAL STATUS LIKE 'rpl_semi%';

+--------------------------------------------+-------+

| Variable_name | Value |

+--------------------------------------------+-------+

| Rpl_semi_sync_master_clients | 1 |

| Rpl_semi_sync_master_net_avg_wait_time | 0 |

| Rpl_semi_sync_master_net_wait_time | 0 |

| Rpl_semi_sync_master_net_waits | 0 |

| 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 | 0 |

| Rpl_semi_sync_master_tx_wait_time | 0 |

| Rpl_semi_sync_master_tx_waits | 0 |

| Rpl_semi_sync_master_wait_pos_backtraverse | 0 |

| Rpl_semi_sync_master_wait_sessions | 0 |

| Rpl_semi_sync_master_yes_tx | 0 |

+--------------------------------------------+-------+

slave：

mysql> SHOW GLOBAL STATUS LIKE 'rpl_semi%';

+--------------------------------------------+-------+

| Variable_name | Value |

+--------------------------------------------+-------+

| Rpl_semi_sync_master_clients | 0 |

| Rpl_semi_sync_master_net_avg_wait_time | 0 |

| Rpl_semi_sync_master_net_wait_time | 0 |

| Rpl_semi_sync_master_net_waits | 0 |

| Rpl_semi_sync_master_no_times | 0 |

| Rpl_semi_sync_master_no_tx | 0 |

| Rpl_semi_sync_master_status | OFF |

| Rpl_semi_sync_master_timefunc_failures | 0 |

| Rpl_semi_sync_master_tx_avg_wait_time | 0 |

| Rpl_semi_sync_master_tx_wait_time | 0 |

| Rpl_semi_sync_master_tx_waits | 0 |

| Rpl_semi_sync_master_wait_pos_backtraverse | 0 |

| Rpl_semi_sync_master_wait_sessions | 0 |

| Rpl_semi_sync_master_yes_tx | 0 |

| Rpl_semi_sync_slave_status | ON |

+--------------------------------------------+-------+