mycat入門

打開mycat 官網

簡介
https://github.com/MyCATApache/Mycat-Server/wiki/1.0-Mycat%E7%AE%80%E4%BB%8B

下載
https://github.com/MyCATApache/Mycat-download/tree/master/1.6-RELEASE

啟動前，一般需要修改JVM配置引數，打開conf/wrapper.conf檔案，如下行的內容為2G和2048，可根據本機配置情況修改為512M或其它值， 以下配置跟jvm引數完全一致，可以根據自己的jvm引數調整，

wrapper.java.additional.12=-XX:+UseParNewGC
wrapper.java.additional.13=-XX:+UseConcMarkSweepGC
wrapper.java.additional.14=-XX:+UseCMSCompactAtFullCollection
wrapper.java.additional.15=-XX:CMSFullGCsBeforeCompaction=0
wrapper.java.additional.16=-XX:CMSInitiatingOccupancyFraction=70

server.xml 中添加

<property name="processors">16</property> <!--cpu處理數量-->
<property name="processorExecutor">32</property><!--線城池數量-->

schema.xml 中修改

<dataHost name="localhost1" maxCon="1000" minCon="1000" balance="0"
			  writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
		<heartbeat>select user()</heartbeat>
		<!-- can have multi write hosts -->
		<writeHost host="hostM1" url="192.168.59.129:3339" user="root"
				   password="123456">
			<!-- can have multi read hosts -->
			<readHost host="hostS2" url="192.168.59.129:3340" user="root" password="123456" />
		</writeHost>
		<!-- <writeHost host="hostM2" url="localhost:3316" user="root" password="123456"/> -->
	</dataHost>

配置入門

https://github.com/MyCATApache/Mycat-Server/wiki/3.0-Mycat%E9%85%8D%E7%BD%AE%E5%85%A5%E9%97%A8
分片的概念：分庫 水平分庫（庫表結構都是一樣的集群） 垂直分庫（按照業務分庫 分布式）
磁區的概念：分表

<schema name="db_jxc" checkSQLschema="false" sqlMaxLimit="100">
		<!-- auto sharding by id (long) -->
		<!-- <table name="travelrecord" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"  primaryKey="ID" type="global"/> -->
		<table name="t_user_role"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_user"    primaryKey="ID" dataNode="dn1,dn2,dn3"  rule="auto-sharding-long"/>
		<table name="t_supplier"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_sale_list_goods"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_sale_list"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_role_menu"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_role"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_return_list_goods"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_return_list"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_purchase_list_goods"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_purchase_list"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_overflow_list_goods"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_overflow_list"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_menu"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_log"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_goodsunit"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_goodstype"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_goods"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_damage_list_goods"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_damage_list"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_customer_return_list_goods"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_customer_return_list"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
		<table name="t_customer"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>

		<!-- <table name="oc_call" primaryKey="ID" dataNode="dn1$0-743" rule="latest-month-calldate"
			/> -->
	</schema>
	<!-- <dataNode name="dn1$0-743" dataHost="localhost1" database="db$0-743"
		/> -->
	<dataNode name="dn1" dataHost="localhost1" database="db_jxc1" />
	<dataNode name="dn2" dataHost="localhost1" database="db_jxc1" />
	<dataNode name="dn3" dataHost="localhost1" database="db_jxc1" />
	<!--<dataNode name="dn4" dataHost="sequoiadb1" database="SAMPLE" />
	 <dataNode name="jdbc_dn1" dataHost="jdbchost" database="db1" />
	<dataNode	name="jdbc_dn2" dataHost="jdbchost" database="db2" />
	<dataNode name="jdbc_dn3" 	dataHost="jdbchost" database="db3" /> -->
	<dataHost name="localhost1" maxCon="1000" minCon="1000" balance="0"
			  writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
		<heartbeat>select user()</heartbeat>
		<!-- can have multi write hosts -->
		<writeHost host="hostM1" url="192.168.59.129:3339" user="root"
				   password="123456">
			<!-- can have multi read hosts -->
			<readHost host="hostS2" url="192.168.59.129:3340" user="root" password="123456" />
		</writeHost>
		<!-- <writeHost host="hostM2" url="localhost:3316" user="root" password="123456"/> -->
	</dataHost>

Mycat-Web

Mycat,mycat eye 依賴 jdk1.7＋環境，jdk 下載地址為：
http://www.oracle.com/technetwork/java/javase/downloads/

Zookeeper 環境要求

Mycat eye 需要 Zookeeper 作為配置中心
zookeeper-3.4.6.tar.gz

Zookeeper 配置

1. 解 壓 zookeeper-3.4.6.tar.gz;
2. zookeeper-3.4.6\conf 目錄下把 zoo_sample.cfg 修改為 zoo.cfg;
3. 啟動 zookeeper
Windowns 作業系統啟動命令： zookeeper-3.4.6\bin\zkServer.bat
Linux 作業系統啟動命令：zookeeper-3.4.6\bin\zkServer.sh start
mycat  資料 ;

Mycat eye 環境部署

軟體清單
Windowns 版本：
Mycat-web-1.0-SNAPSHOT-20151208180035-win.zip
Linux 版本：
Mycat-web-1.0-SNAPSHOT-20151208180035-linux.tar.gz
下載地址：https://github.com/MyCATApache/Mycat-download/tree/master/mycat-web-1.0

加壓后生成 mycat-web 目錄，目錄結構如下：

先啟動 zookeeper；
然后啟動 mycat eye
Windowns 版本：
start.bat
Linux 版本：
start.sh
訪問 mycat eye
http://localhost:8082/mycat/
mycat.properties 配置
如果 zookeeper 連接不上
mycat-web\mycat-web\WEB-INF\classes\ mycat.properties 組態檔
zookeeper=127.0.0.1:2181
配置下 zookeeper 的服務器和埠
方法 2：訪問 http://localhost:8082/mycat/

思路：
1、mycat 的server.xml 我們需要關心的是

2、schema.xml:

3、用 navicat 連接master 庫，創建 路由對應的資料庫（物理庫），創建表結構和資料
4、使用navicat 連接mycat ，再mycat 中添加資料進行測驗
5、再專案中配置mycat

mycat具體相關資料放在博客資源tag下面,免費自取