PostgreSQL 8.4 released

Posted Jul 2, 2009 4:00 UTC (Thu) by dlang (guest, #313)
In reply to: PostgreSQL 8.4 released by Cyberax
Parent article: PostgreSQL 8.4 released

my understanding of mySQL is that their replication is not synchronous

for postgres, I think the option you would want is plproxy, it makes changes to all boxes in the cluster at the same time and splits queries between machines.

I haven't used it so check that it doesn't have any limitations that will kill you

PostgreSQL 8.4 released

Posted Jul 2, 2009 5:44 UTC (Thu) by fdr (guest, #57064) [Link]

You would be correct; MySQL's replication is asynchronous by in large. Much like Postgres there are some less-well traveled ways to acquire syncrep.

PostgreSQL 8.4 released

Posted Jul 3, 2009 20:27 UTC (Fri) by hingo (guest, #14792) [Link]

That is correct when talking about MySQL Replication. Google has developed "semi-synchronous" replication which should be in MySQL 5.4. Semi-synchronous is to say that changes are not applied synchronously, but data is copied to both masters so it can be considered safe/redundant.

MySQL Cluster on the other hand does provide synchronous replication, not to mention transparent sharding (scale-out) too.

Also for MySQL there are 3rd party solutions to do synchronous replication. I don't have enough experience to comment on those, I've seen people like them and dislike them all.