实践-基于Docker搭建的mycat分片应用

############################################
# version : debugman007/c7-mycat:v1
# desc : centos7 上安装的mycat
############################################
# 设置继承自 centos7 官方镜像
FROM centos:7 
RUN echo "root:root" | chpasswd
RUN yum -y install net-tools
# install java
ADD http://mirrors.linuxeye.com/jdk/jdk-7u80-linux-x64.tar.gz /usr/local/  
RUN cd /usr/local && tar -zxvf jdk-7u80-linux-x64.tar.gz && rm -f jdk-7u80-linux-x64.tar.gz
ENV JAVA_HOME /usr/local/jdk1.7.0_80
ENV CLASSPATH ${JAVA_HOME}/lib/dt.jar:$JAVA_HOME/lib/tools.jar
ENV PATH $PATH:${JAVA_HOME}/bin
#install mycat
ADD http://dl.mycat.io/1.6-RELEASE/Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz /usr/local
RUN cd /usr/local && tar -zxvf Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz && rm -f Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz  
VOLUME d://docker/mycat:/usr/local/mycat/conf
EXPOSE 8066 9066
CMD ["/usr/local/mycat/bin/mycat", "console"]

docker run --name one-mysql -e MYSQL_ROOT_PASSWORD=123456 -d -p 3307:3306 mysql:5.7
 docker run --name two-mysql -e MYSQL_ROOT_PASSWORD=123456 -d -p 3307:3306 mysql:5.7

docker rm -f mycat
docker run -d -v e:/mycat/conf:/usr/local/mycat/conf -d 8066:8066 -d 9066:9066 --name mycat mycat 
docker ps

<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
  <schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100">
    <!-- auto sharding by id (long) -->
    <table name="tb_test" dataNode="dn1,dn2,dn3,dn4,dn5,dn6" rule="auto-sharding-long-jp" />
    <!-- 全局表自动克隆到所有已定义的数据节点，因此可以连接与分片节点位于同一数据节点中的任何表 -->
    <table name="company" primaryKey="ID" type="global" dataNode="dn1,dn2,dn3,dn4,dn5,dn6" rule="auto-sharding-long"/>
    <!-- 使用mod sharind规则的随机共享 -->
  </schema>
  <dataNode name="dn1" dataHost="localhost1" database="db1" />
  <dataNode name="dn2" dataHost="localhost1" database="db2" />
  <dataNode name="dn3" dataHost="localhost1" database="db3" />
  <dataNode name="dn4" dataHost="localhost2" database="db1" />
  <dataNode name="dn5" dataHost="localhost2" database="db2" />
  <dataNode name="dn6" dataHost="localhost2" database="db3" />
  <dataHost name="localhost1" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
    <heartbeat>select user()</heartbeat>
    <!-- 可以有多写主机 -->
    <writeHost host="hostM1" url="172.17.0.3:3306" user="root" password="123456">
      <!-- 可以有多读主机
      <readHost host="hostS2" url="192.168.1.200:3306" user="root" password="xxx" /> -->
    </writeHost>
    <!--<writeHost host="hostS1" url="localhost:3316" user="root" password="123456" /> -->
  </dataHost>
  <dataHost name="localhost2" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
    <heartbeat>select user()</heartbeat>
    <writeHost host="hostM1" url="172.17.0.4:3306" user="root" password="123456"/>
  </dataHost>
</mycat:schema>

CREATE TABLE `company` (
  `id` int(11) NOT NULL,
  `name` varchar(20) DEFAULT NULL,
  `age` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into company (id,NAME,age) values (1,'jp',25);

CREATE TABLE tb_test (
  id BIGINT(20) NOT NULL,
  title VARCHAR(100) NOT NULL ,
  PRIMARY KEY (id)
) ENGINE=INNODB DEFAULT CHARSET=utf8 ;
INSERT INTO tb_test(ID,TITLE) VALUES(1,'蒋老湿1');
INSERT INTO tb_test(ID,TITLE) VALUES(6000,'蒋老湿2');
INSERT INTO tb_test(ID,TITLE) VALUES(10001,'蒋老湿3');
INSERT INTO tb_test(ID,TITLE) VALUES(15001,'蒋老湿4');
INSERT INTO tb_test(ID,TITLE) VALUES(20001,'蒋老湿5');
INSERT INTO tb_test(ID,TITLE) VALUES(25001,'蒋老湿6');
INSERT INTO tb_test(ID,TITLE) VALUES(30001,'蒋老湿error');