MySQL Forums
Forum List  »  Router & Proxy

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

Lars,

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.

Simon

Options: ReplyQuote


Subject
Views
Written By
Posted
10148
September 08, 2007 02:47AM
4449
September 08, 2007 05:15PM
5047
September 09, 2007 12:59AM
3745
September 09, 2007 02:11AM
Re: hot standby mysql-server
4054
September 10, 2007 04:25AM
4680
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.