# MySQL Backup with Percona 8.x Cluster

**URL:** <https://forums.percona.com/t/mysql-backup-with-percona-8-x-cluster/25529>\
**Category:** Percona XtraDB Cluster 8.x\
**Created:** [September 28, 2023, 10:13pm UTC](https://forums.percona.com/t/mysql-backup-with-percona-8-x-cluster/25529 "2023-09-28T22:13:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jasonfe33](https://avatars.discourse-cdn.com/v4/letter/j/838e76/32.png) [@jasonfe33](https://forums.percona.com/u/jasonfe33)\
**Post date:** [September 28, 2023, 10:13pm UTC](https://forums.percona.com/t/mysql-backup-with-percona-8-x-cluster/25529/1 "2023-09-28T22:13:22Z")

</div>

Hello,

We have a few Percona Clusters setup 3 server node clusters with Percona 8.x Cluster and MySQL 8. If I wanted to use Commvault or some other backup utility, could I back 1 of the servers up in the cluster using that MySQL backup method? Or is there a special way I would have to go about it? Do I need to backup all 3? In addition to this, what is the best way to tell if all 3 nodes have the same data on them? What file is that Galera file or?

Thank you!

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [September 29, 2023, 4:52pm UTC](https://forums.percona.com/t/mysql-backup-with-percona-8-x-cluster/25529/2 "2023-09-29T16:52:22Z")

</div>

Hello @jasonfe33,  
You only need to backup 1 MySQL server in a 3-node PXC as all 3 nodes _should_ have the same data.

> [@jasonfe33](#):
>
> what is the best way to tell if all 3 nodes have the same data

This is difficult as there is no built-in mechanism for this. Data integrity is really only checked between nodes when a write transaction takes place, and the integrity is only checked for the rows within the trx.

There is nothing in the protocol that checks every row on some sort of routine basis. Instead, check out [pt-table-checksum](https://docs.percona.com/percona-toolkit/pt-table-checksum.html#percona-xtradb-cluster) which has support for PXC to validate all nodes have the same data.

---

<div class="post-metadata">

**Author:** ![jasonfe33](https://avatars.discourse-cdn.com/v4/letter/j/838e76/32.png) [@jasonfe33](https://forums.percona.com/u/jasonfe33)\
**Post date:** [October 3, 2023, 4:50pm UTC](https://forums.percona.com/t/mysql-backup-with-percona-8-x-cluster/25529/3 "2023-10-03T16:50:33Z")

</div>

Hey Matt thank you for this! Was just looking for some insight and you have provided that. Thank you!