mysql主从复制(笔记)

windows my.ini配置
server_id = 1
log-bin=G:\mysql\mysql-5.6.36-winx64\data\mysqlbin
log-err=G:\mysql\mysql-5.6.36-winx64\data\mysqlerr
tmpdir = G:\mysql\mysql-5.6.36-winx64
binlog-ignore-db=mysql
#binlog-do-db=ssm

linux my.cnf配置
log-bin=mysql-bin
server-id=2

[mysqldump]

主机
grant replication slave on . to ‘zjx’@‘192.168.49.128’ identified by ‘123456’;

flush privileges; //确保万无一失，再刷新一下上面的命令

show master status;
//一下是显示出来的内容
File Position Binlog_Do_DB
mysqlbin.000208 199 ssm

//配置linux

change master to master_host=‘192.168.49.1’,
master_user=‘zjx’,
master_password=‘123456’,
master_log_file=‘mysqlbin.000216’,
master_log_pos=492;

start slave; //启动复制

show slave status\G; //查看状态

stop slave;

如果服务有停止过需要show master status;