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
1 comment
In the current version (cmon 1.2.12) xtrabackups can be stored on the ClusterControl server (transferred from the backup host via netcat).
Please sign in to leave a comment.