MySQL Router

Part of InnoDB cluster, MySQL Router can build a bridge between your application and back-end MySQL servers, providing seamless routing of database traffic. Thus, it can work as an agent that ensures high data availability and scalability.

MySQL Router is a console application, providing options for bootstrapping and setting the configuration to work with an InnoDB cluster. All the available commands, examples, and instructions are displayed if you run the "help" command with MySQL Router.

MySQL Router is the solution to the classic failover issue. In case the MySQL master is unavailable, incoming connections are routed, while also taking into account load balancing. The connection requests are distributed across several servers to ensure high performance and reduced response time, usually based on the round-robin routing algorithm.

One of the most important advantages of MySQL Router is its support for plugins, which allows database developers to extend its functionality to meet their particular requests and needs. The result is a versatile database routing solution that can be used in various custom scenarios.

There are a set of plugins that are delivered along with MySQL Router. Among these, it is worth mentioning the connection routing plugin, whose role is to send the MySQL packets it receives to the backend MySQL server as quickly as possible, without any verification.