Centos6.5 Mysql5.5 主从同步配置

来源：互联网发布：mysql临时表查询数据编辑：程序博客网时间：2024/06/02 08:25

主库服务器环境：

操作系统：Centos6.5

数据库：Mysql5.5

IP: 111.111.111.111

从库服务器环境：

操作系统：Centos6.5

数据库：Mysql5.5

IP:222.222.222.222

1、主库创建同步用户

mysql> grant replication slave, replication client on *.* to backup@'222.222.222.222' identified by '密码';

2、主库配置

log-bin=mysql-binbinlog_format=mixedserver-id = 1

配置后重启mysql

3、从库配置

log-bin=mysql-binbinlog_format=mixedserver-id = 2relay_log = /var/lib/mysql/mysql-relay-bin  #mysql数据目录位置，如/data/mysqldata/relay.loglog_slave_updates = 1read_only = 1    #从库是否可写

配置后重启mysql

4、从库启动slave

mysql> change master to master_host='192.168.1.201',master_user='repl',master_password='100301',master_log_file='mysql-bin.000001',master_log_pos=0;

从库开启同步

mysql> start slave;

[测试]从服务器连接主库：

mysql -h222.222.222.222 -ubackup -p

参考：http://www.01happy.com/setup-mysql-master-slave-replication-in-centos/

0 0