给6.30与6.32搭建主主配置的步骤如下:
IP:10.200.6.30
IP:10.200.6.32
主主配置步骤:
IP:10.200.6.30
[root@localhost ~]# vi /etc/my.cnf
log-bin=mysql-bin
server-id =1
replicate-ignore-db=mysql
replicate-ignore-db=test
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
slave-skip-errors=all
sync_binlog=1
auto_increment_increment=2
auto_increment_offset=1IP:10.200.6.32
log-bin=mysql-bin
server-id =2
#binlog-ignore-db=test
replicate-ignore-db=mysql
replicate-ignore-db=test
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema
log-slave-updates
slave-skip-errors=all
sync_binlog=1
auto_increment_increment=2
auto_increment_offset=2然后分别重启两个mysqld的服务。
2. 授权用户
IP:10.200.6.30
mysql> grant replication slave,file on *.* to 'rep'@'10.200.6.32' identified by 'root';
Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)mysql> change master to master_host='10.200.6.32', master_user='rep', master_password='root';
Query OK, 0 rows affected (0.01 sec)
IP: 10.200.6.32
mysql> grant replication slave,file on *.* to 'rep'@'10.200.6.30' identified by 'root';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)mysql> change master to master_host='10.200.6.30', master_user='rep', master_password='root';
MySQL 主主配置 步骤
原创
©著作权归作者所有:来自51CTO博客作者4k的原创作品,请联系作者获取转载授权,否则将追究法律责任

提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
mysql主从、主主配置
文档有错误地方,欢迎指正!
mysql主从及主主配置 -
mysql主主复制配置
mysql主主复制配置
mysql 主主 复制配置