步骤:
1、同步时间:安装ntp服务
(1)主服务器
[root@master ~]# yum -y install ntp
在文件尾部添加配置,命令找不到就需要下载vim
[root@master ~]# systemctl start ntpdate
[root@master ~]# systemctl status ntpdate
[root@master ~]# systemctl enable ntpdate
(2)从服务器
[root@salve ~]# systemctl start ntp
[root@salve ~]# ntpdate 192.168.111.131(主服务器ip)
2、安装MySQL(尽量不要克隆,连接时MySQL的uuid要更改)
3、配置服务器
(1)主服务器:
授权和刷新:
mysql> grant replication slave on *.* to 'myslave'@'192.168.111.%' identified by 'Abcde.123';
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> show master status;
(2)从服务器
连接主服务器:
mysql> change master to master_host='192.168.111.131',master_user='myslave',master_password='Abcde.123',master_log_file='master-bin.000005',master_log_pos=154;
Query OK, 0 rows affected, 2 warnings (0.00 sec)
mysql> show slave status\G;
重点看IO和SQL是yes就配置成功了!
Slave_IO_Running: Yes
Slave_SQL_Running: Yes