Chapter 2. MySQL Cluster Backup and Recovery
In this chapter, we will cover:
- Importing SQL files to a MySQL server and converting them to MySQL Cluster
- Taking an online backup of a MySQL Cluster
- Restoring the cluster from a MySQL Cluster online backup
- Restricting write access to a MySQL Cluster with single-user mode
- Taking an offline backup with MySQL Cluster
Introduction
When designing a MySQL Cluster, it is unlikely that backups will be at the forefront of your mind. However, it is important that they are considered at an early stage. In this chapter, we will discuss the options available for backing up a MySQL Cluster and the considerations to be made at the cluster-design stage.
There are two main ways to back up a MySQL Cluster:
- First is the
mysqldump ...
Get High Availability MySQL Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
