We have a Rails application sitting on top of MySQL. We have MySQL Master Slave replication running. The Master server running MySQL is called DB01 and the Slave server running MySQL is called APP02. I''m trying to figure out the best way to fail over to the Slave DB running on APP02 in the event that MySQL becomes unavailable on DB01. Does anyone have any ideas on the best way to do this? I was thinking of setting up a crontab job to perform a simple MySQL query every 30 seconds, and if it returns an error or timeout, it would restart the mongrel cluster using the APP02 database connection. Any advice is much appreciated. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---