Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to know if a catstrophic failure occurs (like a power outage), and all nodes in MySQL Cluster are shutdown in cluster then data will be lost even though a backup was taken? Or it possible that data can still be retrieved?

If yes, then please tell me how it can be retrieved.

share|improve this question

MySQL Cluster checkpoints and logs in-memory data to disk (assuming you leave the default of checkpointing on). As these are streaming writes, fast HDDs are very efficient to handle this activity. Also, all updates are synchronously replicated between data nodes in a node group, and these can be split across data centers using multi-site clustering:

So there are multiple mechanisms available to protect data

HTH! Mat

share|improve this answer

I would advise that you keep at least one node or even part of the cluster into a different datacenter thus allowing for a part of your data to be "alive" as such somewhere else.

The backup is as good as the time taken (assuming restore procedures are in place and tested). During the time that has lapsed since the backup your data are not safe unless you are able to have them live somewhere else.

In any case if such a catastrophic situation occurs, you assume that you keep the backups "elsewhere" in order to restore them ?

If that is the case, then keep a spare node there as well.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.