Centos7 下关于MySQL5.7.22的主从部署

Centos7 下关于MySQL5.7.22的主从部署

 

上接Centos7 下关于MySQL5.7.22的安装

 

su root

 

1.分别停止MySQL服务
/etc/init.d/mysql stop

2.修改master的my.cnf文件

3.启动master服务
/etc/init.d/mysql start

 

4.登录MySQL
mysql -h localhost -u root -p

5.创建用户用于从库同步数据
mysql> GRANT REPLICATION SLAVE ON *.* TO 'backup'@'172.16.2.77' IDENTIFIED BY '123456';

 

6.创建需要同步的数据库

create database energy_system default character set utf8 collate utf8_general_ci;
create database energy_battery_supplier default character set utf8 collate utf8_general_ci;
create database energy_vehicle_produce default character set utf8 collate utf8_general_ci;
create database energy_vehicle_sale default character set utf8 collate utf8_general_ci;
create database energy_support default character set utf8 collate utf8_general_ci;
create database energy_battery_repair default character set utf8 collate utf8_general_ci;
create database energy_battery_replace default character set utf8 collate utf8_general_ci;

 

7.获取二进制日志信息
mysql > SHOW MASTER STATUS;

 

8.修改slave的my.cnf文件

 

9.启动slave服务
/etc/init.d/mysql start

 

10.给从库设置主库
mysql -h localhost -u root -p
mysql> CHANGE MASTER TO
    ->     MASTER_HOST='172.16.2.78',
    ->     MASTER_USER='backup',
    ->     MASTER_PASSWORD='123456',
    ->     MASTER_LOG_FILE='mysql-bin.000003',
    ->     MASTER_LOG_POS=449275;

 

10.启动同步进程
start slave;

 

11.查看同步状态

 

参考资料：

https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterbaseconfig.html