# Galera Cluster xtrabackup SST not working **URL:** \ **Category:** Percona XtraBackup\ **Created:** [November 28, 2014, 5:24am UTC](https://forums.percona.com/t/galera-cluster-xtrabackup-sst-not-working/3912 "2014-11-28T05:24:50Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![iceget](https://avatars.discourse-cdn.com/v4/letter/i/73ab20/32.png) [@iceget](https://forums.percona.com/u/iceget)\ **Post date:** [November 28, 2014, 5:24am UTC](https://forums.percona.com/t/galera-cluster-xtrabackup-sst-not-working/3912/1 "2014-11-28T05:24:50Z")
dear users, i have a Problem with the sync in galera. have installed xtrabackup and mysql + galera. i have (for test) 2 nodes. node1 10.0.0.241, node2 10.0.0.242. so my config in node1: # All files in this package is subject to the GPL v2 license # More information is in the COPYING file in the top directory of this package. # Copyright (C) 2011 [severalnines.com](http://severalnines.com) [mysqld] user=mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock basedir = /usr datadir = /var/lib/mysql port=3306 log\_error=error.log #log\_output=FILE #relay\_log=relay-bin ### INNODB OPTIONS innodb\_buffer\_pool\_size=2262M innodb\_additional\_mem\_pool\_size=20M innodb\_flush\_log\_at\_trx\_commit=2 innodb\_file\_per\_table=1 [HTML][HTML][/HTML][/HTML] ## You may want to tune the below depending on number of cores and disk sub innodb\_read\_io\_threads=4 innodb\_write\_io\_threads=4 innodb\_doublewrite=1 innodb\_log\_file\_size=512M innodb\_log\_buffer\_size=64M innodb\_buffer\_pool\_instances=4 innodb\_log\_files\_in\_group=2 innodb\_thread\_concurrency=64 #innodb\_file\_format=barracuda innodb\_flush\_method = O\_DIRECT innodb\_locks\_unsafe\_for\_binlog=1 innodb\_autoinc\_lock\_mode=2 ## avoid statistics update when doing e.g show tables innodb\_stats\_on\_metadata=0 engine\_condition\_pushdown=1 default\_storage\_engine=innodb # CHARACTER SET #collation\_server = utf8\_unicode\_ci #init\_connect=‘SET NAMES utf8’ #character\_set\_server = utf8 # REPLICATION SPECIFIC #server\_id must be unique across all mysql servers participating in replication. #server\_id=SERVERID #auto\_increment\_increment=2 #auto\_increment\_offset=SERVERID binlog\_format=ROW #log\_bin=binlog #log\_slave\_updates=1 #relay\_log=relay-bin #expire\_logs\_days=7 # OTHER THINGS, BUFFERS ETC key\_buffer\_size = 24M tmp\_table\_size = 64M max\_heap\_table\_size = 64M max\_allowed\_packet = 512M #sort\_buffer\_size = 256K #read\_buffer\_size = 256K #read\_rnd\_buffer\_size = 512K #myisam\_sort\_buffer\_size = 8M skip\_name\_resolve memlock=0 sysdate\_is\_now=1 max\_connections=500 thread\_cache\_size=512 query\_cache\_type = 0 query\_cache\_size = 0 table\_open\_cache=1024 lower\_case\_table\_names=0 ## ## WSREP options ## # Full path to wsrep provider library or ‘none’ wsrep\_provider=/usr/lib/galera/libgalera\_smm.so wsrep\_node\_address=10.0.0.241 # Provider specific configuration options wsrep\_provider\_options=“gcache.size=8192M” # Logical cluster name. Should be the same for all nodes. wsrep\_cluster\_name=“my\_wsrep\_cluster” # Group communication system handle wsrep\_cluster\_address=gcomm:// # Human-readable node name (non-unique). Hostname by default. wsrep\_node\_name=10.0.0.241 # Address for incoming client connections. Autodetect by default. #wsrep\_node\_incoming\_address= # How many threads will process writesets from other nodes wsrep\_slave\_threads=8 # DBUG options for wsrep provider #wsrep\_dbug\_option # Generate fake primary keys for non-PK tables (required for multi-master # and parallel applying operation) wsrep\_certify\_nonPK=1 # Location of the directory with data files. Needed for non-mysqldump # state snapshot transfers. Defaults to mysql\_real\_data\_home. #wsrep\_data\_home\_dir= # Maximum number of rows in write set wsrep\_max\_ws\_rows=131072 # Maximum size of write set wsrep\_max\_ws\_size=1073741824 # to enable debug level logging, set this to 1 wsrep\_debug=0 # convert locking sessions into transactions wsrep\_convert\_LOCK\_to\_trx=0 # how many times to retry deadlocked autocommits wsrep\_retry\_autocommit=1 # change auto\_increment\_increment and auto\_increment\_offset automatically wsrep\_auto\_increment\_control=1 # replicate myisam wsrep\_replicate\_myisam=1 # retry autoinc insert, which failed for duplicate key error wsrep\_drupal\_282555\_workaround=0 # enable “strictly synchronous” semantics for read operations wsrep\_causal\_reads=0 # Command to call when node status or cluster membership changes. # Will be passed all or some of the following options: # –status - new status of this node # –uuid - UUID of the cluster # –primary - whether the component is primary or not (“yes”/“no”) # –members - comma-separated list of members # –index - index of this node in the list #wsrep\_notify\_cmd= ## ## WSREP State Transfer options ## # State Snapshot Transfer method # ClusterControl currently DOES NOT support wsrep\_sst\_method=mysqldump wsrep\_sst\_method=xtrabackup # Address on THIS node to receive SST at. DON’T SET IT TO DONOR ADDRESS!!! # (SST method dependent. Defaults to the first IP of the first interface) #wsrep\_sst\_receive\_address= # SST authentication string. This will be used to send SST to joining nodes. # Depends on SST method. For mysqldump method it is root:\ wsrep\_sst\_auth=root:pass # Desired SST donor name. #wsrep\_sst\_donor= # Protocol version to use # wsrep\_protocol\_version= [client] port = 3306 socket=/var/run/mysqld/mysqld.sock #default\_character\_set=utf8 [mysqldump] max\_allowed\_packet = 512M [mysqld\_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 config on node 2 (same as config 1, only the following parameters was changed): … wsrep\_node\_address=10.0.0.242 wsrep\_cluster\_address=gcomm://10.0.0.241 wsrep\_node\_name=10.0.0.242 … on node 1 have done a (after mysql Server starts): mysql -u root --execute=“SET wsrep\_on = OFF; GRANT ALL ON _._ TO user@‘%’ identified by ‘pass’;” so the node 1 i can start without Problems. but if i start the node 2 i get the following error(s) on node 1: /var/lib/mysqL/error.log 141128 11:34:22 [ERROR] WSREP: Failed to read from: wsrep\_sst\_xtrabackup --role ‘donor’ --address ‘10.0.0.242:4444/xtrabackup\_sst’ --auth ‘user:pass’ --socket ‘/var/run/mysqld/mysqld.sock’ --datadir ‘/var/lib/mysql/’ --defaults-file ‘/etc/mysql/my.cnf’ --gtid ‘06ab79ea-76ea-11e4-bfd5-9f746c398e32:1’ /var/lib/mysql//innobackup.backup.log: InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved. This software is published under the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. Get the latest version of Percona XtraBackup, documentation, and help resources: [http://www.percona.com/xb/p](http://www.percona.com/xb/p) 141128 11:34:22 innobackupex: Connecting to MySQL server with DSN ‘dbi:mysql:;mysql\_read\_default\_file=/etc/mysql/my.cnf;mysql\_read\_default\_group=xtrabackup;mysql\_s ocket=/var/run/mysqld/mysqld.sock’ as ‘user’ (using password: YES). innobackupex: Error: Failed to connect to MySQL server: DBI connect(‘;mysql\_read\_default\_file=/etc/mysql/my.cnf;mysql\_read\_default\_group=xtrabackup;mysql\_s ocket=/var/run/mysqld/mysqld.sock’,‘user’,…) failed: Access denied for user ‘root’@‘localhost’ (using password: YES) at /usr//bin/innobackupex line 2945 why? i only will connect via the replication user (user). can anybody help me? thanks ---
**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\ **Post date:** [December 2, 2014, 10:58pm UTC](https://forums.percona.com/t/galera-cluster-xtrabackup-sst-not-working/3912/2 "2014-12-02T22:58:55Z")
It seems like ‘root’ user has no privileges to connect to node1 (donor) for SST. I would suggest to create dedicated SST user on node1 and use wsrep\_sst\_auth in node2 my.cnf This all is well covered here [url][Percona XtraDB Cluster](http://www.percona.com/doc/percona-xtradb-cluster/5.5/howtos/cenots_howto.html%5B/url%5D) ---
**Author:** ![thains](https://avatars.discourse-cdn.com/v4/letter/t/51bf81/32.png) [@thains](https://forums.percona.com/u/thains)\ **Post date:** [November 2, 2017, 1:06pm UTC](https://forums.percona.com/t/galera-cluster-xtrabackup-sst-not-working/3912/3 "2017-11-02T13:06:27Z")
It could also be that your firewall is blocking access on port 4444. The configuration guides I’ve seen tend to leave that one out of the firewall setting steps, for some reason.