MySql主从复制搭建方法

1、先安装mysql的yum源rpm -ivh mysql-community-release-el7-5.noarch.rpm

3、启动mysqlsystemctl enable mysqldsystemctl start mysqld

5、编辑主库、从库上的配置文件/etc/my.cnf主库在[mysqld]下增加server-id = 1log幻腾寂埒-bin= binlogbinlog_format=mixed从库在[mysqld]下增加server-id=2log-bin= binlogbinlog_format=mixedreplicate_wild_do_table=oldboy.%replicate_wild_ignore_table=mysql.%

7、在主库上创建slave用户，并指定该用户只能在主机192.168.137.128上登录mysql>grant replication slave on *.* to 'admin'@'192.168.137.128' identified by '123456';

9、在主库上查状态select user,host from mysql.user;

11、在主库上备份adservermysqldump --master-data -u root -p oldboy> oldboy.sql并将oldboy.sql 通过scp拷贝到从库上

13、解锁主库表unlock tables;

15、从库上查看slave status 状态mysql>show slave status\G;

16、mysql主从同步搭建完成主库insert，从库可以select