Not the answer you need?
Register and ask your own question!

innobackupex failing with socket error

johntestjohntest ContributorInactive User Role Beginner
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).

Comments

  • johntestjohntest Contributor Inactive User Role Beginner
    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
  • johntestjohntest Contributor Inactive User Role Beginner
    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
  • jriverajrivera Percona Support Engineer Percona Staff Role
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.