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

What is MyCat?

MyCat is an open source distributed database system and a server that implements MySQL protocol. Front-end users can regard it as a database agent, which can be accessed by MySQL client tools and command line, while its back-end can communicate with multiple MySQL servers using MySQL native protocol, or with most mainstream database servers using JDBC protocol. Its core function is to divide tables and libraries. Split a large table horizontally into N small tables and store them in a back-end MySQL server or other database.

With the development of the current version, MyCat is no longer a simple MySQL agent, its back-end can support mainstream databases such as MySQL, SQL Server, Oracle, DB2, PostgreSQL and other mainstream databases, as well as MongoDB, a new type of NoSQL storage, and will support more types of storage in the future. In the view of end-users, no matter what kind of storage method, in MyCat, it is a traditional database table, which supports standard SQL statements to operate the data. In this way, for the front-end business system, it can greatly reduce the difficulty of development and improve the speed of development.

Second, why use MyCat?

* for example, the operating system is an abstraction of all kinds of 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 example, when a project needs only one person to complete, it does not need leader, but when it needs dozens of people to complete, there should be a manager to play the role of communication and coordination, and this manager is an abstraction to the project team for his upper level.

Similarly, when our application only needs a database server, we do not need Mycat, but if you need to divide libraries or even tables, when the application has to face many databases, you need to do an abstraction to the database layer to manage these databases, while the top application only needs to face a database layer abstraction or database middleware. This is the core role of Mycat.

So it can be understood that the database is the abstraction of the underlying storage files, while Mycat is the abstraction of the database.

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.