3 ms·

PostgreSQL horizontally scales in the same fashion as MySQL. What are you talking about? http://instagram-engineering.tumblr.com/post/10853187575/sharding-ids-

PostgreSQL horizontally scales in the same fashion as MySQL. What are you talking about? http://instagram-engineering.tumblr.com/post/10853187575/sharding-ids-at-instagram http://instagram-engineering.tumblr.com/post/10853187575/sha... http://postgres-xc.sourceforge.net/ http://postgres-xc.sourceforge.net/ http://www.pgpool.net/mediawiki/index.php/Main_Page http://www.pgpool.net/mediawiki/index.php/Main_Page (you can use this to transparently shard)

taligent 14y ago
No it's not like MySQL which has MySQL Cluster a supported, well documented, OOTB, easy to use solution with lots of enterprise customers. Similarly Percona has a very, very impressive product with great support. 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 http://www.cloudpostgres.com It would just be nice to have something as simple and polished built into PostgreSQL.
- frankwiles 14y ago
  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.
- viraptor 14y ago
  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.

taligent 14y ago

No it's not like MySQL which has MySQL Cluster a supported, well documented, OOTB, easy to use solution with lots of enterprise customers. Similarly Percona has a very, very impressive product with great support. 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 http://www.cloudpostgres.com It would just be nice to have something as simple and polished built into PostgreSQL.

frankwiles 14y ago
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.
viraptor 14y ago
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.