MySQL主从复制
主库设置:vi /etc/my.cnf
my.cnf修改内容:
log_bin=mysql-bin 设置开启binlog
server-id=1 指定唯一serverID
sync-binlog=1 同步磁盘
binlog-ignore-db=performance_schema 同步忽略库
binlog-ignore-db=information_schema
binlog-ignore-db=sys
重启mysql:systemctl restart mysqld
进入mysql 修改授权:
grant replication slave on . to ‘root’@’%’ identified by ‘123456’;
grant all privileges on . to ‘root’@’%’ identified by ‘123456’;
flush privileges; 刷新
identified by‘密码’
从库处理
修改配置:my.cnf
server-id=2 指定唯一serverID
relay_log=mysql-relay-bin 指定relay的日志名称
read_only=1 只读
重启MySQL:systemctl restart mysqld
进入MySQL:
mysql -uroot -p
配置和master的连接:
change master to master_host=‘192.168.0.59’,master_port=3306,master_user=‘root’,master_password=‘123456’,master_log_file=‘mysql-bin.000001’,master_log_pos=869
注解:
master_host:主库的ip
master_port:主库的端口
master_user:主库的用户名
master_password:主库的密码
master_log_file:主库的binlog
master_log_pos:binlog的文件,同步开始位置开始地址