读写分离配置 dtd add 1.4 auto mycat ons pin 127.0.0.1
- <?xml version="1.0" ?>
- <!DOCTYPE mycat:schema SYSTEM "schema.dtd">
- <mycat:schemaxmlns:mycat="http://io.mycat/">
- <schemaname="database1"checkSQLschema="false"sqlMaxLimit="100"dataNode="dn1"> </schema>
- <dataNodename="dn1"dataHost="ssss"database="database1"/>
- <dataHostname="ssss"maxCon="1000"minCon="10"balance="1"
- writeType="0"dbType="mysql"dbDriver="native"switchType="-1" slaveThreshold="100">
- <heartbeat>select user()</heartbeat>
- <writeHosthost="cluster1"url="10.2.2.105:3306"user="root"password="root">
- <readHosthost="cluster2"url="10.2.2.105:3307"user="root"password="root"/>
- <readHosthost="cluster3"url="10.2.2.105:3308"user="root"password="root"/>
- </writeHost>
- </dataHost>
- </mycat:schema>
修改 server.xml
- <?xml version="1.0" encoding="UTF-8" ?>
- <!DOCTYPE mycat:server SYSTEM "server.dtd">
- <mycat:serverxmlns:mycat="http://io.mycat/">
- <system>
- </system>
- <username="admin">
- <propertyname="password">admin</property>
- <propertyname="schemas">database1</property>
- </user>
- </mycat:server>
- ~
启动 mycat ./mycat start
查看端口
- # netstat -tnlp
- TCP *:9066(LISTEN)#虚拟schema管理端口
- TCP *:8066(LISTEN)#虚拟schema登陆端口
mycat 文档
- mysql - uroot - p123456 - h127.0.0.1 - P 8066
来源: http://www.bubuko.com/infodetail-2450411.html