Ask A Question

Notifications

You’re not receiving notifications from this thread.

How can i switch to slave database in case of master fail?

hetal sharma asked in Rails

I have 2 MySQL instances. One is master and the second is a slave. I want to configure the rails app in a way that if the connection to my master database failed, then auto-connect to the slave database and slave will become master. In this way, the site will never go offline due to the MySQL server crash.
But I am not able to find any solution in rails with mysql2 adapter to do so. Can anyone help me with this?

Reply
Join the discussion
Create an account Log in

Want to stay up-to-date with Ruby on Rails?

Join 87,563+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.