mysql 主从复制

mysql 安装部署

两台服务器都进行操作

上传依赖包

rpm -ivh libaio* 

然后执行安装脚本。（根据配置修改datadir，buffer_pool）

mysql 主从搭建

#创建主从复制用户
create  user  repl@'192.168.88.111' identified  by  'Repl@123';
grant  replication  slave  on *.*  to repl@'192.168.88.111' ;
flush  privileges;

reset master;

#检查用户
use mysql;
select user,host from user;
搭建出从：从库执行
执行前主库查询状态
mysql> show   master   status;
+-------------------+----------+--------------+------------------+-------------------+
| File              | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+-------------------+----------+--------------+------------------+-------------------+
| oldboy-bin.000001 |      154 |              |                  |                   |
+-------------------+----------+--------------+------------------+-------------------+

CHANGE MASTER TO
  MASTER_HOST='192.168.88.110',
  MASTER_USER='repl',
  MASTER_PASSWORD='Repl@123',
  MASTER_PORT=3306,
  MASTER_LOG_FILE='oldboy-bin.000001',
  MASTER_LOG_POS=154,  
  MASTER_CONNECT_RETRY=10;

启动从
start slave;
查看主从
show  slave  status\G;
#检查主从是否正常

3.创建生产szjj_pro数据库，直接把sql导入

4.创建授权用户szjj

CREATE USER 'szjj'@'localhost' IDENTIFIED BY 'JYszjj@163';
GRANT ALL ON szjj.* TO 'szjj'@'localhost';