mysql proxy / redirect

I've got a number of servers running http and mysql which are starting to get a little overloaded so I want to move the sql off to a higher spec machine.

Problem is that users are all using localhost as the db connection and I don't want to have to get them all changed.

Does anyone know of a way of redirecting mysql localhost connections off to another server, either using a mysql proxy or some sort of redirection?

I've looked at things like balance and pen but not sure if they'll work as they're TCP based redirects rather than TCP/UDP.

Any thoughts?

 

 

 

 

Top