Database loadbalancing outside rails application?

Question

I want to make a master/slave setup on my postgresql servers. My problem is how I can get queries from my rails app balanced to the databases? I can't use a gem like Octopus, because it collides with my use of the Apartment gem (both modifies ActiveRecord) inspired by this rails cast. Does anyone know of a way to load balance outside the rails app?

Jef · Accepted Answer · 2012-11-08 16:59:16Z

2

You may consider using pgPool that allows distribution of SELECT request across a pool of servers.

answered Nov 8, 2012 at 16:59

Jef

5,48428 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dbenhur · Accepted Answer · 2012-11-08 19:21:39Z

1

PgBouncer efficiently supports both connection pooling and simple load balancing.

answered Nov 8, 2012 at 19:21

dbenhur

20.5k4 gold badges52 silver badges47 bronze badges

Collectives™ on Stack Overflow

Database loadbalancing outside rails application?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related