All threads / How can i switch to slave database in case of master fail?
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?

Join the discussion

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

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

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

    logo Created with Sketch.

    Screencast tutorials to help you learn Ruby on Rails, Javascript, Hotwire, Turbo, Stimulus.js, PostgreSQL, MySQL, Ubuntu, and more. Icons by Icons8

    © 2023 GoRails, LLC. All rights reserved.