mysqld --help --verbose|grep my.cnf (这个命令查看mysql配置文件)
1.master方配置
my.cnf配置文件里面
[mysqld]
log-bin=mysql-bin #[必须]启动二进制日志
server-id=100 #【必须】服务器唯一的ID
systemctl restart mysqld (重启mysql)
mysql命令:show master status; 可以看到master状态
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000001 | 120 | | | |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)
接着执行下面
GRANT REPLICATION SLAVE ON *.* to 'xiaoming'@'%' identified by 'Root@123456'
(创建一个新的用户,给slave使用)
2.从库slave配置
配置server-id
[mysqld]
server-id=100 #【必须】服务器唯一的ID
重启msyql
systemctl restart mysqld (重启mysql)
登陆进去mysql,执行下面命令
change master to master_host='192.168.0.129',master_user='xiaoming',master_password='Root@123456',master_log_file='mysql-bin.000001',master_log_pos=120;
start slave;// 启动主从复制
show slave status \G; // 查看主从复制状态
看到下面这个就说明配置主从复制成功了