CODEWITHSUNDEEP
mysqllinuxmysql-proxy
stan06
stan06

Reputation: 11

Redirect all the mysql requests to other DB server

I have a staging server on AWS where my web application is running.the application uses Dedicated Database server(mysql/linux) from other provider. i would like to spin a new server on a AWS that should act like a proxy server to connect with my Dedicated Database server. please advise me how can i achieve.

Upvotes: 0

Views: 695

Answers (2)

Bernd Buffen
Bernd Buffen

Reputation: 15057

Take a look at MaxScale from MariaDB. it a DB proxy. the can do all this and more..

https://mariadb.com/products/mariadb-maxscale

Upvotes: 0

Jeff W.
Jeff W.

Reputation: 101

You can proxy the traffic with HAproxy, you can have one DB in active mode and one in passive mode, when ready to cut over you take the active one offline and ha will start sending requests to the other DB server.

Additionally, HAproxy will allow you to send traffic to certain DB servers depending on a variety of criteria, like the source IP. So some web apps send to one DB and others send to another.

HA proxy is very lightweight, we use it and run hundreds of thousands of requests a day without any performance issues.

Upvotes: 0

Related Questions