主从复制笔记

授权访问

use mysql;

GRANT ALL PRIVILEGES ON *.* TO 'jucaisql'@'%' IDENTIFIED BY 'cqzf123456' WITH GRANT OPTION;

FLUSH PRIVILEGES;

#主mysql.cnf配置

server_id = 1001

log_bin = /var/log/mysql/mysql-bin.log

max_binlog_size = 1G

binlog_format = row

innodb-file-per-table =ON

skip_name_resolve=ON

重启mysql

登录mysql

输入 show global variables like '%log%';

查看log-bin 二进制日志是否启动

输入 show master logs;

查看是否已经产生日志文件

输入show global variables like '%server%';

查看 server-id是否存在并且正确

给从节点授权访问

use mysql;

grant replication slave,replication client on *.* to 'slave'@'ip' identified by '密码';

FLUSH PRIVILEGES;

 

从节点mysql.cnf配置

 

#slave settings

relay-log=relay-log

relay-log-index=relay-log.index

server-id=1002

innodb_file_per_table=ON

skip_name_resolve=ON

 

 

重启 /etc/init.d/mysql restart

从节点

CHANGE MASTER TO MASTER_HOST='主ip',MASTER_USER='beifen',MASTER_PASSWORD='cqzf@123456', MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=622;

 

start slave;

 

验证是否成功

show slave status\G;

slave io run ：yes

slave sql run：yus