MYSQL 主从配置（一主一从）

环境说明:

• 系统环境:Centos 7.
• Mysql版本：5.6.33
• Master-Server : 192.168.1.157.88
• Slave-Server : 192.168.1.157.89
• 主从数据库都建立测试库（如：testdatabase）

异步配置

Master 主库配置

1, 增加从库同步账号

mysql> GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.*
-> TO repl@'192.168.157.89' IDENTIFIED BY 'repl_password';

2, 配置my.cnf

[mysqld]
log-bin=mysql-bin
server-id=1

3, 重启 Mysql , 查看 Master Status

# Service mysqld restart;
//进入mysql
mysql> SHOW MASTER STATUS;

Slave 从库配置

1, 配置 my.cnf

[mysqld]
log_bin = mysql-bin
server_id = 2
relay_log = mysql-relay-bin
log_slave_updates = 1
read_only = 1

2, 链接Master ，启动Slave

mysql> CHANGE MASTER TO MASTER_HOST='192.168.1.157.88',
         -> MASTER_USER='repl', 
         -> MASTER_PASSWORD='repl_password',
         -> MASTER_LOG_FILE='mysql-bin.000001', 
         -> MASTER_LOG_POS=0;
//启动 Slave
mysql> START SLAVE;

如图：
Slave_IO_Running:Yes
Slave_SQL_Running:Yes
同步配置成功，可以在主库插入数据库测试！

半同步配置

Master 主库配置

1, 安装插件：semisync_master.so

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 = 1000;
mysql> SHOW VARIBALES LIKE '%semi%';

2,配置 my.cnf 让 Mysql 启动生效

[mysqld]rpl_semi_sync_master_enabled = 1
rpl_semi_sync_master_timeout = 1000

# Service mysqld restart

Slave 从库配置

1, 安装插件

 mysql> INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so'; 
 mysql> SET GLOBAL rpl_semi_sync_slave_enabled = 1;
 mysql> STOP SLAVE;mysql> START SLAVE;
 mysql> SHOW VARIBALES LIKE '%semi%';

2,配置 my.cnf 让 Mysql 启动生效

[mysqld]rpl_semi_sync_slave_enabled = 1

# Service mysqld restart

检查半同步是否生效

Master:

mysql> show global status like 'rpl_semi%';