I am evaluating percona cluster to see if we should use it, but I have getting the following errors when starting the 2nd node. Please help.
mysql.log
140501 14:13:19 [Note] WSREP: New cluster view: global state: c9d04a44-d0be-11e3-b9da-ff3aecfc8ed9:23, view# 6: Primary, number of nodes: 2, my index: 0, protocol version 2
140501 14:13:19 [Warning] WSREP: Gap in state sequence. Need state transfer.
140501 14:13:21 [Note] WSREP: Running: ‘wsrep_sst_xtrabackup --role ‘joiner’ --address ‘dbsmyt03’ --auth ‘sst:secret’ --datadir ‘/var/lib/mysql/’ --defaults-file ‘/etc/my.cnf’ --parent ‘10144’’
WSREP_SST: [INFO] Streaming with tar (20140501 14:13:21.971)
WSREP_SST: [INFO] Using socat as streamer (20140501 14:13:21.972)
WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:4444,reuseaddr stdio | tar xfi - --recursive-unlink -h; RC=( ${PIPESTATUS[@]} ) (20140501 14:13:21.979)
socat: error while loading shared libraries: libreadline.so.5: cannot open shared object file: No such file or directory
tar: This does not look like a tar archive
tar: Exiting with failure status due to previous errors
140501 14:13:32 [Note] WSREP: Prepared SST request: xtrabackup|dbsmyt03:4444/xtrabackup_sst
140501 14:13:32 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
140501 14:13:32 [Note] WSREP: Assign initial position for certification: 23, protocol version: 2
140501 14:13:32 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (c9d04a44-d0be-11e3-b9da-ff3aecfc8ed9): 1 (Operation not permitted)
at galera/src/replicator_str.cpp:prepare_for_IST():445. IST will be unavailable.
140501 14:13:32 [Note] WSREP: Node 0 (dbsmyt03) requested state transfer from ‘any’. Selected 1 (dbsmyt01)(SYNCED) as donor.
140501 14:13:32 [Note] WSREP: Shifting PRIMARY → JOINER (TO: 23)
140501 14:13:32 [Note] WSREP: Requesting state transfer: success, donor: 1
WSREP_SST: [ERROR] Error while getting data from donor node: exit codes: 127 2 (20140501 14:13:32.226)
WSREP_SST: [ERROR] Cleanup after exit with status:32 (20140501 14:13:32.227)
WSREP_SST: [INFO] Removing the sst_in_progress file (20140501 14:13:32.228)
140501 14:13:32 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role ‘joiner’ --address ‘dbsmyt03’ --auth ‘sst:secret’ --datadir ‘/var/lib/mysql/’ --defaults-file ‘/etc/my.cnf’ --parent ‘10144’: 32 (Broken pipe)
140501 14:13:32 [ERROR] WSREP: Failed to read uuid:seqno from joiner script.
140501 14:13:32 [ERROR] WSREP: SST failed: 32 (Broken pipe)
140501 14:13:32 [ERROR] Aborting
140501 14:13:32 [Warning] WSREP: 1 (dbsmyt01): State transfer to 0 (dbsmyt03) failed: -1 (Operation not permitted)
140501 14:13:32 [ERROR] WSREP: gcs/src/gcs_group.c:gcs_group_handle_join_msg():719: Will never receive state. Need to abort.
140501 14:13:32 [Note] WSREP: gcomm: terminating thread
140501 14:13:32 [Note] WSREP: gcomm: joining thread
140501 14:13:32 [Note] WSREP: gcomm: closing backend
140501 14:13:33 [Note] WSREP: view(view_id(NON_PRIM,461454d0-d15c-11e3-9324-37342298a57d,6) memb {
461454d0-d15c-11e3-9324-37342298a57d,
} joined {
} left {
} partitioned {
bed5f1c5-d15b-11e3-8e95-0e9dd5f855e1,
})
140501 14:13:33 [Note] WSREP: view((empty))
140501 14:13:33 [Note] WSREP: gcomm: closed
140501 14:13:33 [Note] WSREP: /usr/sbin/mysqld: Terminated.
140501 14:13:33 mysqld_safe mysqld from pid file /var/lib/mysql/mysql.pid ended