mysql数据中间件mycat核心配置修改

mycat配置

总配置环境变量 位置vi /etc/profile

export JAVA_HOME=/usr/local/jdk/jdk1.8.0_161
export JRE_HOME=$JAVA_HOME/jre
export CLASSPATH=.:$JAVA_HOME/lib:$JRE_HOME/lib:$CLASSPATH
# :$PATH:$M2_HOME/bin
export M2_HOME=/usr/local/java/apache-maven-3.5.3
export CLASSPATH=$CLASSPATH:$M2_HOME/lib

export PATH=$JAVA_HOME/bin:$JRE_HOME/bin:$PATH
export MYCAT_HOME=/usr/local/mycat/mycat
export ZOOKEEPER_HOME=/usr/local/mycat/zookeeper-3.4.10

下载文件

http://dl.mycat.io/

修改配置文件schema.xml

    <?xml version="1.0"?>
        <!DOCTYPE mycat:schema SYSTEM "schema.dtd">
        <mycat:schema xmlns:mycat="http://io.mycat/">
        
        	<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="2"
        			  writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
        		<heartbeat>select user()</heartbeat>
        		<!-- can have multi write hosts -->
        		<writeHost host="192.168.232.164" url="192.168.232.164:3306" user="root"
        				   password="123456">
        			<!-- can have multi read hosts -->
        			<readHost host="192.168.232.165" url="192.168.232.165:3306" user="root" password="123456" />
        		</writeHost>
        		<writeHost host="192.168.232.165" url="192.168.232.165:3306" user="root"
        				   password="123456" />
        
        	</dataHost>
    </mycat:schema>

启动

mycat start     启动
mycat restart   重启
mycat stop    关闭

配置配置文件zookice

mycat-web下载

https://github.com/MyCATApache/Mycat-download/tree/master/mycat-web-1.0


启动./start.sh &
查看是否启动：netstat  -ant | grep 8082