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

This article mainly introduces what function mysql router has, which is very detailed and has certain reference value. Friends who are interested must finish reading it!

What is MySQL Router?

MySQL Router is an open source lightweight middleware between the application layer and the DB layer. It can forward the request analysis of the front-end application to the back-end DB server for processing, so as to achieve the load balancing of DB. It can be said that it is a substitute for the previous MySQL Proxy, and we can find its source code in Github. There are several similar tools such as Atlas, Meituan Dianping's DBProxy, MyCat and so on.

MySQL Router architecture

Using this architecture, the front-end application does not need to connect directly to DB Server, but only to MySQL Router, which can easily expand the database cluster. Next, let's take a look at some of its other main functions.

Main function

1. Automatic failover

Using MySQL Router to implement read-write separation, the front-end application layer does not need to connect directly to the underlying DB, but uniformly connects to the MySQL Router. MySQL Router is transparent to the front-end application layer, and we don't need to do any processing in the code layer. The application layer will use a normal MySQL instance of MySQL Router, and the underlying DB Master will automatically be replaced by a Backup node when it is hung up, which is very convenient.

2. DB load balancing

MySQL middleware distributes requests to the underlying database according to certain rules in a way similar to connection pool, so as to achieve read-write separation and high availability of DB.

The above is all the content of this article "what is the function of mysql router?" Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.