环境

amoeba-mysql:192.168.1.133
mysql-master:192.168.1.131
mysql-slave:192.168.1.132
jdk:1.7.0_71

说明

我查了资料说是，131和132上面没有远程连接权限。我加了设置可是报错还是这样子。请大家帮我看看到底是什么问题。下面是amoeba.xml和dbServers.sml的配置。

amoeba.xml

        

                
                
                        
                        8066

                        
                        

                        ${clientConnectioneManager}

                        
                                
                                        128
                                        64
                                
                        

                        
                                

                                        root

                                        123456

                                        
                                                
                                                        ${amoeba.home}/conf/access_list.conf
                                                
                                        
                                
                        

                

                
                

                        
                        
                        127.0.0.1
                        true
                        ${clientConnectioneManager}
                        
                                
                        

                

                
                        
                        20

                        
                        30

                        
                        30

                        
                        500

                        
                        60
                

        

        
        
                
                        com.meidusa.amoeba.net.ConnectionManager
                        
                
                
                        com.meidusa.amoeba.net.AuthingableConnectionManager

                        
                
        

                
        
                ${amoeba.home}/conf/dbServers.xml
        

        
                
                        
                                ${amoeba.home}/conf/rule.xml
                                ${amoeba.home}/conf/ruleFunctionMap.xml
                        
                
                ${amoeba.home}/conf/functionMap.xml
                1500
                master
                master
                slave
                true
        

dbServers.xml

                

        
                
                        ${defaultManager}
                        64
                        128

                        
                        3306

                        
                        test

                        
                        root

                        123456
                

                
                        500
                        500
                        10
                        600000
                        600000
                        true
                        true
                        true
                
        

        
                
                        
                        192.168.1.131
                
        

        
                
                        
                        192.168.1.132
                
        
 
                
                        
                        1

                        
                        slave
                
        

报错

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    832301137
Current database: *** NONE ***

ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> java.util.NoSuchElementException: Could not create a validated object, cause: ValidateObject failed
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1191)
        at com.meidusa.amoeba.net.poolable.GenericObjectPool.borrowObject(GenericObjectPool.java:381)
        at com.meidusa.amoeba.mysql.handler.CommandMessageHandler.startSession(CommandMessageHandler.java:633)
        at com.meidusa.amoeba.mysql.handler.MySqlCommandDispatcher.handleMessage(MySqlCommandDispatcher.java:123)
        at com.meidusa.amoeba.mysql.net.MysqlClientConnection$2.run(MysqlClientConnection.java:291)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)