mysql 主从复制

主库服务器环境：

操作系统：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-bin
binlog_format=mixed
server-id = 1

配置后重启MySQL

3、从库配置

log-bin=mysql-bin
binlog_format=mixed
server-id = 2
relay_log = /var/lib/mysql/mysql-relay-bin  #mysql数据目录位置，如/data/mysqldata/relay.log
log_slave_updates = 1
read_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