修改配置文件
主库:
[mysqld]
server-id = 1
log config
log-bin = mysql-bin
sync_binlog = 1
binlog_format = mixed
expire_logs_days = 7
max_binlog_size = 100m
binlog_cache_size = 4mbinlog-do-db=test1
binlog-do-db=test2max_binlog_cache_size= 512m
binlog-ignore-db=mysqlauto-increment-offset = 1
auto-increment-increment = 1
slave-skip-errors = all
从库:
[mysqld]
server-id=2
log-bin=mysql-bin
relay-log=slave-relay-bin
relay-log-index=slave-relay-bin
replication-do-db=mysql_db
replication-rewrite-db= mysql.sql -> mysql_db
重启服务:service mysql restart
主库建立一个用于同步的用户
CREATE USER centos1 IDENTIFIED BY 'maluole';
grant replication SLAVE on *.* to 'mycentos1'@'192.168.2.88' identified by 'maluole';
在主服务器上查看master信息:show master status;
登录从服务器mysql
change master to master_host='192.168.2.151',master_user='mycentos1',master_password='maluole',master_log_file='mysql_bin.000015',master_log_pos=413;
在从服务器上启动主从
start slave;#启动主从
stop slave;#暂停主从
如果启动从节点失败,需要执行重置。
stop slave;
reset slave;
查看主从同步状态,没有报错启动成功
show slave status \G;
OR
show slave status;