MySQL Forums
Forum List  »  NDB clusters

Re: Durability of transactions in Cluster
Posted by: Sandeep Jangra
Date: November 20, 2015 03:54PM

Thanks for the response.

In InnoDB all completed transactions are written to bin log files before they are committed to the client. So at any point in time all committed transactions are either in the InnoDB tables or in bin log files (which is disk).

But in the case of cluster, there can be a time slice when the committed transactions are in the RAM of nodes. I know the time window for this is relatively small. Worst case if all the nodes in this HA group go down, I can see some probability of losing data. If MySQL cluster was writing to bin logs (like InnoDB) before every commit, I would feel less chances of data loss. I guess cluster is by-design kept to keep data in memory for performance reasons.

Options: ReplyQuote

Written By
November 06, 2015 12:52AM
Re: Durability of transactions in Cluster
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.