MySQL主从搭建

1、启动两个服务器

2、master服务器启动binlog

3、创建从库备份账号
grant replication slave on *.* to 'huainian'@'%' identified by 'huainian';
用户名：huainian 密码：huainian
#刷新权限
flush privileges;

4、查看master数据库binlog记录
show master status;

5、备份master数据库
mysqldump -uroot -p -S /data/3306/mysql.sock -A -B --events --master-data=2 > /opt/rep.sql;

6、导入从数据库
mysql -uroot -p -S /data/3307/mysql.sock < /opt/rep.sql;

7、创建master.info
CHANGE MASTER TO
MASTER_HOST='192.168.0.105',
MASTER_PORT=3306,
MASTER_USER='huainian',
MASTER_PASSWORD='huainian',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=585;

8、开启slave
start slave;

9、检查连接是否成功
show slave status;