We’ve seen in previous articles what Transparent Read/Write Splitting is with MySQL 8.2 and how to use it with MySQL Connector/Python.
I love this new feature, but I was wondering if it was really worth it.
Will the application benefit from offloading reads to another node, and won’t using the MySQL Router and parsing the request slow down connections?
These are the kinds of questions I’d like to cover and answer in this article.
The environment
To perform the test, I use the following environment:
- Linux Kernel 5.15.0 – aarch64
- MySQL Community Server 8.2.0
- MySQL Router 8.2.0
- sysbench 1.1.0 using LuaJIT 2.1.0-beta3 …