Backup a cluster - beginner questions

MySQL & MariaDB Percona XtraDB Cluster 8.x
,
1

Hey everyone,

so we have a production-ready xtraDB Cluster setup and want now to plan how to create and restore backups of it.

Actually the setup is a 3 node cluster loadbalanced by a proxysql server.

As i can only find a link to the xtraBackup Docs when searching within the cluster docs, we are just want to ask:

  • What is the preferred way to setup backup for the cluster? Should it be a own node or should xtrabackup run more likely on the cluster nodes?

If you would be so kind as to give us a few tips, that would be great.

Best regards

1 Like
2

Hello @Zody,
Percona Xtrabackup (PXB) is the preferred way to handle backups. You can use PXB on any node in the cluster to perform backups. Ideally you would use PXB on one of the reader nodes, not the current writer node.

1 Like