MySQL5.5主主复制配置方法及测试结果
MySQL5.5主主复制配置方法及测试结果
1. 环境:CentOS5.5 x84,MySQL5.5.152. 两台机器: master1:192.168.5.143 master2:192.168.0.149
3. 单独编译安装MySQL,并测试连接成功。
4. 两台机器上都建立用户,并赋予复制权限: master1:
- mysql> CREATE USER 'test12'@'%';
- mysql> GRANT REPLICATION SLAVE ON *.* TO 'test12'@'%' IDENTIFIED BY 'test12';
- mysql> CREATE USER 'test34'@'192.168.5.143';
- mysql> GRANT REPLICATION SLAVE ON *.* TO 'test34'@'192.168.5.143' IDENTIFIED BY 'test34';
5. master1上的my.cnf添加:
- [mysqld]
- # for repl
- server-id = 1
- log-bin = mysql-bin
- auto-increment-increment= 2 # 应设为整个结构中服务器的总数
- auto-increment-offset = 1 # 设定数据库中自动增长的起点,避免两台服务器数据同步时出现主键冲突
- [mysqld]
- # for repl
- server-id = 2
- log-bin = mysql-bin
- auto-increment-increment= 2
- auto-increment-offset = 1
8. master1上指定master2为主:
- mysql> CHANGE MASTER TO
- -> MASTER_HOST='192.168.0.149',
- -> MASTER_USER='test34',
- -> MASTER_PASSWORD='test34';
- Query OK, 0 rows affected (0.19 sec)
- mysql> START SLAVE;
- Query OK, 0 rows affected (0.00 sec)
- mysql> CHANGE MASTER TO
- -> MASTER_HOST='192.168.5.143',
- -> MASTER_USER='test12',
- -> MASTER_PASSWORD='test12';
- Query OK, 0 rows affected (0.18 sec)
- mysql> START SLAVE;
- Query OK, 0 rows affected (0.00 sec)
ps,MySQL的主主复制实际上就是双向的主从复制。
评论暂时关闭