编写日期:2016-09-19
编写作者:mtsbv110
部署环境
操作系统: :CentOS Linux release 7.2.1511 (Core) cat /etc/redhat-release
Mysql版本:mysql-5.6.26.tar.gz
操作用户: root
系统IP: 192.168.9.66
主机名: jetsen-analysis-01
系统IP: 192.168.9.67
主机名: jetsen-analysis-02
配置: 8核 8G cat/proc/cpuinfo |grep "name" |cut -f2 -d: |uniq –c
grep MemTotal/proc/meminfo
1、 修改Master的配置文件
Jetsen-analysis-01 /etc/my.cnf
##replication
server_id=66
binlog-ignore-db=mysql
log-bin=jetsen-mysql-bin
binlog_cache_size=1M
binlog_format=mixed
expire_logs_days=7
slave_skip_errors=1062
2、 创建数据同步用户,并授予相应的权限
mysql> grant replication slave,replication client on *.*to 'repl'@'192.168.9.67' identified by 'jetsen123';
mysql> flush privileges;
mysql> show master status;
3、 处理SLAVE节点192.168.9.67,修改my.cnf配置文件,修改完成重启数据库
server_id=67
log-bin=jetsen-mysql-slave1-bin
relay_log=jetsen-mysql-relay-bin
log_slave_updates=1
4、 登录SLAVE节点,添加相关的参数
mysql> change master to
master_host='192.168.9.66',master_user='repl',master_password='jetsen123',master_port=3306,master_log_file='jetsen-mysql-bin.000001',master_log_pos=1270,master_connect_retry=30;
mysql> start slave;
mysql> show slave status\G;
显示YES则同步正常
Slave_IO_Running: Yes
Slave_SQL_Running: Yes