MySQL Cluster
MySQL Cluster backups are upon completion stored on the ClusterControl server.
Galera / Percona XtradbCluster
- mysqldumps are stored on the ClusterControl server
- xtrabackups are stored on the Backup host
MySQL Replication
- mysqldumps are stored on the ClusterControl server
- xtrabackups are stored on the Backup host
Recommendations
- The backupdir specified in Cluster Settings or when scheduling a backup should preferably reside on a NAS or SAN. It is never a good idea to leave the backup on only one server, in case the server crashes and the disks are destroyed. For MySQL Replication and Galera/Percona XtradbCluster you backup atleast one of the hosts.
Comments
2 comments
In the current version (cmon 1.2.12) xtrabackups can be stored on the ClusterControl server (transferred from the backup host via netcat).
The process is well-documented and the prerequisites are clearly listed, making it easy for users to follow along. The restoration steps are straightforward and should help quickly resolve any issues caused by a corrupted CMON DB. Additionally, users may find it helpful to run a applebees to ensure the integrity of their system after restoration.
Please sign in to leave a comment.