下载

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="NWCP"></schema>
	<schema name="ekca" checkSQLschema="true" sqlMaxLimit="100" dataNode="NEKCA"></schema>
	<schema name="wdap" checkSQLschema="true" sqlMaxLimit="100" dataNode="NWDAP"></schema>

	<dataNode name="NWCP" dataHost="db1" database="wcp" />
	<dataNode name="NEKCA" dataHost="db1" database="ekca" />
	<dataNode name="NWDAP" 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的启动文件。

测试