mysql主从复制 https://www.cnblogs.com/wade-lt/p/9008058.html
主:172.18.155.69 从:172.18.155.70 复制数据库amstore
主:
1.修改my.cnf并重启 vim /etc/my.cnf [mysqld]下
server-id=1
log-bin=mysql-bin
binlog-do-db=amstore
binlog-ignore-db=mysql
sync_binlog = 1
binlog_checksum = none
binlog_format = mixed
2.查看master信息:show master status; 信息中的 File 和 Position, 从库连接时需要。
3.创建用于从库读取数据的用户。
grant replication slave,replication client on *.* to repl@'172.18.155.70' identified by "repl@123";
flush privileges;
从:
1.修改my.cnf并重启 vim /etc/my.cnf [mysqld]下
server-id=2
log-bin=mysql-bin
replicate-do-db=amstore
replicate-ignore-db=mysql
slave-skip-errors = all
2.执行同步前,要先关闭slave
stop slave;
3.设置master info,后面如需修改master info, 先 stop slave 再 reset slave all
change master to master_host='172.18.155.69', master_port=3306, master_user='repl',master_password='repl@123', master_log_file='mysql-bin.000001', master_log_pos=569198;
4.启动同步
start slave;
5.查看同步状态 Slave_IO_Running 和 Slave_SQL_Running 都为 Yes 代表启动成功
show slave status;