MYSQL搭建双master-slave环境一系列问题

搭建双master-slave环境:master1参数：log-bin=mysql-binbinlog_format=mixedserver-id       = 1skip-slave-startlog-slave-updatessync_binlog=1auto_increment_increment=2auto_increment_offset=1replicate_wild_do_table = mysql.%replicate_wild_do_table = test.%master2参数：log-bin=mysql-binbinlog_format=mixedserver-id       = 3skip-slave-startlog-slave-updatessync_binlog=1auto_increment_increment=2auto_increment_offset=2replicate_wild_do_table = mysql.%replicate_wild_do_table = test.%配置mysql-proxy配置文件：[mysql-proxy]proxy-address = 192.168.13.11:4040proxy-read-only-backend-addresses = 192.168.12.18:3311proxy-backend-addresses = 192.168.12.222:3311,192.168.13.11:3311proxy-lua-script = /usr/local/mysql-proxy-0.8.3/share/doc/mysql-proxy/rw-splitting.luaverbose-shutdown = truedaemon = trueuser = mysqlbasedir = /usr/local/mysql-proxy-0.8.3log-level = message log-file = /usr/local/mysql-proxy-0.8.3/log/proxy.logkeepalive = true日志如下：2013-05-08 17:01:30: (message) chassis-unix-daemon.c:136: [angel] we try to keep PID=12774 alive2013-05-08 17:01:30: (critical) plugin proxy 0.8.3 started2013-05-08 17:01:30: (message) proxy listening on port 192.168.13.11:40402013-05-08 17:01:30: (message) added read/write backend: 192.168.12.222:33112013-05-08 17:01:30: (message) added read/write backend: 192.168.13.11:33112013-05-08 17:01:30: (message) added read-only backend: 192.168.12.18:3311进行测试：mysql> select * from zhh;+------+------+| id   | name |+------+------+|    1 | a    ||    2 | b    ||    3 | c    ||    4 | d    |+------+------+4 rows in set (0.00 sec)关闭一个master后：mysql> select * from zhh;ERROR 2013 (HY000): Lost connection to MySQL server during querymysql> select * from zhh;ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect...Connection id:    7Current database: test+------+------+| id   | name |+------+------+|    1 | a    ||    2 | b    ||    3 | c    ||    4 | d    |+------+------+4 rows in set (0.20 sec)mysql> insert into zhh values(5,'e');Query OK, 1 row affected (0.01 sec)mysql> select * from zhh;+------+------+| id   | name |+------+------+|    1 | a    ||    2 | b    ||    3 | c    ||    4 | d    ||    5 | e    |+------+------+5 rows in set (0.00 sec)如上可见，双master环境下，如果关闭的是已经建立的连接的那个mysql，则会报错，然后重连接到另外一个未关闭的mysql。