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

hetal sharma asked May 7, 2020 6:45am in Rails

hetal sharma May 7, 2020 6:45am

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

Create an account Log in

Courses

Rails for Beginners

Advanced Ruby: Behind the Magic

Payments with Rails Master Class

Refactoring Rails

Apps

Hatchbox.io

Jumpstart Rails SaaS Template

Other

Remote Ruby Podcast

Rails Hackathon

Beginner Bounties

Ruby on Rails Job Board

Notifications

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

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