How To Restore MySQL Cluster From A Data Node Filesystem Snapshot?
(Doc ID 2411116.1)
Last updated on AUGUST 17, 2021
Applies to:
MySQL Cluster - Version 7.4 and laterInformation in this document applies to any platform.
Goal
If it is required to recover data from a MySQL Cluster database and the only available backup for it is the snapshot for a data node file system, the following steps may help in recovering data. A data node, usually belonging to a node group with NoOfReplicas=2, stores both primary copies for dataset fragments and secondary copies as well. Because of that, the full dataset is available even in the case only one data node snapshot is available.
Following steps will take into account a MySQL Cluster deployment with only one node group configured. Same principles are valid also in the case of having multiple node groups; in such a case, a file system snapshot per data node in every node group must be available.
The only solution to have a fully consistent restore procedure is performing a Point In Time Recovery it from a native backup.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |