Please state the source of the article. Welcome to add Echo wechat (wechat id: T2421499075) for exchange and learning. Invincible, according to not claim to always win, defeat not decadent, according to the ability to forge ahead. That’s how powerful it really is!!

If I have a 32 core server, I can do 100 million data sharding. Do I have a 32 core server? No, so I can’t implement 100 million data sharding so far –Mycat’s Plan

Summary of Mycat

Mycat is not a server that stores data, but rather a data engine that connects all kinds of data. For developers, Mycat is a library and table tool. However, the performance of this tool is relatively high for sub-database sub-table, and it can not only be used as sub-database sub-table, but also can do read and write separation, as well as disaster backup.

Is Mycat complex?

Every framework, or technical solution, that is quickly adopted by the masses has one thing in common. It is relatively convenient to implement, relatively low cost, and the principle is not particularly complicated. Mycat as a distributed database structure solution, one of its implementation principle is relatively simple, one of the most important operation is “interception”. But it also has a very complex place, that is, its implementation code, if it can ensure that the implementation code is also very simple, it is estimated that it can not guarantee the unique position of the market, it is easy to be replaced.

Why is Mycat called database middleware

Middleware is called from one of its main functions, that is, shard library. All the support and operations for shard and shard libraries, whether routing, distribution, etc., do not bring the storage engine function to the real database, but only ensure that the data of multiple libraries, shard tables are effectively separated and retrieved. The position in the figure is to highlight one of Mycat’s roles, its place in the middle of our entire system architecture.

Differences between Mycat and other middleware

This picture comes from “Distributed database architecture and Enterprise Practice”. If there is any infringement, please contact me t2421499075, this is wechat

The advantage of Mycat

Mycat’s biggest advantage is that it is compatible with most of the database, and can effectively support read and write separation, has 10 billion levels of data second performance.

How does Mycat fit into our daily development?

  • Mycat is a distributed database architecture middleware, so we can use it to replace our existing adapters for multiple data sources or JDBC code. Easily integrate multiple data sources
  • Compatible with multiple libraries and multiple sources. In our development, if we use multiple servers to provide data source services, or multiple database types to serve data, Mycat is a good middleware choice, because it can be effectively compatible with multiple data source platforms
  • Big data distributed architecture solution. For high availability and fast interaction, Mycat is a good choice.
  • Read/write separation. After we clustered the data sources, Mycat was able to effectively separate reads and writes. Be a blogger with boundaries