56,677
社区成员
发帖
与我相关
我的任务
分享
* IP - 192.168.1.81 -- 主
~~~txt
[root@localhost ~]# vim /etc/my.cnf
#[mysqld]
#GTID
server_id=81
gtid_mode=on
enforce_gtid_consistency=on
#binlog
log_bin=master-binlog
log-slave-updates=1
binlog_format=row
#relay log
skip_slave_start=1
[root@localhost ~]# systemctl restart mysqld
~~~
~~~txt
mysql> use mysql;
mysql> update user set host = '%' where user ='root';
mysql> flush privileges;
~~~
* IP - 192.168.1.82 -- 从
~~~txt
[root@localhost ~]# vim /etc/my.cnf
#[mysqld]
#GTID
server_id=82
gtid_mode=on
enforce_gtid_consistency=on
#binlog
log-bin=slave-binlog
log-slave-updates=1
binlog_format=row
#relay log
skip_slave_start=1
[root@localhost ~]# systemctl restart mysqld;
~~~
~~~txt
mysql> use mysql;
mysql> update user set host = '%' where user ='root';
mysql> flush privileges;
~~~
~~~txt
[root@localhost ~]# mysql -u root -p
mysql> CHANGE MASTER TO
MASTER_HOST='192.168.1.81',
MASTER_USER='root',
MASTER_PASSWORD='123456',
MASTER_PORT=3306,
MASTER_AUTO_POSITION = 1;
~~~
~~~txt
mysql> start slave;
~~~
~~~txt
mysql> show slave status \G;
~~~