双主双从部署

1.Master-1部署
vim /etc/my.cnf
log-bin = my1log  开启binlog日志，并给binlog日志起名为my1log,binlog日志默认存放在/var/lib/mysql

[root@master-1 ~]# vim /etc/my.cnf
log-bin = my1log
server-id = 1
gtid_mode=ON
enforce_gtid_consistency=1

创建授权用户：

grant all on *.* to 'slave'@'%' identified by 'QianFeng@123';  //为从数据库提供用户

重启mysqld

2.Master-2部署
vim /etc/my.cnf
log-bin = my2log  
server-id = 2
gtid_mode=ON
enforce_gtid_consistency=1

创建授权用户
 grant all on *.* to 'slave'@'%' identified by 'QianFeng@123';

重启服务

双主互为主从：

Master-1：
进入数据库使用edit 插入
 change master to
    master_host='master-2',
    master_user='slave',
    master_password='QianFeng@123',
    master_auto_position=1;

start slave；
show slave status\G \\查看连接状态

Master-2：

进入数据库使用edit 插入
 change master to
    master_host='master-1',
    master_user='slave',
    master_password='QianFeng@123',
    master_auto_position=1;

start slave；
show slave status\G \\查看连接状态

Slave-1部署
vim /etc/my.cnf

log-bin = my3log    
server-id = 3
gtid_mode=ON
enforce_gtid_consistency=1
relay_log_info_repository = TABLE
master_info_repository    = TABLE
relay_log_recovery        = on

systemctl restart mysqld //重启服务

进入数据库使用edit 插入
   CHANGE MASTER TO
    MASTER_HOST='master-1',
    MASTER_USER='slave',
    MASTER_PASSWORD='QianFeng@123',
    MASTER_AUTO_POSITION=1 FOR CHANNEL 'master-1';

start slave；
show slave status\G \\查看连接状态

再使用edit插入：
 CHANGE MASTER TO
    MASTER_HOST='master-2',
    MASTER_USER='slave',
    MASTER_PASSWORD='QianFeng@123',
    MASTER_AUTO_POSITION=1 FOR CHANNEL 'master-2';

start slave；
show slave status\G \\查看连接状态

Slave-2部署
vi /etc/my.conf

log-bin = my4log    
server-id = 4
gtid_mode=ON
enforce_gtid_consistency=1
relay_log_info_repository = TABLE
master_info_repository    = TABLE
relay_log_recovery        = on

 //重启服务

进入数据库使用edit 插入
 CHANGE MASTER TO
    MASTER_HOST='master-1',
    MASTER_USER='slave',
    MASTER_PASSWORD='QianFeng@123',
    MASTER_AUTO_POSITION=1 FOR CHANNEL 'master-1';

start slave；
show slave status\G \\查看连接状态

Master-2：

进入数据库使用edit 插入

CHANGE MASTER TO
    MASTER_HOST='master-2',
    MASTER_USER='slave',
    MASTER_PASSWORD='QianFeng@123',
    MASTER_AUTO_POSITION=1 FOR CHANNEL 'master-2';

start slave；
show slave status\G \\查看连接状态