Nowadays, with the development of the Internet, the magnitude of data is also increasing exponentially, from GB to TB to PB. The operation of data is also increasingly difficult, the traditional relational database has been unable to meet the needs of rapid query and insert data, this time the emergence of NoSQL to temporarily solve this crisis.

It gains performance by reducing data security, reducing support for transactions, and reducing support for complex queries. However, there are situations in which some of the trade-offs of NoSQL are not suitable for use scenarios, such as those in which transaction and security metrics are absolutely required. NoSQL is definitely not enough at this point, so you still need to use a relational database. How to use relational database to solve the problem of mass storage? At this point, we need to do database cluster, in order to improve the query performance of the data of a database scattered to different databases for storage, to solve this problem – MyCat.

Mycat is an open source distributed database system. Its core function is to divide tables and libraries. That is, a large table is horizontally divided into several small tables and stored in back-end MySQL or other databases. Mycat is named because it is easy to remember, and also because I hope to join Apache in the future. Tomcat, Apache’s open source product, is also a cat.

As a result, your xiaobian (Lei Feng) in this week to focus on the collection and collation of the open-source database middleware MyCat use and principle of source code + notes + project actual combat information. This document will be comprehensive from MyCat foundation, advanced, cluster, monitoring, architecture analysis to explain MyCat, and through a case to demonstrate in the actual development, how to achieve MyCat database sharding operation. Through the study of this material, we can fully master the use and principle of MyCat.

The above is the content of the information contained, the following small series will show directory and detailed content screenshots, there is a need for a complete version of the source code + note friends, only forward + pay attention to the end of the public number can be free!!