How can you proxy sql queries?

Question

MySQL

We need some kind of tool that could proxy sql requests from clients to the mysql server, and if an error came from the server, then it sent the same request to another sql server.
Also interesting, but not critical, is the issue of supporting ssl encrypted connections by this proxy.
Now I use haproxy in a similar role, it has a mechanism that polls the servers and excludes from the list those that did not answer correctly. But instead of checking the health of the server every second, I just want to process the error code and if it arose, do not refuse the client, but simply try to execute the same request on another server.

Answer 1

nginx is able to proxy tcp
in the paid version has ballance and re-request to another back