# How to sync XtraDB cluster with other database

**URL:** <https://forums.percona.com/t/how-to-sync-xtradb-cluster-with-other-database/19667>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [January 17, 2023, 8:17pm UTC](https://forums.percona.com/t/how-to-sync-xtradb-cluster-with-other-database/19667 "2023-01-17T20:17:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sa1eh](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sa1eh/32/9037_2.png) [@sa1eh](https://forums.percona.com/u/sa1eh)\
**Post date:** [January 17, 2023, 8:17pm UTC](https://forums.percona.com/t/how-to-sync-xtradb-cluster-with-other-database/19667/1 "2023-01-17T20:17:25Z")

</div>

Hi

I’m looking for a way to create one instance of MYSQL 5.7 and sync the data from my production PXC in this way I can give developers access to this new instance and make  
sure data will be returned to production status every day.

---

<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:** [January 17, 2023, 11:11pm UTC](https://forums.percona.com/t/how-to-sync-xtradb-cluster-with-other-database/19667/2 "2023-01-17T23:11:32Z")

</div>

Hello @sa1eh,  
Create your standalone 5.7 and configure it as a replica from one of the PXC nodes. It’s that simple. You’ll need to first restore a backup from one of the nodes to the standalone in order to get a starting seed dataset, just like a normal replication setup. Make sure all PXC nodes have `log_slave_updates` enabled so that writes from any PXC are saved to each node’s binary log.

---

<div class="post-metadata">

**Author:** ![sa1eh](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sa1eh/32/9037_2.png) [@sa1eh](https://forums.percona.com/u/sa1eh)\
**Post date:** [January 18, 2023, 9:10am UTC](https://forums.percona.com/t/how-to-sync-xtradb-cluster-with-other-database/19667/3 "2023-01-18T09:10:47Z")

</div>

Hi @matthewb

Thanks a lot for your quick response.

- Can you please provide me with docs on how to do replica from one of the nodes?
- New node is it going to be read/write or read only?

**I need new instance to be read/write for dev team to do modification.**

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [January 18, 2023, 5:34pm UTC](https://forums.percona.com/t/how-to-sync-xtradb-cluster-with-other-database/19667/4 "2023-01-18T17:34:01Z")

</div>

Hi @sa1eh  
As @matthewb indicated, your steps would be to take a backup and restore to your non-production instance. since you expect to modify data that will mean replication should not be deployed as eventually you will run into data differences between instances and replication will break.  
You will want to take a backup and perform restoration as per our documentation:

> **[Percona Software Documentation](https://docs.percona.com/percona-xtrabackup/8.0/backup_scenarios/full_backup.html)**
>
> .container-box-download { justify-content: flex-start; } .container-button-learn-more { margin-bottom: 10px; } .logo-server-home { background: url(/img/product-logos/sprite.png)

You will want to develop code to regularly deploy this backup on a regular basis, perhaps weekly.