MyCAT官网:http://www.mycat.io/
环境:两台已经做好主从复制的机子192.168.1.67(主) 192.168.1.68(从),一台mycat(192.168.1.60),一台同网段,拥有mysql客户端的机子
在mycat机上:
1、解压安装jdk
[root@localhost ~]# ls
anaconda-ks.cfg jdk-8u192-linux-x64.tar.gz Mycat-server-1.6.5-release-20180122220033-linux.tar.gz
[root@localhost ~]# systemctl stop firewalld
[root@localhost ~]# systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
[root@localhost ~]# setenforce 0
[root@localhost ~]# tar -xf jdk-8u192-linux-x64.tar.gz
[root@localhost ~]# tar -xf Mycat-server-1.6.5-release-20180122220033-linux.tar.gz
[root@localhost ~]# cp -r jdk1.8.0_192/ /usr/local/jdk
[root@localhost ~]# cp -r mycat/ /usr/local/
[root@localhost ~]# ls /usr/local/jdk/
bin jre README.html THIRDPARTYLICENSEREADME.txt
COPYRIGHT lib release
include LICENSE src.zip
javafx-src.zip man THIRDPARTYLICENSEREADME-JAVAFX.txt
[root@localhost ~]# sed -i '$aexport JAVA_HOME=/usr/local/jdk' /etc/profile
[root@localhost ~]# sed -i '$aexport PATH=$PATH:$JAVA_HOME/bin' /etc/profile
[root@localhost ~]# java -version
java version "1.8.0_192"
Java(TM) SE Runtime Environment (build 1.8.0_192-b12)
Java HotSpot(TM) 64-Bit Server VM (build 25.192-b12, mixed mode)
[root@localhost ~]# javac -version
javac 1.8.0_192
2、测试启动mycat
[root@localhost ~]# ls /usr/local/mycat/
bin catlet conf lib logs version.txt
[root@localhost ~]# ll /usr/local/mycat/bin
总用量 384
-rwxr-xr-x. 1 root root 3567 8月 15 15:18 dataMigrate.sh
-rwxr-xr-x. 1 root root 1225 8月 15 15:18 init_zk_data.sh
-rwxr-xr-x. 1 root root 15714 8月 15 15:18 mycat
-rwxr-xr-x. 1 root root 2941 8月 15 15:18 rehash.sh
-rwxr-xr-x. 1 root root 2496 8月 15 15:18 startup_nowrap.sh
-rwxr-xr-x. 1 root root 140198 8月 15 15:18 wrapper-linux-ppc-64
-rwxr-xr-x. 1 root root 99401 8月 15 15:18 wrapper-linux-x86-32
-rwxr-xr-x. 1 root root 111027 8月 15 15:18 wrapper-linux-x86-64
3、启动mycat
[root@localhost ~]# /usr/local/mycat/bin/mycat console
Running Mycat-server...
wrapper | --> Wrapper Started as Console
wrapper | Launching a JVM...
jvm 1 | Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=64M; support was removed in 8.0
jvm 1 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org
jvm 1 | Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved.
jvm 1 |
jvm 1 | log4j:WARN No appenders could be found for logger (io.mycat.memory.MyCatMemory).
jvm 1 | log4j:WARN Please initialize the log4j system properly.
jvm 1 | log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
jvm 1 | MyCAT Server startup successfully. see logs in logs/mycat.log
4、找到server.xml和schema.xml
[root@localhost ~]# ls /usr/local/mycat/conf/
autopartition-long.txt migrateTables.properties sequence_distributed_conf.properties
auto-sharding-long.txt myid.properties sequence_time_conf.properties
auto-sharding-rang-mod.txt partition-hash-int.txt server.xml
cacheservice.properties partition-range-mod.txt sharding-by-enum.txt
dbseq.sql rule.xml wrapper.conf
ehcache.xml schema.xml zkconf
index_to_charset.properties sequence_conf.properties zkdownload
log4j2.xml sequence_db_conf.properties
5、配置server.xml
[root@localhost ~]# vim /usr/local/mycat/conf/server.xml
6、配置schema.xml
[root@localhost ~]# vim /usr/local/mycat/conf/schema.xml
7、启动刚刚配置好的服务
[root@localhost ~]# /usr/local/mycat/bin/mycat start
Starting Mycat-server...
[root@localhost ~]# netstat -lnput|grep 8066
tcp6 0 0 :::8066 :::* LISTEN 4516/java
8、客户机测试:
[root@client ~]# mysql -utdr -h192.168.1.60 -ptdr_123 -P8066