# reparing for cluster from dump data

**URL:** <https://forums.percona.com/t/reparing-for-cluster-from-dump-data/7268>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [October 29, 2019, 10:09pm UTC](https://forums.percona.com/t/reparing-for-cluster-from-dump-data/7268 "2019-10-29T22:09:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![stoneboy](https://avatars.discourse-cdn.com/v4/letter/s/7ea924/32.png) [@stoneboy](https://forums.percona.com/u/stoneboy)\
**Post date:** [October 29, 2019, 10:09pm UTC](https://forums.percona.com/t/reparing-for-cluster-from-dump-data/7268/1 "2019-10-29T22:09:52Z")

</div>

Hi i am new for xtraDB cluster, i have 500gb dump file want to restore and create clustering, what step i must to do?

1. Restore dump file on every node ?  
OR
2. Restore dump file just on 1 node (bootstrap node) ?

this my topology i want create without downtime

1 Percona Mysql Server( Already Run Master) ==\>\> 3 Node Clustering  
then set off mysql server after 3 node clustering sync done.

Thanks before!

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [October 30, 2019, 2:49am UTC](https://forums.percona.com/t/reparing-for-cluster-from-dump-data/7268/2 "2019-10-30T02:49:57Z")

</div>

Hello [stoneboy](https://www.percona.com/forums/member/43292-stoneboy) thanks for asking.

I think a good starting point could be this webinar (which is entirely free). Although it’s a few years old, I believe it will cover quite a lot of the “how does this work best” points that you are likely to raise if you are migrating from an existing set up to a new one using PXC. As it says, it’s a mostly operational discussion, not an in-depth technical review, and so it is largely version agnostic.

[URL][Percona Webinars: Open Source Database Learning](https://www.percona.com/resources/mysql-webinars/migrating-percona-xtradb-cluster%5B/URL%5D)

Although it’s in the context of dbdeployer, this blog post has a good section about understanding some of the nuances of PXC for someone with MySQL experience who’s new to using galera cluster, and you might find it useful [URL][http://datacharmer.blogspot.com/2019/03/dbdeployer-community-part-2-percona.html[/URL]](http://datacharmer.blogspot.com/2019/03/dbdeployer-community-part-2-percona.html%5B/URL%5D)

You have probably seen these How-to’s but I’d be interested to hear if you don’t think that your scenario is covered by these, as we’re always looking to improve our documentation: [URL][Redirecting](https://www.percona.com/doc/percona-xtradb-cluster/LATEST/index.html#how-tos%5B/URL%5D)

Please always test, test, test in a non-production environment!

---

<div class="post-metadata">

**Author:** ![stoneboy](https://avatars.discourse-cdn.com/v4/letter/s/7ea924/32.png) [@stoneboy](https://forums.percona.com/u/stoneboy)\
**Post date:** [October 30, 2019, 12:29pm UTC](https://forums.percona.com/t/reparing-for-cluster-from-dump-data/7268/3 "2019-10-30T12:29:02Z")

</div>

Hi [lorraine.pocklington](https://www.percona.com/forums/member/41223-lorraine-pocklington), Thanks for replies.

On the way for read [url][Percona Webinars: Open Source Database Learning](https://www.percona.com/resources/mysql-webinars/migrating-percona-xtradb-cluster%5B/url%5D) and other link,  
hope i can asking here again when found some trouble on my implementation later.  
Thanks.

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [October 30, 2019, 12:35pm UTC](https://forums.percona.com/t/reparing-for-cluster-from-dump-data/7268/4 "2019-10-30T12:35:26Z")

</div>

Yes - if you don’t find the answers you need in those links please come straight back and I’ll see if I can get someone to help you out.
