部署mysql集群基础环境
时间:2022-03-14 18:41
设置slave2为master1从:部署集群基础环境
[root@master1 ~]# mysql -uroot -ppwd123
mysql> change master to
-> master_host="192.168.4.11",
-> master_user="slaveuser",
-> master_password="pwd123",
-> master_log_file="master2-bin.000001",
-> master_log_pos=120;
mysql> start slave;
mysql> show slave status\G
.. ..
Slave_IO_Running: Yes //IO节点正常
Slave_SQL_Running: Yes //SQL节点正常
6)测试主从架构是否成功
master1更新数据,查看其它主机是否同步: