Differences between Mycat and MySQL -- the core function of Mycat, mycatmysql

Differences between Mycat and MySQL -- the core function of Mycat, mycatmysql

A friend was asked during the interview: What is the difference between Mycat and MySQL. We can regard the upper layer as an abstraction of the lower layer. For example, the operating system is an abstraction of various computer hardware. So when do we need abstraction? If there is only one kind of hardware, do we need to develop an operating system? For another example, a project only needs to be completed by one person without a leader. However, when dozens of people are required to complete the project, a manager should play a role in communication and coordination, this manager is an abstraction of the project team for his upper layer. Similarly, when our applications only need one database server, we do not need Mycat. If you need to split databases or even tables, when the applications need to face many databases, at this time, we need to make an abstraction for the database layer to manage these databases, and the top application only needs to face the abstraction or database middleware at the database layer, this is the core function of Mycat. It can be understood as follows: the database is an abstraction of the underlying storage files, while Mycat is an abstraction of the database.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.