Re:A love affair with PostgreSQL
by frankwiles on Wednesday January 02, 2013 @08:31AM
(#4996558)
Pretty sure Skype scales PG horizontally pretty darn well. PgPool is probably the least used, least recommended replication method out there. Streaming replication in 9, WAL shipping, and things like Londiste (Skype) are what real large production users use.
Have you ever used mysql cluster in a bigger deployment? I wonder if it got usable over the last ~4 years when I tried it. At the time it was buggy, continuously corrupting data and had no real support apart from a very niche IRC channel. I've still got some very basic bugs open against it without any resolution at all.
Instagram had to roll their own and Postgres XC, PGPool both have always seemed pretty sketchy. No official support, no notable customers, shocking complexity and everything just seems all over the place with documentation from say 2009 referencing PostgreSQL 8 e.g. PgPool beginner guide. They may be great solutions but do they really look like something that inspires confidence ?
These guys seem to have the right idea: http://www.cloudpostgres.com
It would just be nice to have something as simple and polished built into PostgreSQL.