mycat读写分离配置

Linux下安装mycat

1下载mycat

2解压mycat

   tar –zxvf 解压包名 

3将mycat 移动

mv mycat /usr/local

4配置环境变量

命令终端：gedit~/.bashrc

添加

export MYCAT_HOME=/usr/local/ mycat

export JAVA_HOME=/usr/lib/jvm /java-8-oracle
export CLASSPATH=.:$JAVA_HOME/jre/lib/rt.jar:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
export PATH=$JAVA_HOME/bin:$PATH

配置生效:source~/.bashrc

5 配置schema.xml

<?xml version="1.0"?>

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

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

<schema name="mycat"checkSQLschema="false" sqlMaxLimit="100"dataNode="my" />

<dataNode name="my"dataHost="test" database="crrc" />

<dataHost name="test"maxCon="1000" minCon="10" balance="3"writeType="0" dbType="mysql" dbDriver="native">

<heartbeat>selectuser()</heartbeat>

<writeHost host="master"url="192.168.1.195:3306" user="root"password="suroot" >

 <readHost host="slave"url="192.168.1.194:3306" user="root"password="suroot" />

 </writeHost>

 </dataHost>

</mycat:schema>

6 配置server.xml

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

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

<mycat:serverxmlns:mycat="http://io.mycat/">

         <system>

         <propertyname="useSqlStat">0</property>  

         <propertyname="useGlobleTableCheck">0</property> 

                   <propertyname="sequnceHandlerType">2</property>

                   <propertyname="processorBufferPoolType">0</property>

                   <propertyname="handleDistributedTransactions">0</property>

                   <propertyname="useOffHeapForMerge">1</property>

                   <propertyname="memoryPageSize">1m</property>

                   <propertyname="spillsFileBufferSize">1k</property>

                   <propertyname="useStreamOutput">0</property>

                   <propertyname="systemReserveMemorySize">384m</property>

         </system>

         <username="root">

                   <propertyname="password">suroot</property>

                   <propertyname="schemas">mycat</property>            

         </user>

</mycat:server>

7 开启mycat

/usr/local/mycat/bin/mycat start

8 连接mycat

mysql -uroot -psuroot -h127.0.0.1 -P8066–DTESTDB