Shulou(Shulou.com)06/01 Report--

What is Mycat? From the point of view of definition and classification, it is an open source distributed database system and a Server that implements MySQL protocol. Front-end users can regard it as a database agent, which can be accessed by MySQL client tools and command line, while its back-end can communicate with multiple MySQL servers using MySQL native (Native) protocol, or with most mainstream database servers using JDBC protocol. Its core function is to divide tables and libraries. Split a large table horizontally into N small tables and store them in a back-end MySQL server or other database.

one。 Install jdk

Download address: http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html

Decompress tar-zxvf jdk-8u161-linux-x64.tar.gz

Create a java directory

Sudo mkdir / java

Move files to / java

Sudo mv jdk1.8.0_161 / java

Configure environment variables

Sudo vim / etc/environment

Add the following configuration at the end (the path after JAVA_HOME is the file location of jdk)

PATH= "/ usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:$JAVA_HOME/bin" export CLASSPATH=.:$JAVA_HOME/lib:$JAVA_HOME/jre/libexport JAVA_HOME=/java/jdk1.8.0_161

Save and close after the modification is complete, and enter the following command to make the environment variable take effect immediately

Source / etc/environment

Check whether the installation is successful

> java-versionjava version "1.8.0mm 161" Java (TM) SE Runtime Environment (build 1.8.0_161-b12) Java HotSpot (TM) 64-Bit Server VM (build 25.161-b12, mixed mode) configure the environment variable sudo gedit / etc/profile after restart

Add the following at the end of the file:

# set Java environmentexport JAVA_HOME=/dengyang/jdk1.8.0_161export JRE_HOME=$JAVA_HOME/jreexport CLASSPATH=.:$JAVA_HOME/lib:$JRE_HOME/lib:$CLASSPATHexport PATH=$JAVA_HOME/bin:$JRE_HOME/bin:$PATH

Make the environment variable effective

Source / etc/profile2. Install mycat

Download address: http://dl.mycat.io/1.6-RELEASE/

Decompression

Tar-zxvf Mycat-server-xxxxx.linux.tar.gz

Move to the / usr/local/ directory

Sudo mv mycat / usr/local

Create a user

Useradd mycat

Modify permissions

Chown-R mycat mycat / usr/local/mycat View Catalog

| |-bin-execution file directory |

| |-conf-configuration file directory |

| |-doc-document directory |

| |-lib-some jar files that mycat depends on are mainly stored in the directory |

|-logs-log directory. The log is configured in conf/log4j.xml

Welcome to my blog.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.