MySQL双主（主主）架构

terte

128机器：

1 2 3

[iyunv@localhost ~]# /etc/init.d/mysqld restart Shutting down MySQL.. SUCCESS! Starting MySQL.. SUCCESS!

129机器：

1 2 3

[iyunv@localhost ~]# /etc/init.d/mysqld restart Shutting down MySQL.. SUCCESS! Starting MySQL.. SUCCESS!

先配主从：
128机器上：
拷贝数据并传输到129机器上

1 2	[iyunv@localhost ~]# mysqldump -uroot -p123456 --all-databases > /tmp/mysqlall.sql [iyunv@localhost ~]# scp -r /tmp/mysqlall.sql 192.168.65.129:/tmp/

1 2 3

mysql> grant replication slave on *.* to 'repl'@192.168.65.129 identified by '123456'; mysql> flush privileges;

测试机器数据变化基本没有，所以就不锁表了


129机器上：

1	[iyunv@localhost ~]# mysql -uroot -p123456 < /tmp/mysqlall.sql

1 2 3 4 5 6 7 8 9 10

mysql> stop slave; Query OK, 0 rows affected (0.00 sec) mysql> change master to master_host='192.168.65.128', master_user='repl', master_password='123456', master_log_file='thermos.000001, master_log_pos=420; Query OK, 0 rows affected, 2 warnings (0.01 sec) mysql> start slave; Query OK, 0 rows affected (0.01 sec) mysql> show slave statusG

主从同步完成

主主同步：
129机器上：
更改/etc/my.cnf，增加log_bin

1 2 3

[iyunv@localhost ~]# /etc/init.d/mysqld restart Shutting down MySQL.. SUCCESS! Starting MySQL.. SUCCESS!

1 2 3 4 5

mysql> grant replication slave on *.* to 'repl'@192.168.65.128 identified by '123456'; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)

128机器上：

1 2 3 4 5 6 7 8 9 10

mysql> stop slave; Query OK, 0 rows affected (0.00 sec) mysql> change master to master_host='192.168.65.129', master_user='repl', master_password='123456', master_log_file='alex.000001', master_log_pos=420; Query OK, 0 rows affected, 2 warnings (0.01 sec) mysql> start slave; Query OK, 0 rows affected (0.00 sec) mysql> show slave statusG

测试主主
128上

129上

（已经多了micheal库）

129上

128上

（多了jackson库）

自己研究的，不知道正确与否，如果有错误，望指正！