Mysql 5.6主从复制配置——基于bin-log

Mysql 5.6主从复制配置


环境：
master  192.168.169.101
端口  3307
备注：由于主机上安装了多个实例，采用mysqld_multi管理（该部分与主从复制无关）


slave  192.168.169.102
端口  3307


1.确保master及slave机器mysql实例已安装好

2.确保msql是关闭状态

3.修改my.cnf
master配置文件/etc/my.cnf如下

[mysqld_multi] 
mysqld = /mysql/bin/mysqld_safe 
mysqladmin = /mysql/bin/mysqladmin
user = admin
password = admin

[mysqld1]
basedir = /mysql
datadir = /mysqldata
port = 3307
server_id=111111
socket = /tmp/mysql.sock
log-bin=mysql-bin
server-id=101


[mysqld2]
basedir = /mysql
datadir = /mysqldata2
port = 3308
socket = /tmp/mysql2.sock


slave配置文件/etc/my.cnf如下
[mysqld]
basedir = /mysql
datadir = /mysqldata
port = 3307
server_id = 1
log-bin=mysql-bin
server-id=102


4.启动master,slave实例
master
mysqld_multi start 1


slave
service mysqld start


5.master上创建复制用户
GRANT REPLICATION SLAVE ON *.* to 'syc'@'192.168.169.102' identified by 'syc';
flush privileges;


6.master上记录master状态
show master status;




7.slave上操作
slave stop
change master to master_host='192.168.169.101',master_user='syc',
master_password='syc',master_port=3307,
master_log_file='mysql-bin.000002',master_log_pos=120;
slave start


8.检查复制状态是否正确，slave上操作
show slave status\G；

Slave_IO及Slave_SQL进程必须正常运行，即YES状态，否则都是错误的状态(如：其中一个NO均属错误)

9.master操作dml，验证复制能否同步成功

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21809030/viewspace-1409521/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21809030/viewspace-1409521/