# 3 node system manual sync with sql file **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [May 22, 2014, 9:03am UTC](https://forums.percona.com/t/3-node-system-manual-sync-with-sql-file/3496 "2014-05-22T09:03:39Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![zmahomedy](https://avatars.discourse-cdn.com/v4/letter/z/919ad9/32.png) [@zmahomedy](https://forums.percona.com/u/zmahomedy)\ **Post date:** [May 22, 2014, 9:03am UTC](https://forums.percona.com/t/3-node-system-manual-sync-with-sql-file/3496/1 "2014-05-22T09:03:39Z")
hi I have a 1 gig sql file which I took from the primary node and copied it to my 2nd and 3rd node I started my second node as a regular mysql server without the galera options and restored the db I then restarted the db as a cluster node and it synced up very fast On my 3rd node, I did the same thing however, SST is removing all the databases and syncing from the primary node which is what I am trying to avoid when deploying out new nodes… the sync takes couple of hours over my vpn Im not sure what is needed to be in place so that the manual restore stays and the sst just checks for missing stuff At this time for testing there are no updates going through the primary node so all data is the same any help will be appriciated zak ---
**Author:** ![shockwavecs](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@shockwavecs](https://forums.percona.com/u/shockwavecs)\ **Post date:** [May 23, 2014, 3:16pm UTC](https://forums.percona.com/t/3-node-system-manual-sync-with-sql-file/3496/2 "2014-05-23T15:16:01Z")
edit: disclaimer: I haven’t used this before, just thinking it would be the solution. I would think you could have you my.cnf say something like “wsrep\_sst\_method=rsync”. On the remote node change it to “wsrep\_sst\_method=skip”. After it syncs you can change it back to rsync. Here is the section of the documentation I found this from: [URL=“[Index of wsrep system variables](http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html)”][http://www.percona.com/doc/percona-x...tem-index.html[/URL]](http://www.percona.com/doc/percona-x...tem-index.html%5B/URL%5D) variable wsrep\_sst\_method [TABLE=“class: wysiwyg\_table\_wysiwyg\_table\_docutils wysiwyg\_table\_wysiwyg\_table\_field-list”] [TR=“class: wysiwyg\_table\_wysiwyg\_table\_field-odd wysiwyg\_table\_wysiwyg\_table\_field”] [TD=“class: wysiwyg\_table\_wysiwyg\_table\_field-body”]Command Line : Yes[/TD] [/TR] [TR=“class: wysiwyg\_table\_wysiwyg\_table\_field-even wysiwyg\_table\_wysiwyg\_table\_field”] [TD=“class: wysiwyg\_table\_wysiwyg\_table\_field-body”]Config File : Yes[/TD] [/TR] [TR=“class: wysiwyg\_table\_wysiwyg\_table\_field-odd wysiwyg\_table\_wysiwyg\_table\_field”] [TD=“class: wysiwyg\_table\_wysiwyg\_table\_field-body”]Scope: Global[/TD] [/TR] [TR=“class: wysiwyg\_table\_wysiwyg\_table\_field-even wysiwyg\_table\_wysiwyg\_table\_field”] [TD=“class: wysiwyg\_table\_wysiwyg\_table\_field-body”]Dynamic: Yes[/TD] [/TR] [TR=“class: wysiwyg\_table\_wysiwyg\_table\_field-odd wysiwyg\_table\_wysiwyg\_table\_field”] [TD=“class: wysiwyg\_table\_wysiwyg\_table\_field-body”]Default Value: rsync[/TD] [/TR] [TR=“class: wysiwyg\_table\_wysiwyg\_table\_field-even wysiwyg\_table\_wysiwyg\_table\_field”] [TD=“class: wysiwyg\_table\_wysiwyg\_table\_field-body”]Recommended: xtrabackup-v2[/TD] [/TR] [/TABLE] This variable sets up the method for taking the State Snapshot Transfer (SST). Available options are: [LIST] [_]xtrabackup - uses Percona XtraBackup to perform the SST, this method requires [wsrep\_sst\_auth](http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html#wsrep_sst_auth) to be set up with : which XtraBackup will use on donor. Privileges and permissions needed for running XtraBackup can be found [here](http://www.percona.com/doc/percona-xtrabackup/innobackupex/privileges.html#permissions-and-privileges-needed). [_]xtrabackup-v2 - This is same as xtrabackup SST except that it uses newer protocol, hence is not compatible. This is the recommended option for PXC 5.5.34 and above. For more details, please check [Xtrabackup SST Configuration](http://www.percona.com/doc/percona-xtradb-cluster/5.5/manual/xtrabackup_sst.html#xtrabackup-sst) and [Percona XtraDB Cluster Errata (as of 5.5.34)](http://www.percona.com/doc/percona-xtradb-cluster/5.5/errata.html#errata). [_]rsync - uses rsync to perform the SST, this method doesn’t use the [wsrep\_sst\_auth](http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html#wsrep_sst_auth) [_]mysqldump - uses mysqldump to perform the SST, this method requires [wsrep\_sst\_auth](http://www.percona.com/doc/percona-xtradb-cluster/5.5/wsrep-system-index.html#wsrep_sst_auth) to be set up with :, where user has root privileges on the server. [_]custom\_script\_name - Galera supports [Scriptable State Snapshot Transfer](http://www.codership.com/wiki/doku.php?id=scriptable_state_snapshot_transfer). This enables users to create their own custom script for performing an SST. [_]skip - this option can be used to skip the SST, it can be used when initially starting the cluster and manually restore the same data to all nodes. It shouldn’t be used as permanent setting because it could lead to data inconsistency across the nodes. [/LIST]