Re:PostgreSQL 9.0 - Hot Standby, Streaming Replication
by rosser on Tuesday February 02, 2010 @12:50AM
(#1094404)
The last place I worked used F5s for load balancing and Bucardo for replication. The F5s worked well enough, and I've become a huge fan of Bucardo. It has capabilities that I think blow Slony away. (Custom code, and pre-warmed slaves are two of the biggest differentiators.)
The new job is doing something that could best be described as very primitive sharding (completely unnecessary, given the demonstrated loads compared to the levels of concurrency PostgreSQL can support with minimal tuning), without replication. I'm eliminating the former, and will eventually be adding some HA capabilities, and probably also bringing Bucardo in.
I don't think SR is going to obsolete a connection pool any time soon -- you still need to direct traffic appropriately between master and slave(s). I've never used it, but I've consistently heard good things about pgBoucner as a connection pooler.
Re:PostgreSQL 9.0 - Hot Standby, Streaming Replication
by emmett on Tuesday February 02, 2010 @11:32AM
(#1095253)
We use londiste (from SkyTools). It's excellent. From what I've read, londiste already plans to start offering streaming replication (vs. trigger-based replication) for the transport mechanism.
Re:PostgreSQL 9.0 - Hot Standby, Streaming Replication
by kingkilr on Tuesday February 02, 2010 @12:29AM
(#1094375)
I'm not an expert, but PgPool also servers as a local connection pooler, so for those purposes it won't be obsoleted.
Re:PostgreSQL 9.0 - Hot Standby, Streaming Replication
by neilc on Tuesday February 02, 2010 @12:45AM
(#1094400)
I'd personally recommend pgbouncer as a connection pooler rather than pgpool.
https://developer.skype.com/SkypeGarage/DbProjects/PgBouncer
Re:PostgreSQL 9.0 - Hot Standby, Streaming Replication
by russss on Tuesday February 02, 2010 @06:45AM
(#1094719)
I second that, I did a comparison a few years ago and pgbouncer blew pgpool away:
http://www.last.fm/user/Russ/journal/2008/02/21/zd_postgres_...
Re:PostgreSQL 9.0 - Hot Standby, Streaming Replication
by yesimahuman on Thursday February 04, 2010 @09:28PM
(#1102460)
Thanks guys.
I'm running pgpool-ii but just tonight noticed some pretty serious discrepancies between the two backend postgresql instances so I am getting rid of pgpool for the time being.
Will this change make pgpool-ii obsolete?