以上配置,在112上添加数据,左边一对主从可以,右边不行.

当,把左边主(176)关闭,112上显示:

ERROR 2006 (HY000): MySQL server has gone away

No connection. Trying to reconnect...

ERROR 2003 (HY000): Can't connect to MySQL server on '115.60.12.100' (111)

ERROR: 

Can't connect to the server

重启mycate后,112可以添加了.右边主从正常.左侧数据未更新.

当把配置中,hostM1配置删除.重启后,并开启刚才关闭的176后,

4个服务器数据库都可以更新,好奇怪哦,这是哪里出错了呢?

通过112写入,或读取可以执行时,查看日志发现有问题:

2017-05-14 21:27:39.519  WARN [$_NIOREACTOR-0-RW] (io.mycat.sqlengine.SQLJob.errorResponse(SQLJob.java:129)) - error response errno:1227, Access denied; you need (at least one of) the SUPER,REPLICATION CLIENT privilege(s) for this operation from of sql :show slave status at con:MySQLConnection [id=12, lastTime=1494768459509, user=mycat, schema=imooc_shop, old shema=imooc_shop, borrowed=true, fromSlaveDB=true, threadId=12, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=SQLJob [ id=0,dataNodeOrDatabase=imooc_shop,sql=show slave status,  jobHandler=io.mycat.sqlengine.OneRawSQLQueryResultHandler@48089d83], host=115.60.12.178, port=3306, statusSync=null, writeQueue=0, modifiedSQLExecuted=false]

2017-05-14 21:27:39.519  WARN [$_NIOREACTOR-0-RW] (io.mycat.sqlengine.SQLJob.errorResponse(SQLJob.java:129)) - error response errno:1227, Access denied; you need (at least one of) the SUPER,REPLICATION CLIENT privilege(s) for this operation from of sql :show slave status at con:MySQLConnection [id=8, lastTime=1494768459509, user=mycat, schema=imooc_shop, old shema=imooc_shop, borrowed=true, fromSlaveDB=false, threadId=7355, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=SQLJob [ id=0,dataNodeOrDatabase=imooc_shop,sql=show slave status,  jobHandler=io.mycat.sqlengine.OneRawSQLQueryResultHandler@7413229c], host=115.60.12.176, port=3306, statusSync=null, writeQueue=0, modifiedSQLExecuted=false]