MySQL主从复制-GTID方式部署

两台虚拟机【环境必须一致。时间也得一致】master、slave

关闭防火墙和selinux、与主机解析

# vim /etc/hosts
 192.168.111.6 master
 192.168.111.7 slave

主服务器master-----配置my.cnf

# vim /etc/my.cnf          #在[mysqld]下添加如下内容
 server-id=1               #定义server id master必写 
 log-bin = mylog           #开启binlog日志，master比写
 gtid_mode = ON            #开启gtid
 enforce_gtid_consistency=1   #强制开启gtid

# systemctl restart mysqld  重启服务
# mysql -uroot -p1
mysql> grant all on *.*  to 'alan'@'%' identified by 'Alan@123456';
mysql> flush privileges;

从服务器slave-----配置my.cnf

# vim /etc/my.cnf      #添加如下配置
 server-id=2
 gtid_mode = ON
 enforce_gtid_consistency=1
 master-info-repository=TABLE
 relay-log-info-repository=TABLE

# systemctl restart mysqld        重启服务
# mysql -uroot -p1
mysql> \e
 change master to
 master_host='master',           #主ip 地址  最好用域名
 master_user='alan',             #主服务上面创建的用户
 master_password='Alan@123456', 
 master_auto_position=1;
-> ;

mysql> start slave;       
mysql> show slave status\G

IO线程与SQL线程都是yes，基本就成功了。测试就交给你们了