Ruby On Rails Master-Slave Postrgres Databases
master-slave, postgresql, replication, ruby-on-rails, slony
Solution
If you're using Ruby, it would be sin not to try out rubyrep.
Problem
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!