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).