MySQL Forums
Forum List  »  Router & Proxy

Re: hot standby mysql-server
Posted by: simon elliston ball
Date: September 10, 2007 04:25AM


You would probably be a lot better off with standard mysql replication. In order to do the rsync you would have to maintain the master database in a static state while you do your rsync or you risk corrupt tables.

That aside, the mysql-proxy issue is still an interesting one even with 'regular' replication, ie how to remove backends (read slave servers) from the connection pool when they are down. Take a looks at trunk/lib/proxy/balance.lua, which picks a backend for the rw-splitting script. This will automatically re-route queries to backends which are up. If you use similar chunks of lua, all you need to do to make sure queries are not sent to the server which is currently down, is to take that server down. Isn't mysql-proxy cool?

Hope that's a bit clearer.


Options: ReplyQuote

Written By
September 08, 2007 02:47AM
September 08, 2007 05:15PM
September 09, 2007 12:59AM
September 09, 2007 02:11AM
Re: hot standby mysql-server
September 10, 2007 04:25AM
September 10, 2007 05:41AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.