Re: hot standby mysql-server

[simon elliston ball]

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