On 30.05.2007 23:31, Kevin Kempter wrote:
per considering DRDB as a replication solution in a failed master node
scenario, is there a risk of loosing not only in-flight transactions but alos
un-sync'd buffer-pool dirty pages?
If so, how might I minimize this risk ?
If you have DRBD using protocol C and fsync enabled in PG you don't lose
a single commit. That is true for any ACID conform application.
Be sure to you have your hardware right. Running DRBD on fsync/fua lying
hardware is committing suicide. I can't stress that enough.
--
Regards,
Hannes Dorbath
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
