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
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...)