ClownWiki

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