Pro MySQL NDB Cluster

© Jesper Wisborg Krogh and Mikiya Okuno 2017

Jesper Wisborg Krogh and Mikiya OkunoPro MySQL NDB Clusterhttps://doi.org/10.1007/978-1-4842-2982-8_8

8. Backups and Restores

Jesper Wisborg Krogh¹  and Mikiya Okuno²

(1)

Sydney, New South Wales, Australia

(2)

Tochigi, Japan

 

For any database product, backups and restores are two very important parts of ensuring the data can be recovered in case of human errors, hardware failures, natural disasters, and the like. MySQL NDB Cluster offers two types of backups: native backups and logical backups. Both types have their uses, and in most cases, both should be used. This chapter goes through the two options, discusses when to use them, and covers how to restore the backups. First, the chapter discusses what a backup ...