- 解析/etc/hosts(可不用) 防火墙先关闭!!!!!!!!!!!!!
- 192.168.126.142 mysql-master(互为组从自定义slave)----------------139
- 192.168.126.139 mysql-slave -------------142
- 两台机器安装mysql8.0/5.7
- 安装略...
- [root@mysql-master ~]# systemctl start mysqld
- [root@mysql-master ~]# systemctl enable mysqld
- [root@mysql-master ~]# netstat -lntp | grep 3306
- tcp6 0 0 :::3306 :::* LISTEN 11669/mysqld
- [root@mysql-slave ~]# netstat -lntp | grep 3306
- tcp6 0 0 :::3306 :::* LISTEN 11804/mysqld
- 配置并修改密码
- master操作:
- [root@mysql-master ~]# 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
- [root@mysql-master ~]# systemctl restart mysqld #重启
- 主服务器创建用户:(mysql-8.0)
- use mysql;
- create user slave@'192.168.126.%' identified by 'Dongkexue@666';
- grant replication slave,reload,super on . to 'slave'@'192.168.126.%';
- select user,host from mysql.user;
- flush privileges;
- slave操作:
- [root@mysql-slave ~]# vim /etc/my.cnf #添加如下配置
- server-id=2
- gtid_mode = ON
- enforce_gtid_consistency=1
- master-info-repository=TABLE
- relay-log-info-repository=TABLE
- [root@mysql-slave ~]# systemctl restart mysqld
- [root@mysql-slave ~]# mysql -uroot -p'Dongkexue' #登陆mysql
- 自行编辑
- mysql> \e
- change master to
- master_host='master1', #主ip 地址 最好用域名
- master_user='授权用户', #主服务上面创建的用户
- master_password='授权密码',
- master_auto_position=1 #(这没逗号)
- -> ;
- Query OK, 0 rows affected, 2 warnings (0.02 sec)
- mysql> start slave; #启动slave角色
- Query OK, 0 rows affected (0.00 sec)
- mysql> show slave status\G #查看状态,验证sql和IO是不是yes。
-
- binlog方式可能出现问题-
- 互相授权,主机再执行一遍slave操作
mysql8.0互为主从gtid
于 2023-11-28 21:36:30 首次发布