#上传压缩包

rz 

#解压

tar -zxvf Mycat-server-1.6.-release--linux.tar.gz

#配置环境变量

vim /etc/profile

增加

export MYCAT_HOME=/gome/mycat

#生效

source /etc/profile

service.xml主要配置mycat服务的参数，比如端口号，myact用户名和密码使用的逻辑数据库等

role.xml主要配置路由策略，主要有分片的片键，拆分的策略（取模还是按区间划分等）

schema.xml文件主要配置数据库的信息，例如逻辑数据库名称，物理上真实的数据源以及表和数据源之间的对应关系和路由策略等。

create database db01; 

 CREATE TABLE users (

    id INT NOT NULL AUTO_INCREMENT,

    name varchar() NOT NULL default '',

    indate DATETIME NOT NULL default '0000-00-00 00:00:00',

    PRIMARY KEY (id)

)AUTO_INCREMENT=  ENGINE=InnoDB DEFAULT CHARSET=utf8;  

create database db02;

 CREATE TABLE item (

    id INT NOT NULL AUTO_INCREMENT,

    value INT NOT NULL default ,

    indate DATETIME NOT NULL default '0000-00-00 00:00:00',

    PRIMARY KEY (id)

)AUTO_INCREMENT=  ENGINE=InnoDB DEFAULT CHARSET=utf8;

create database db03;

CREATE TABLE item (

    id INT NOT NULL AUTO_INCREMENT,

    value INT NOT NULL default ,

    indate DATETIME NOT NULL default '0000-00-00 00:00:00',

    PRIMARY KEY (id)

)AUTO_INCREMENT=  ENGINE=InnoDB DEFAULT CHARSET=utf8; 

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mycat:server SYSTEM "server.dtd">

<mycat:server xmlns:mycat="http://io.mycat/">

    <system>

        <property name="defaultSqlParser">druidparser</property>

        <property name="mutiNodeLimitType"></property>

        <property name="serverPort"></property>

        <property name="managerPort"></property>

    </system>

    <user name="test">

            <property name="password">test</property>

            <property name="schemas">TESTDB</property>

    </user> 

    <user name="user">

            <property name="password">user</property>

            <property name="schemas">TESTDB</property>

            <property name="readOnly">true</property>

    </user>  

</mycat:server>

<?xml version="1.0"?>

<!DOCTYPE mycat:schema SYSTEM "schema.dtd">

<mycat:schema xmlns:mycat="http://io.mycat/">  

    <!-- 设置表的存储方式.schema name="TESTDB" 与 server.xml中的 TESTDB 设置一致  -->

    <schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="">

        <table name="users" primaryKey="id"  dataNode="node_db01" />

        <table name="item" primaryKey="id" dataNode="node_db02,node_db03" rule="role1" />  

    </schema>  

    <!-- 设置dataNode 对应的数据库,及 mycat 连接的地址dataHost -->

    <dataNode name="node_db01" dataHost="dataHost01" database="db01" />

    <dataNode name="node_db02" dataHost="dataHost01" database="db02" />

    <dataNode name="node_db03" dataHost="dataHost01" database="db03" />  

    <!-- mycat 逻辑主机dataHost对应的物理主机.其中也设置对应的mysql登陆信息 -->

    <dataHost name="dataHost01" maxCon="" minCon="" balance="" writeType="" dbType="mysql" dbDriver="native">

            <heartbeat>select user()</heartbeat>

            <writeHost host="server1" url="127.0.0.1:3306" user="root" password=""/>

    </dataHost>

</mycat:schema>

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mycat:rule SYSTEM "rule.dtd">

<mycat:rule xmlns:mycat="http://io.mycat/">

    <tableRule name="role1">

        <rule>

            <columns>id</columns>

            <algorithm>mod-long</algorithm>

        </rule>

    </tableRule>

    <function name="mod-long" class="io.mycat.route.function.PartitionByMod">

        <!-- how many data nodes -->

        <property name="count"></property>

    </function>

</mycat:rule>

./bin/startup_nowrap.sh

#进入mycat逻辑数据库

mysql -utest -ptest -h127.0.0. -P8066 -DTESTDB

#执行插入sql
insert into users(name,indate) values('kk',now()); 
insert into users(name,indate) values('ss',now()); 
insert into item(id,value,indate) values(1,100,now()); 
insert into item(id,value,indate) values(2,100,now());