Mycat Learning Experience

Recently the boss asked us to learn mycat, and apply to the actual project. Now simply share your own learning experience, but also just accumulate it.

What is Mycat?

As I understand it: Mycat is a technique that can be used to increase the speed of the program and to expand it easily after mycat.

The use of Mycat?

In fact, the transition from a traditional MySQL connection to the Mycat connection is simple, just change the configuration file in the database connection, the other does not have to change.

The operation of the Mycat.

We still use the original INSERT, delete, UPDATE, select statement operation Mycat Virtual Library, Mycat will automatically assign and query the logical Library of child nodes.

The virtual library refers to the existence of libraries on mycat.

The logical library refers to the actual stored MySQL library.

It is worth noting that Mycat has no self-increasing primary key, so we have to define the algorithm of the primary key to insert a unique record.

Mycat Learning Experience