===== Mysq semi-sync レプリケーション構築 =====
mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
mysql> show plugins;
mysql> show variables like 'innodb_flush_log_at_trx_commit';
vi /etc/my.cnf
innodb_flush_log_at_trx_commit = 1
server-id=1001
log-bin = log_bin/mysql-bin
log-bin-index = log_bin/log_bin.index
max_binlog_size = 200M
expire_logs_days = 3
binlog_format = mixed
rpl_semi_sync_master_enabled=1
rpl_semi_sync_master_timeout=10
mysql> show master status;
■Slave
mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
mysql> show plugins;
mysql> show variables like 'innodb_flush_log_at_trx_commit';
vi /etc/my.cnf
innodb_flush_log_at_trx_commit = 1
server-id=1002
rpl_semi_sync_slave_enabled=1
CHANGE MASTER TO MASTER_HOST='192.168.26.42', MASTER_USER='slave', MASTER_PASSWORD='slavepassword', MASTER_LOG_FILE='mysql-bin.000002', MASTER_LOG_POS=107;
mysql> start slave;
mysql> show slave status\G