News for hackers. Stuff that matters.
Re:Ask HN: When to use MySQL vs PgSQL? by modoc on Friday April 24, 2009 @10:41AM (#577542)
What are the issues you've seen with Slony-I and/or PGCluster?
Re:Ask HN: When to use MySQL vs PgSQL? by emmett on Friday April 24, 2009 @12:39PM (#577738)
Slony-I is a terrible piece of software; it's incredibly difficult to administer, requires full table locking across the entire data set (EVERY SINGLE TABLE!) to do DDL changes, and occasionally breaks in mysterious ways which can lead to data corruption.

I haven't used PGCluster, but it's synchronous multi-master and thus inherently fails to scale out as well as async systems like Slony-I and Londiste. Probably great in circumstances with only 2-3 db boxes though.

Londiste, on the other hand, is awesome, and with the 3.0 release now has hot backups. Simple to administer, rock solid, and has really important features like live DDLs. Demand Londiste and the SkyTools package! Don't settle for less!

Re:Ask HN: When to use MySQL vs PgSQL? by modoc on Friday April 24, 2009 @01:58PM (#577871)
Cool! Thanks for the info! I love Postgres buy haven't done a lot of replication with it yet. I'll checkout SkyTools. Thanks again.