mycat配置访问oracle_数据库中间键mycat 实现oracle数据库读写分离

01/14 16:47:08.956   INFO [WrapperSimpleAppMain] (MycatServer.java:195) -========================================

=======

01/14 16:47:08.957   INFO [WrapperSimpleAppMain] (MycatServer.java:196) -MyCat is ready to startup ...

01/14 16:47:08.957   INFO [WrapperSimpleAppMain] (MycatServer.java:206) -Startup processors ...,total processors:

4,aio thread pool size:8

each process allocated socket buffer pool  bytes ,buffer chunk size:4096  buffer pool's capacity(buferPool/buffe

rChunk) is:4000

01/14 16:47:08.957   INFO [WrapperSimpleAppMain] (MycatServer.java:207) -sysconfig params:SystemConfig [processor

BufferLocalPercent=100, frontSocketSoRcvbuf=1048576, frontSocketSoSndbuf=4194304, backSocketSoRcvbuf=4194304, bac

kSocketSoSndbuf=1048576, frontSocketNoDelay=1, backSocketNoDelay=1, maxStringLiteralLength=65535, frontWriteQueue

Size=2048, bindIp=0.0.0.0, serverPort=8066, managerPort=9066, charset=utf8, processors=4, processorExecutor=8, ti

merExecutor=2, managerExecutor=2, idleTimeout=1800000, catletClassCheckSeconds=60, sqlExecuteTimeout=300, process

orCheckPeriod=1000, dataNodeIdleCheckPeriod=300000, dataNodeHeartbeatPeriod=10000, clusterHeartbeatUser=_HEARTBEA

T_USER_, clusterHeartbeatPass=_HEARTBEAT_PASS_, clusterHeartbeatPeriod=5000, clusterHeartbeatTimeout=10000, clust

erHeartbeatRetry=10, txIsolation=3, parserCommentVersion=50148, sqlRecordCount=10, processorBufferPool=16384000,

processorBufferChunk=4096, defaultMaxLimit=100, sequnceHandlerType=0, sqlInterceptor=org.opencloudb.interceptor.i

mpl.DefaultSqlInterceptor, sqlInterceptorType=select, sqlInterceptorFile=/opt/mycat/logs/sql.txt, mutiNodeLimitTy

pe=0, mutiNodePatchSize=100, defaultSqlParser=druidparser, usingAIO=0, packetHeaderSize=4, maxPacketSize=16777216

, mycatNodeId=1]

01/14 16:47:08.991   INFO [WrapperSimpleAppMain] (MycatServer.java:266) -using nio network handler

01/14 16:47:08.998   INFO [WrapperSimpleAppMain] (MycatServer.java:284) -$_MyCatManager is started and listening

on 9066

01/14 16:47:08.999   INFO [WrapperSimpleAppMain] (MycatServer.java:288) -$_MyCatServer is started and listening o

n 8066

01/14 16:47:08.999   INFO [WrapperSimpleAppMain] (MycatServer.java:290) -========================================

=======

01/14 16:47:08.999   INFO [WrapperSimpleAppMain] (MycatServer.java:293) -Initialize dataHost ...

01/14 16:47:08.999   INFO [WrapperSimpleAppMain] (PhysicalDBPool.java:272) -init backend myqsl source ,create con

nections total 10 for hostM1 index :0

01/14 16:47:09.000   INFO [WrapperSimpleAppMain] (PhysicalDatasource.java:373) -not ilde connection in pool,creat

e new connection for hostM1 of schema db1

01/14 16:47:09.000   INFO [WrapperSimpleAppMain] (PhysicalDatasource.java:373) -not ilde connection in pool,creat

e new connection for hostM1 of schema db1

01/14 16:47:09.002   INFO [WrapperSimpleAppMain] (PhysicalDatasource.java:373) -not ilde connection in pool,creat

e new connection for hostM1 of schema db1

01/14 16:47:09.003   INFO [WrapperSimpleAppMain] (PhysicalDatasource.java:373) -not ilde connection in pool,creat

e new connection for hostM1 of schema db1

01/14 16:47:09.003   INFO [WrapperSimpleAppMain] (PhysicalDatasource.java:373) -not ilde connection in pool,creat

e new connection for hostM1 of schema db1

01/14 16:47:09.004   INFO [WrapperSimpleAppMain] (PhysicalDatasource.java:373) -not ilde connection in pool,creat

e new connection for hostM1 of schema db1

01/14 16:47:09.004   INFO [WrapperSimpleAppMain] (PhysicalDatasource.java:373) -not ilde connection in pool,creat

e new connection for hostM1 of schema db1

01/14 16:47:09.010   INFO [WrapperSimpleAppMain] (PhysicalDatasource.java:373) -not ilde connection in pool,creat

e new connection for hostM1 of schema db1

01/14 16:47:09.010   INFO [WrapperSimpleAppMain] (PhysicalDatasource.java:373) -not ilde connection in pool,creat

e new connection for hostM1 of schema db1

01/14 16:47:09.011   INFO [WrapperSimpleAppMain] (PhysicalDatasource.java:373) -not ilde connection in pool,creat

e new connection for hostM1 of schema db1

01/14 16:47:09.167   INFO [BusinessExecutor5] (GetConnectionHandler.java:66) -connected successfuly JDBCConnectio

n [id=5,autocommit=true,pool=org.opencloudb.jdbc.JDBCDatasource@755f1de3, schema=db1, dbType=ORACLE, oldSchema=nu

ll, packetId=0, txIsolation=0, running=false, borrowed=true, host=null, port=-1, con=oracle.jdbc.driver.T4CConnec

tion@37a35e48, respHandler=null, attachement=null, headerOutputed=false, modifiedSQLExecuted=false, startTime=145

2761229004, lastTime=1452761229166, isSpark=false, processor=org.opencloudb.net.NIOProcessor@4682e581]

01/14 16:47:09.168   INFO [BusinessExecutor0] (GetConnectionHandler.java:66) -connected successfuly JDBCConnectio

n [id=1,autocommit=true,pool=org.opencloudb.jdbc.JDBCDatasource@755f1de3, schema=db1, dbType=ORACLE, oldSchema=nu

ll, packetId=0, txIsolation=0, running=false, borrowed=true, host=null, port=-1, con=oracle.jdbc.driver.T4CConnec

tion@1a298fa4, respHandler=null, attachement=null, headerOutputed=false, modifiedSQLExecuted=false, startTime=145

2761229002, lastTime=1452761229168, isSpark=false, processor=org.opencloudb.net.NIOProcessor@4682e581]

01/14 16:47:09.168   INFO [BusinessExecutor6] (GetConnectionHandler.java:66) -connected successfuly JDBCConnectio

n [id=7,autocommit=true,pool=org.opencloudb.jdbc.JDBCDatasource@755f1de3, schema=db1, dbType=ORACLE, oldSchema=nu

ll, packetId=0, txIsolation=0, running=false, borrowed=true, host=null, port=-1, con=oracle.jdbc.driver.T4CConnec

tion@62345ce0, respHandler=null, attachement=null, headerOutputed=false, modifiedSQLExecuted=false, startTime=145

2761229010, lastTime=1452761229168, isSpark=false, processor=org.opencloudb.net.NIOProcessor@5bbda87e]

01/14 16:47:09.171   INFO [BusinessExecutor4] (GetConnectionHandler.java:66) -connected successfuly JDBCConnectio

n [id=6,autocommit=true,pool=org.opencloudb.jdbc.JDBCDatasource@755f1de3, schema=db1, dbType=ORACLE, oldSchema=nu

ll, packetId=0, txIsolation=0, running=false, borrowed=true, host=null, port=-1, con=oracle.jdbc.driver.T4CConnec

tion@1b1d6b02, respHandler=null, attachement=null, headerOutputed=false, modifiedSQLExecuted=false, startTime=145

2761229004, lastTime=1452761229171, isSpark=false, processor=org.opencloudb.net.NIOProcessor@285c5e36]

01/14 16:47:09.171   INFO [BusinessExecutor2] (GetConnectionHandler.java:66) -connected successfuly JDBCConnectio

n [id=3,autocommit=true,pool=org.opencloudb.jdbc.JDBCDatasource@755f1de3, schema=db1, dbType=ORACLE, oldSchema=nu

ll, packetId=0, txIsolation=0, running=false, borrowed=true, host=null, port=-1, con=oracle.jdbc.driver.T4CConnec

tion@12c005a0, respHandler=null, attachement=null, headerOutputed=false, modifiedSQLExecuted=false, startTime=145

2761229003, lastTime=1452761229171, isSpark=false, processor=org.opencloudb.net.NIOProcessor@5bbda87e]

01/14 16:47:09.202   INFO [BusinessExecutor5] (GetConnectionHandler.java:66) -connected successfuly JDBCConnectio

n [id=9,autocommit=true,pool=org.opencloudb.jdbc.JDBCDatasource@755f1de3, schema=db1, dbType=ORACLE, oldSchema=nu

ll, packetId=0, txIsolation=0, running=false, borrowed=true, host=null, port=-1, con=oracle.jdbc.driver.T4CConnec

tion@5e42edff, respHandler=null, attachement=null, headerOutputed=false, modifiedSQLExecuted=false, startTime=145

2761229167, lastTime=1452761229202, isSpark=false, processor=org.opencloudb.net.NIOProcessor@4682e581]

01/14 16:47:09.202   INFO [BusinessExecutor0] (GetConnectionHandler.java:66) -connected successfuly JDBCConnectio

n [id=10,autocommit=true,pool=org.opencloudb.jdbc.JDBCDatasource@755f1de3, schema=db1, dbType=ORACLE, oldSchema=n

ull, packetId=0, txIsolation=0, running=false, borrowed=true, host=null, port=-1, con=oracle.jdbc.driver.T4CConne

ction@567df41c, respHandler=null, attachement=null, headerOutputed=false, modifiedSQLExecuted=false, startTime=14

52761229168, lastTime=1452761229202, isSpark=false, processor=org.opencloudb.net.NIOProcessor@285c5e36]

01/14 16:47:10.088   INFO [BusinessExecutor3] (GetConnectionHandler.java:66) -connected successfuly JDBCConnectio

n [id=4,autocommit=true,pool=org.opencloudb.jdbc.JDBCDatasource@755f1de3, schema=db1, dbType=ORACLE, oldSchema=nu

ll, packetId=0, txIsolation=0, running=false, borrowed=true, host=null, port=-1, con=oracle.jdbc.driver.T4CConnec

tion@3616a983, respHandler=null, attachement=null, headerOutputed=false, modifiedSQLExecuted=false, startTime=145

2761229004, lastTime=1452761230087, isSpark=false, processor=org.opencloudb.net.NIOProcessor@9d2f333]

01/14 16:47:10.092   INFO [BusinessExecutor7] (GetConnectionHandler.java:66) -connected successfuly JDBCConnectio

n [id=8,autocommit=true,pool=org.opencloudb.jdbc.JDBCDatasource@755f1de3, schema=db1, dbType=ORACLE, oldSchema=nu

ll, packetId=0, txIsolation=0, running=false, borrowed=true, host=null, port=-1, con=oracle.jdbc.driver.T4CConnec

tion@89d509e, respHandler=null, attachement=null, headerOutputed=false, modifiedSQLExecuted=false, startTime=1452

761229010, lastTime=1452761230092, isSpark=false, processor=org.opencloudb.net.NIOProcessor@9d2f333]

01/14 16:47:10.097   INFO [BusinessExecutor1] (GetConnectionHandler.java:66) -connected successfuly JDBCConnectio

n [id=2,autocommit=true,pool=org.opencloudb.jdbc.JDBCDatasource@755f1de3, schema=db1, dbType=ORACLE, oldSchema=nu

ll, packetId=0, txIsolation=0, running=false, borrowed=true, host=null, port=-1, con=oracle.jdbc.driver.T4CConnec

tion@592c5cc, respHandler=null, attachement=null, headerOutputed=false, modifiedSQLExecuted=false, startTime=1452

761229002, lastTime=1452761230097, isSpark=false, processor=org.opencloudb.net.NIOProcessor@285c5e36]

01/14 16:47:10.112   INFO [WrapperSimpleAppMain] (PhysicalDBPool.java:301) -init result :finished 10 success 10 t

arget count:10

01/14 16:47:10.112   INFO [WrapperSimpleAppMain] (PhysicalDBPool.java:243) -localhost1 index:0 init success

01/14 16:47:10.116   INFO [Timer0] (PhysicalDatasource.java:269) -create connections ,because idle connection not

enough ,cur is 0, minCon is 10 for hostS1

01/14 16:47:10.197   INFO [BusinessExecutor2] (NewConnectionRespHandler.java:44) -connectionAcquired JDBCConnecti

on [id=12,autocommit=true,pool=org.opencloudb.jdbc.JDBCDatasource@15796446, schema=db1, dbType=ORACLE, oldSchema=

null, packetId=0, txIsolation=0, running=false, borrowed=false, host=null, port=-1, con=oracle.jdbc.driver.T4CCon

nection@54a63aad, respHandler=null, attachement=null, headerOutputed=false, modifiedSQLExecuted=false, startTime=

1452761230118, lastTime=1452761230193, isSpark=false, processor=org.opencloudb.net.NIOProcessor@9d2f333]

01/14 16:47:10.213   INFO [BusinessExecutor6] (NewConnectionRespHandler.java:44) -connectionAcquired JDBCConnecti

on [id=11,autocommit=true,pool=org.opencloudb.jdbc.JDBCDatasource@15796446, schema=db1, dbType=ORACLE, oldSchema=

null, packetId=0, txIsolation=0, running=false, borrowed=false, host=null, port=-1, con=oracle.jdbc.driver.T4CCon

nection@6d565f45, respHandler=null, attachement=null, headerOutputed=false, modifiedSQLExecuted=false, startTime=

1452761230117, lastTime=1452761230193, isSpark=false, processor=org.opencloudb.net.NIOProcessor@5bbda87e]

01/14 16:47:10.228   INFO [BusinessExecutor4] (NewConnectionRespHandler.java:44) -connectionAcquired JDBCConnecti

on [id=13,autocommit=true,pool=org.opencloudb.jdbc.JDBCDatasource@15796446, schema=db1, dbType=ORACLE, oldSchema=

null, packetId=0, txIsolation=0, running=false, borrowed=false, host=null, port=-1, con=oracle.jdbc.driver.T4CCon

nection@1f51c9e, respHandler=null, attachement=null, headerOutputed=false, modifiedSQLExecuted=false, startTime=1

452761230118, lastTime=1452761230213, isSpark=false, processor=org.opencloudb.net.NIOProcessor@4682e581]