# innobackupex failing with socket error

**URL:** <https://forums.percona.com/t/innobackupex-failing-with-socket-error/4600>\
**Category:** Percona XtraBackup\
**Created:** [December 14, 2015, 4:42pm UTC](https://forums.percona.com/t/innobackupex-failing-with-socket-error/4600 "2015-12-14T16:42:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![johntest](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@johntest](https://forums.percona.com/u/johntest)\
**Post date:** [December 14, 2015, 4:42pm UTC](https://forums.percona.com/t/innobackupex-failing-with-socket-error/4600/1 "2015-12-14T16:42:04Z")

</div>

Here is the my.cnf

[mysqld]

wsrep\_provider=/usr/lib64/galera-3/libgalera\_smm.so  
wsrep\_cluster\_address=“gcomm://10.10.1.2,10.10.1.3,10.10.1.4”  
binlog\_format=row  
default\_storage\_engine=InnoDB  
innodb\_autoinc\_lock\_mode=2  
bind-address=0.0.0.0

# Maximum number of rows in write set

wsrep\_max\_ws\_rows=1048576

# Maximum size of write set

wsrep\_max\_ws\_size=1073741824

max\_allowed\_packet = 64M  
max\_connections = 512  
table\_open\_cache=1000  
innodb\_buffer\_pool\_size=4G  
query\_cache\_type=1  
query\_cache\_size=128M  
wait\_timeout=86400  
innodb\_log\_file\_size = 2G  
innodb\_log\_buffer\_size = 32M  
innodb\_file\_per\_table = 1  
innodb\_log\_files\_in\_group = 2  
innodb\_flush\_method = O\_DIRECT  
innodb\_flush\_log\_at\_trx\_commit = 2  
event\_scheduler=ON

#multi-site cluster  
wsrep\_provider\_options=“evs.keepalive\_period = PT3S; evs.suspect\_timeout = PT30S; evs.inactive\_timeout = PT1M; evs.install\_timeout = PT1M”

COMMAND  
innobackupex --user=root --password=Password123 /var/tmp/backup

OUTPUT  
151214 17:06:16 innobackupex: Starting the backup operation

IMPORTANT: Please check that the backup run completes successfully.  
At the end of a successful backup run innobackupex  
prints “completed OK!”.

151214 17:06:16 version\_check Connecting to MySQL server with DSN ‘dbi:mysql:;mysql\_read\_default\_group=xtrabackup;host=localhost;port=3306’ as ‘root’ (using password: YES).  
151214 17:06:16 version\_check Connected to MySQL server  
151214 17:06:16 version\_check Executing a version check against the server…  
151214 17:06:16 version\_check Done.  
151214 17:06:16 Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: (null)  
Failed to connect to MySQL server: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2).

---

<div class="post-metadata">

**Author:** ![johntest](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@johntest](https://forums.percona.com/u/johntest)\
**Post date:** [December 14, 2015, 4:46pm UTC](https://forums.percona.com/t/innobackupex-failing-with-socket-error/4600/2 "2015-12-14T16:46:52Z")

</div>

Forgot to mention.  
This is CentOS 6.7

packages  
galera-3-25.3.12-2.el6.x86\_64  
mysql-wsrep-server-5.6-5.6.25-25.11.el6.x86\_64  
mysql-wsrep-5.6-5.6.25-25.11.el6.x86\_64  
mysql-wsrep-client-5.6-5.6.25-25.11.el6.x86\_64  
MySQL-shared-compat-5.5.35-1.el6.x86\_64  
mysql-wsrep-devel-5.6-5.6.25-25.11.el6.x86\_64  
perl-DBD-MySQL-4.013-3.el6.x86\_64

---

<div class="post-metadata">

**Author:** ![johntest](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@johntest](https://forums.percona.com/u/johntest)\
**Post date:** [December 14, 2015, 5:07pm UTC](https://forums.percona.com/t/innobackupex-failing-with-socket-error/4600/3 "2015-12-14T17:07:05Z")

</div>

Found the solution.

I had done this  
yum install percona-xtrabackup

Instead of this  
yum install percona-xtrabackup-22

For CentOS 6.7 we have to do this  
yum install percona-xtrabackup-22

---

<div class="post-metadata">

**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\
**Post date:** [December 16, 2015, 12:20am UTC](https://forums.percona.com/t/innobackupex-failing-with-socket-error/4600/4 "2015-12-16T00:20:28Z")

</div>

percona-xtrabackup-22 will install the 2.2.x version of the package.  
percona-xtrabackup-21 will install the 2.1.x version of the package.  
percona-xtrabackup will install the 2.3.x version of the package.

Make sure you installed latest repository rpm package.
