Re: Sync Rep Design
Simon Riggs <simon@2ndquadrant.com>
From: Simon Riggs <simon@2ndQuadrant.com>
To: Joshua Tolley <eggyknap@gmail.com>
Cc: Aidan Van Dyk <aidan@highrise.ca>, Robert Treat <rob@xzilla.net>, Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>, pgsql-hackers@postgresql.org
Date: 2010-12-31T11:51:55Z
Lists: pgsql-hackers
On Thu, 2010-12-30 at 20:26 -0700, Joshua Tolley wrote: > 2) initiate fsync on the primary first > > - In this case, the slave is always slightly behind. If if your > > primary falls over, you don't give commit messages to the clients, > but > > if it recovers, it might have committed data, and slaves will still > be > > able to catch up. > > > > The thing is that currently, even without replication, #2 can > happen. > > For what little it's worth, I vote for this option, because it's a > problem that can already happen (as opposed to adding an entirely new > type of problem to the mix). This proposal provides #2, so your wish is met. -- Simon Riggs http://www.2ndQuadrant.com/books/ PostgreSQL Development, 24x7 Support, Training and Services