Starting points for creating a mysql database proxy

All we need is an easy explanation of the problem, so here it is.

I’m not actually entirely sure if this is possible, but I’d like to build piece of software that behaves a lot like a proxy between a client and a mysql server.

Essentially, I want this software to expose a connection string the same way a normal mysql database would, and listen to the same port. When it receives traffic (mysql queries), it would apply some modifications to them before handing them off to the actual mysql database.

Is this possible? If so, where would I even start in building this? Finally, are there any recommendations on how to do this properly?

I’m also open to exploring off-the-shelf options if something like this already exists.

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

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

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply