So how does PostGreSQL compare to MySQL?

Posted Jan 3, 2010 7:36 UTC (Sun) by nicku (subscriber, #777)
In reply to: So how does PostGreSQL compare to MySQL? by rvfh
Parent article: The ongoing MySQL campaign

My main problem with deploying PostgreSQL instead of MySQL is to replace the replication of MySQL. The announcement in the Linux Conference PostgreSQL talk program that 8.5 "will support native replication" brought eager, enthusiastic support from members of the team I am in. In the meantime, members of that team will migrate at least one application from PostgreSQL to MySQL to scale read operations.

to post comments

So how does PostGreSQL compare to MySQL?

Posted Jan 3, 2010 10:42 UTC (Sun) by dlang (guest, #313) [Link]

have you looked at the exitinsg replication options for postgres?

the big change in 8.5 is that there will be a synchronous replication via log shipping built into the core. There are already options (pgpool or slony to name a couple) that will do replication and let you read from all boxes at the same time.

I'm not a MySQL expert, but my understanding of the guarantees that it's replication provides make me think that these existing replication tools let you get equivalent safety to what MySQL replication provides.