数据库中间键mycat 实现oracle数据库读写分离

首先 下载mycat中间键 下载地址 

https://github.com/MyCATApache/Mycat-download 

本文采用的是1.4

linux下可以采用wget命令下载到opt目录：

wget https://github.com/MyCATApache/Mycat-download/blob/master/1.4-RELEASE/Mycat-server-1.4-release-20151019230038-linux.tar.gz

解压

解压命令：

tar -zxvf Mycat-server-1.4-release-20151019230038-linux.tar.gz

配置环境变量：

vi /etc/profile

在文尾加入

MYCAT_HOME=/opt/mycat
PATH=$PATH:$MYCAT_HOME/bin
export MYCAT_HOME PATH

修改配置 文件

/opt/mycat/conf/wrapper.conf

修改wrapper.java.command 为jdk的bin目录下的java

wrapper.java.command=/opt/jdk1.7.0_45/bin/java

修改配置文件/opt/mycat/conf/server.xml

设置mycat用户名和密码 

  <user name="root"> //用户名和密码随意设置
                <property name="password">root</property>
                <property name="schemas">ORACLEDB</property>//schemas对应schema.xml中的schema
        </user>

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

修改配置文件 /opt/mycat/conf/schema.xml

<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://org.opencloudb/">
        <schema name="<span style="color:#ff0000;">ORACLEDB</span>" checkSQLschema="false" dataNode="dn1">  //
        </schema>
<dataNode name="dn1" dataHost="localhost1" database="db1" />
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="1" writeType="0" dbType="oracle" dbDriver="jdbc">
        <heartbeat>select 1 from dual</heartbeat>
        <writeHost host="hostM1" url="jdbc:oracle:thin:@10.16.13.23:1521/orcl" user="test_user" password="test_user" > 
                <readHost host="hostS1" url="jdbc:oracle:thin:@10.16.12.9:1521/orcl" user="strmadmin" passw
ord="strmadmin"/>
        </writeHost>
</dataHost>
</mycat:schema>

配置结束

然后 启动mycat 

mycat start

可以查看日志文件看是否报错/opt/mycat/logs/mycat.log

01/14 16:47:08.956   INFO [WrapperSimpleAppMain] (MycatServer.java:195) -========================================
=======
01/14 16:47:08.957   INFO [WrapperSimpleAppMain] (MycatServer.java:196) -MyCat is ready to startup ...
01/14 16:47:08.957   INFO [WrapperSimpleAppMain] (MycatServer.java:206) -Startup processors ...,total processors:
4,aio thread pool size:8    
 each process allocated