mysql 是否配置主从_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%';