| |||||||||||||
Synchronous replication! Yay!Synchronous replication! Yay!Posted May 6, 2011 7:30 UTC (Fri) by intgr (subscriber, #39733)In reply to: Synchronous replication! Yay! by Cyberax Parent article: New features in PostgreSQL 9.1
Yes, by the end of COMMIT, the WAL data from the transaction is replicated to the slaves, but changes from the WAL haven't been applied to slave databases yet -- so not visible to queries. Applying/recovering the WAL on slaves still takes place asynchronously.
In the event of a failover/promotion, PostgreSQL applies all outstanding WAL changes, so no data is lost.
(Log in to post comments)
|
|||||||||||||