PostgreSQL 9.1 Database Replication Between Two Production Environments with Load Balancer
- by littleK
I'm investigating different solutions for database replication between two PostgreSQL 9.1 databases. The setup will include two production servers on the cloud (Amazon EC2 X-Large Instances), with an elastic load balancer. What is the typical database implementation for for this type of setup? A master-master replication (with Bucardo or rubyrep)? Or perhaps use only one shared database between the two environments, with a shared disk failover? I've been getting some ideas from http://www.postgresql.org/docs/9.0/static/different-replication-solutions.html.
Since I don't have a lot of experience in database replication, I figured I would ask the experts. What would you recommend for the described setup?