mysql半同步

標籤：mysql   local   

cd /usr/local/mysql/lib
cd plugins
ls
scmisync_slave.so



設定半同步步驟：

在Master和Slave的mysql命令列運行如下代碼：

# On Master  
mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME ‘semisync_master.so‘;  
   show giobal variables like ‘%rpl%‘;

mysql> SET GLOBAL rpl_semi_sync_master_enabled = 1;  
mysql> SET GLOBAL rpl_semi_sync_master_timeout = 1000;  


# On Slave  
mysql> INSTALL PLUGIN rpl_semi_sync_slave SONAME ‘semisync_slave.so‘;  
mysql> SET GLOBAL rpl_semi_sync_slave_enabled = 1;  
mysql> STOP SLAVE IO_THREAD; START SLAVE IO_THREAD;  

主
show global status like ‘rpl%‘
rpl_semi_sync_master_clients =1

 在Master和Slave的my.cnf中編輯：

# On Master  
[mysqld]  
rpl_semi_sync_master_enabled=1  
rpl_semi_sync_master_timeout=1000 # 1 second  

# On Slave  
[mysqld]  
rpl_semi_sync_slave_enabled=1  


percona: percona-tools
    mattkit-tools

yum localintsall percona-tookit-2.2.2-1.noarch.rpm --nogpgcheck
pt

# 也可通過設定全域變數的方式來設定,如下：
set global rpl_semi_sync_master_enabled=1
# 取消載入外掛程式
mysql> UNINSTALL PLUGIN rpl_semi_sync_master;
==============================================

查看從伺服器上的semi_sync是否開啟:
mysql> SHOW GLOBAL STATUS LIKE ‘rpl_semi%‘;

查看主伺服器上的semi_sync是否開啟，注意clients 變為1 ，證明主從半同步複製串連成功:
mysql> SHOW GLOBAL STATUS LIKE ‘rpl_semi%‘;

stop slave IO_Thread

mysql半同步