版本:
5.5.8-mycat-1.4-RELEASE-20150901112004,
OS: ContOS 6.5
MySQL: 5.6.24-72.2-25.11-log Percona XtraDB Cluster binary (GPL) 5.6.24-25.11, Revision, wsrep_25.11(3节点)
schema.xml配置如下:
writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
select user()
writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
select user()
writeType="0" dbType="mysql" dbDriver="native" switchType="2" slaveThreshold="100">
show slave status
/mycat:schema
server.xml配置如下:
druidparser
8066 9066
a
spocosy
a
18test
a
fb_console
a
football2
a
game
a
gate
a
lahai
a
win007
a
calc
a
test
a
fb_snap
a
football
a
forum
a
console
a
leixj
/mycat:server
wrapper.conf只修改了jdk的路径,其他默认,jdk版本1.7.0_60
警告日志如下:
09/14 20:39:19.282 WARN $_NIOREACTOR-4-RW -can't sure connection syn result,so close it MySQLConnection [id=4015, lastTime=1442234359270, schema=calc, old shema=football2, borrowed=true, fromSlaveDB=false, threadId=4527, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=SQLJob [ id=0,dataNodeOrDatabase=calc,sql=select user(), jobHandler=org.opencloudb.sqlengine.OneRawSQLQueryResultHandler@77409080], host=192.168.88.12, port=3306, statusSync=org.opencloudb.mysql.nio.MySQLConnection$StatusSync@3f34b16b, writeQueue=0, modifiedSQLExecuted=false]
09/14 20:39:19.282 WARN $_NIOREACTOR-5-RW -can't sure connection syn result,so close it MySQLConnection [id=4024, lastTime=1442234359270, schema=calc, old shema=football2, borrowed=true, fromSlaveDB=false, threadId=1149347, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=SQLJob [ id=0,dataNodeOrDatabase=calc,sql=select user(), jobHandler=org.opencloudb.sqlengine.OneRawSQLQueryResultHandler@2fcf00aa], host=192.168.88.13, port=3306, statusSync=org.opencloudb.mysql.nio.MySQLConnection$StatusSync@1c6c0838, writeQueue=0, modifiedSQLExecuted=false]
09/14 20:39:29.282 WARN $_NIOREACTOR-3-RW -can't sure connection syn result,so close it MySQLConnection [id=4022, lastTime=1442234369272, schema=calc, old shema=football2, borrowed=true, fromSlaveDB=false, threadId=1149344, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=SQLJob [ id=0,dataNodeOrDatabase=calc,sql=select user(), jobHandler=org.opencloudb.sqlengine.OneRawSQLQueryResultHandler@763f03c3], host=192.168.88.13, port=3306, statusSync=org.opencloudb.mysql.nio.MySQLConnection$StatusSync@231033db, writeQueue=0, modifiedSQLExecuted=false]
09/14 20:39:29.283 WARN $_NIOREACTOR-2-RW -can't sure connection syn result,so close it MySQLConnection [id=4013, lastTime=1442234369272, schema=calc, old shema=football2, borrowed=true, fromSlaveDB=false, threadId=4523, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=SQLJob [ id=0,dataNodeOrDatabase=calc,sql=select user(), jobHandler=org.opencloudb.sqlengine.OneRawSQLQueryResultHandler@3cdd9094], host=192.168.88.12, port=3306, statusSync=org.opencloudb.mysql.nio.MySQLConnection$StatusSync@7cbc80d8, writeQueue=0, modifiedSQLExecuted=false]
09/14 20:39:39.282 WARN $_NIOREACTOR-2-RW -can't sure connection syn result,so close it MySQLConnection [id=4028, lastTime=1442234379268, schema=calc, old shema=football2, borrowed=true, fromSlaveDB=false, threadId=4554, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=SQLJob [ id=0,dataNodeOrDatabase=calc,sql=select user(), jobHandler=org.opencloudb.sqlengine.OneRawSQLQueryResultHandler@689ac6da], host=192.168.88.12, port=3306, statusSync=org.opencloudb.mysql.nio.MySQLConnection$StatusSync@72c10304, writeQueue=0, modifiedSQLExecuted=false]
09/14 20:39:39.283 WARN $_NIOREACTOR-1-RW -can't sure connection syn result,so close it MySQLConnection [id=4027, lastTime=1442234379268, schema=calc, old shema=football2, borrowed=true, fromSlaveDB=false, threadId=1149381, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=SQLJob [ id=0,dataNodeOrDatabase=calc,sql=select user(), jobHandler=org.opencloudb.sqlengine.OneRawSQLQueryResultHandler@97547dd], host=192.168.88.13, port=3306, statusSync=org.opencloudb.mysql.nio.MySQLConnection$StatusSync@5dad3677, writeQueue=0, modifiedSQLExecuted=false]
将这个mycat的所有的文件拷贝一份,修改端口,在同一台机上面启起来,但是没有任何外来的连接请求,不报警告。