News for hackers. Stuff that matters.

A comment on It's the Postgres Age. Parent comment

Re:It's the Postgres Age by dickeytk on Wednesday May 23, 2012 @03:25PM (#4014844)
Postgres has had solid replication since 8.4
[ Parent | on HN ]
Re:It's the Postgres Age by sciurus on Wednesday May 23, 2012 @03:57PM (#4015007)
It was only in Postgres 9.0, released in Septermber 2010, that support for a "hot standby" (e.g. master/slave replication where you can run read-only queries on the slave) was added.

MySQL has supported this since at least version 3.2.3, released in January 2001.

MySQL supports

• Single master to one slave • Single master to multiple slaves • Single master to one slave to one or more slaves • Circular replication (A to B to C and back to A) • Master to master

Postgres supports

• Single master to one slave • Single master to multiple slaves

(lists from http://www.theserverside.com/feature/Comparing-MySQL-and-Pos...)

[ Parent | on HN ]
Re:It's the Postgres Age by mhurron on Wednesday May 23, 2012 @03:37PM (#4014901)
It doesn't do two way, you have to go to 3rd party addons for that.
[ Parent | on HN ]