MySQL 8.2 Introduces Transparent Read/Write Splitting

Oracle has recently announced the general availability of MySQL 8.2, which includes many new enhancements and bug fixes. Among that most notable one is the support for Read/Write Splitting from MySQL Router.

MySQL Router is part of InnoDB Cluster, and is lightweight middleware that provides transparent routing between your application and back-end MySQL Servers. It can be used for a wide variety of use cases, such as providing high availability and scalability by effectively routing database traffic to appropriate back-end MySQL Servers.

With MySQL 8.2, MySQL Router is now able to identify reads and writes and route them to Primary Instances in the case of an InnoDB Cluster, or to an asynchronous replication source for the writes and to secondary instances or replicas for the reads.

source:https://blogs.oracle.com/mysql/post/mysql-82-transparent-readwrite-splitting

By using MySQL client, Application connects to the MySQL server and executes SQL queries. The queries are now classified whether it is read/write or just read only, based on that the queries will be routed to the respective server. This happens seamlessly and there is no change required from application.

This is a valuable feature for optimizing database performance and scalability without having to make any changes in the application.