Durability of transactions in Cluster
Hello,
It seems like when a transaction is committed on cluster it is not written to the disk until one of the checkpoints (LCP or GCP) kicks in. So theoretically there is a very window of time where if all nodes within the node group go down, we can have a potential data loss.
Is there a way to force every transaction to get written to bin logs (not buffers) on commit so that we can avoid the data loss scenario described above?
If the answer to above is YES, then are there any benchmark performance numbers available with those settings?
Please let me know.
Thanks
Subject
Views
Written By
Posted
Durability of transactions in Cluster
1741
October 23, 2015 11:16AM
740
November 06, 2015 12:52AM
765
November 20, 2015 03:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.