mycat

 
tar xvf jdk-7u79-linux-x64.tar.gz
mv jdk1.7.0_79 /usr/local/
vim /etc/profile
export JAVA_HOME=/usr/local/jdk1.7.0_79
export PATH=$JAVA_HOME/bin:$PATH
export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
source /etc/profile


tar zxvf Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz
useradd mycat
passwd mycat
mv mycat /usr/local/



vim /etc/profile
export MYCAT_HOME=/usr/local/mycat
source /etc/profile

cd /usr/local/mycat/conf
vim schema.xml
<mycat:schema xmlns:mycat="http://org.opencloudb/">

<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">

</schema>

<dataNode name="dn1" dataHost="localhost1" database="db1" />

<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.25.254.6:3306" user="root" password="NANjidong+007">

<readHost host="hostS1" url="172.25.254.7:3306" user="root" password="NANjidong+007" />

                </writeHost>

        </dataHost>
vim server.xml
        <user name="test">
                <property name="password">test</property>
                <property name="schemas">TESTDB</property>

                <!-- 表级 DML 权限设置 -->
                <!--            
                <privileges check="false">
                        <schema name="TESTDB" dml="0110" >
                                <table name="tb01" dml="0000"></table>
                                <table name="tb02" dml="1111"></table>
                        </schema>
                </privileges>           
                 -->
        </user>

        <user name="user">
                <property name="password">user</property>
                <property name="schemas">TESTDB</property>
                <property name="readOnly">true</property>
        </user>

</mycat:server>
/usr/local/mycat/bin/mycat start
测试：