4 ms·
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
by sciurus 14y ago
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-Postgres-90-Replication http://www.theserverside.com/feature/Comparing-MySQL-and-Pos...)