Starting points for creating a mysql database proxy
there two or three such software packets available, but usually you use this two split the incoming packages after rules to different servers.
It is in the begining , sowhat difficult to configure, but there a a lot of tutorials
https://proxysql.com/  or https://github.com/mysql/mysql-proxy