下载

http://dl.mycat.org.cn

http://dl.mycat.org.cn/1.6.7.4/Mycat-server-1.6.7.4-release/

配置

<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">

    <schema name="wcp" checkSQLschema="true" sqlMaxLimit="100" dataNode="wcp"></schema>
    <schema name="ekca" checkSQLschema="true" sqlMaxLimit="100" dataNode="ekca"></schema>
    <schema name="wdap" checkSQLschema="true" sqlMaxLimit="100" dataNode="wdap"></schema>
    
    
    <dataNode name="wcp" dataHost="db1" database="wcp" />
    <dataNode name="ekca" dataHost="db1" database="ekca" />
    <dataNode name="wdap" dataHost="db1" database="wdap" />
    
    
    
    
    
    <dataHost name="db1" maxCon="1000" minCon="10" balance="3"
              writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
        <heartbeat>select user()</heartbeat>
        <!-- can have multi write hosts -->
        <writeHost host="W1" url="localhost:3341" user="root" password="root">
              <readHost host="R1" url="localhost:3342" user="root" password="root" />
        </writeHost>
        <!-- <writeHost host="hostM2" url="localhost:3316" user="root" password="123456"/> -->
    </dataHost>
    
</mycat:schema>

启动

找到mycat解压目录下的bin目录，bin目录下有一个叫startup_nowrap.bat的文件，这就是mycat的启动文件。

测试