CODEWITHSUNDEEP
ruby-on-railspostgresqlreplicationmaster-slaveslony
Chelsea
Chelsea

Reputation: 6801

Ruby On Rails Master-Slave Postrgres Databases

I am currently setting up a master-slave app using Ruby on Rails that needs to have a Master-Slave backend. I'm currently looking at using Slony for the replication component, and Masochism for handling the read/write connections to the different DBs.

This is my first time setting up master-slave DBs with Ruby on Rails, and these are the two options I've seen come up the most. Have you worked with a better plugin for this situation in the past? The limit to the number of slaves in Slony isn't an issue for the situation, I should realistically only need one or two.

Thanks!

Upvotes: 4

Views: 2333

Answers (3)

user80168
user80168

Reputation:

If you're using Ruby, it would be sin not to try out rubyrep.

Upvotes: 3

Scott
Scott

Reputation: 7264

We used Slony and Masochism, but switched to Londiste and DataFabric and haven't looked back.

Upvotes: 0

Elad Meidar
Elad Meidar

Reputation: 186

i personally use MySQL so my basic implementation might not work, but i used Masochism too and moved to DataFabric, which supports more slaves and sharding as well as replication mechanisms.

Upvotes: 0

Related Questions