Какая прекрасная штука вот теперь появилась и в MySQL
https://blogs.oracle.com/mysql/post/mysql-82-transparent-readwrite-splitting
https://dev.mysql.com/doc/mysql-router/8.2/en/router-read-write-splitting.html
https://blogs.oracle.com/mysql/post/mysql-82-transparent-readwrite-splitting
https://dev.mysql.com/doc/mysql-router/8.2/en/router-read-write-splitting.html