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

Mycat is a relatively simple middleware product, which can help mysql to divide the library and unify it in a logical library.

Hardware environment:

System: centos 7.6

Database version: 5.7.19

Mycat:1.6..6.1

Download mycat and java on github

One: install java

[root@node3] # rpm-ivh jre-*-linux-x64.rpm

Preparing... # [100%]

1:jre1.8.0_51 # # [100%]

Unpacking JAR files...

Rt.jar...

Jsse.jar...

Charsets.jar...

Localedata.jar...

Jfxrt.jar...

Plugin.jar...

Javaws.jar...

Deploy.jar...

[root@node3] # java-version

The java version must not be less than 1.6

Two: install mycat

[root@node3] # tar-xf Mycat-server-1.6-*-linux.tar.gz

[root@node3] # mv mycat/ / usr/local/

[root@node3] # useradd mycat

[root@node3 local] # chown mycat:root mycat/-R

Set the password for mycat

[root@node3] # passwd mycat

Changing password for user mycat.

New password:

BAD PASSWORD: it is WAY too short

BAD PASSWORD: is too simple

Retype new password:

Passwd: all authentication tokens updated successfully.

Original mycat test configuration

[root@node3 conf] # >.. / logs/wrapper.log

[root@node3 conf] #

[root@node3 conf] # pwd

/ usr/local/mycat/conf

[root@node3 conf] #.. / bin/mycat start

Starting Mycat-server...

Error handling scheme

[root@node3 conf] # cat.. / logs/wrapper.log

Third: parameter configuration of mycat

Configuration files are mainly in schema.xml, server.xml, role.xml, in order of importance.

All the tables in the logical library need to write the table name and related shard information in schema.xml.

Fourth: the use and management of mycat

Mycat has two ports, one is a logical port, which is used to read and write data. After the configuration file defines the table name, you can create the table structure.

One is the management port. After show @ @ help, you can display a set of commands to view the running status of mycat or dynamically reload configuration file information.

Reference article:

Http://www.cnblogs.com/yybrhr/p/9814860.html

Https://blog.51cto.com/zuoyuezong/1702507

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.