We have 4 instances/nodes in Amazon EC2 and 1 instance/node in New York, they are Ubuntu 12.04 with Percona XtraDB 5.5
We followed the directions exactly as is on the Percona XtraDB 5.5 Documentation for installation, however MySQL keeps putting out an error and doesn’t start.
The error we get is:
[INDENT]* Starting MySQL (Percona XtraDB Cluster) database server mysqld
* SST in progress, setting sleep higher mysqld
* The server quit without updating PID file (/var/lib/mysql/ip-172-31-26-31.pid).[/INDENT]
The /etc/mysql/my.cnf file for the bootstrapped node looks like this:
[INDENT][B]
datadir=/var/lib/mysql
user=mysql
# Path to Galera library
wsrep_provider=/usr/lib/libgalera_smm.so
# Empty gcomm
wsrep_cluster_address=gcomm://
# Cluster connection URL contains IPs of node#1, node#2 and node#3
#wsrep_cluster_address=gcomm://54.86.47.57,54.85.76.128,54.187.116.44,54.215.250. 224,149.4.223.202
# In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW
# MyISAM storage engine has only experimental support
default_storage_engine=InnoDB
# This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
innodb_autoinc_lock_mode=2
# Node #1 address
wsrep_node_address=54.86.47.57
# Node name
wsrep_node_name=node1
# Cluster name
wsrep_cluster_name=production
# SST method
wsrep_sst_method=xtrabackup
#Authentication for SST method
wsrep_sst_auth=*************[/B][/INDENT]
The /etc/mysql/my.cnf file for the second/joining node looks like this:
[INDENT]
[B]
datadir=/var/lib/mysql
user=mysql
# Path to Galera library
wsrep_provider=/usr/lib/libgalera_smm.so
# Cluster connection URL contains IPs of node#1, node#2 and node#3
wsrep_cluster_address=gcomm://54.86.47.57,54.85.76.128,54.187.116.44,54.215.250. 224,149.4.223.202
# In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW
# MyISAM storage engine has only experimental support
default_storage_engine=InnoDB
# This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
innodb_autoinc_lock_mode=2
# Node #2 address
wsrep_node_address=54.85.76.128
# Node name
wsrep_node_name=node2
# Cluster name
wsrep_cluster_name=production
# SST method
wsrep_sst_method=xtrabackup
#Authentication for SST method
wsrep_sst_auth=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 resour ces:
[URL]http://www.percona.com/xb/p[/URL]
140626 17:24:49 innobackupex: Connecting to MySQL server with DSN 'dbi:mysq l:;mysql_read_default_file=/etc/mysql/my.cnf;mysql_read_default_group=xtraba ckup;mysql_socket=/var/run/mysqld/mysqld.sock' as 'sstuser' (using password : YES).
140626 17:24:49 innobackupex: Connected to MySQL server
140626 17:24:49 innobackupex: Executing a version check against the server. ..
140626 17:24:49 innobackupex: Done.
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using mysql server version 5.5.37-35.0-55
innobackupex: Created backup directory /tmp
140626 17:24:49 innobackupex: Starting ibbackup with command: xtrabackup - -defaults-file="/etc/mysql/my.cnf" --defaults-group="mysqld" --backup --sus pend-at-end --target-dir=/tmp --tmpdir=/tmp --extra-lsndir='/tmp' --stream=t ar
innobackupex: Waiting for ibbackup (pid=1811) to suspend
innobackupex: Suspend file '/tmp/xtrabackup_suspended_2'
xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revisi on id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 50331648
xtrabackup: innodb_log_file_size = 50331648
InnoDB: Error: log file ./ib_logfile0 is of different size 5242880 bytes
InnoDB: than specified in the .cnf file 50331648 bytes!
innobackupex: Error: The xtrabackup child process has died at /usr//bin/inno backupex line 2672.[/INDENT]
The /var/lib/mysql/ip-172-31-26-31.err file for the second/joining node looks like this:
[INDENT]
WSREP_SST: [ERROR] Cleanup after exit with status:32 (20140626 17:24:50.797 )
WSREP_SST: [INFO] Removing the sst_in_progress file (20140626 17:24:50.811)
140626 17:24:50 [ERROR] WSREP: Process completed with error: wsrep_sst_xtra backup --role 'joiner' --address '54.85.76.128' --auth 'sstuser:s3cretPass' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent ' 1941': 32 (Broken pipe)
140626 17:24:50 [ERROR] WSREP: Failed to read uuid:seqno from joiner script .
140626 17:24:50 [ERROR] WSREP: SST failed: 32 (Broken pipe)
140626 17:24:50 [ERROR] Aborting
140626 17:24:51 [Note] WSREP: view(view_id(NON_PRIM,8afc7a38-fd56-11e3-84ed -b7677f085512,4) memb {
c459150c-fd56-11e3-9936-9ac4ec9d0599,
} joined {
} left {
} partitioned {
8afc7a38-fd56-11e3-84ed-b7677f085512,
})
140626 17:24:51 [Note] WSREP: view((empty))
140626 17:24:51 [Note] WSREP: gcomm: closed
140626 17:24:51 [Note] WSREP: /usr/sbin/mysqld: Terminated.
Aborted (core dumped)
140626 17:24:51 mysqld_safe mysqld from pid file /var/lib/mysql/ip-172-31-2 6-31.pid ended[/INDENT]
Any Idea How To Solve this, Please!?