Mycat Installation Deployment

1, download Mycat Https://github.com/MyCATApache/Mycat-download Choose the appropriate version of the download, currently I am using 1.5.1 version

2. Installing JDK requires 1.7 or above version http://blog.csdn.net/linlinv3/article/details/45060705

3, decompression TAR-ZXVF mycat-server-1.5.1-release-20160622153300-linux.tar.gz

Where JDK storage address is:/home/lin/soft/jdk1.7.0_79

Mycat Storage Address:/home/lin/soft/mycat

Store the address according to personal habits to put.

4. Modify the configuration file

lin@lin190:~/soft/mycat/conf$ Vim wrapper.conf Wrapper.java.command=/home/lin/soft/jdk1.7.0_79/bin/java

Configuring Environment variables

Export Mycat_home=/home/lin/soft/mycat

5. Start Mycat

lin@lin190:~/soft/mycat/bin$./mycat Start starting mycat-server ...

6. Whether the test starts successfully

lin@lin190:~/soft/mycat/bin$ Netstat-ntulp |grep 8066 (not all processes could be identified, non-owned process info'll Not being shown, you would has to be the root to see it all.) TCP6 0 0::: 8066:::* LISTEN 25941/java

The Mycat is using port 8066, which proves that it has been started

7. Install MySQL for testing

Installation Steps http://blog.csdn.net/linlinv3/article/details/51774040

8, use the following statement to test Mycat and MySQL link

Mysql-utest-ptest-h127.0.0.1-p8066-dtestdb

lin@lin190:/home$ mysql-utest-ptest-h127.0.0.1-p8066-dtestdb Reading table information for completion of table and Co  Lumn names You can turn off this feature to get a quicker startup With-a Welcome to the MySQL Monitor. Commands End With; or \g. Your MySQL Connection ID is 1 server version:5.5.8-mycat-1.5.1-release-20160622153300 mycat Server (OPENCLOUNDDB) Copyrig HT (c), Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of the Oracle Corporation and/or its affiliates. Other names trademarks of their respective owners.

Note: Linux under Deployment to install MySQL, the default does not ignore table name case, you need to manually configure Lower_case_table_names=1 under/ETC/MY.CNF to make MySQL ignore table name case in Linux environment, otherwise when using Mycat will prompt I can't find the table!

Mycat installation was successful.