Checksum is a standard practice among DBAs to verify the data consistency across replicated nodes. In this post we’re going to review the syncing options for an inconsistent MySQL slave of Galera cluster node.
Here we’re assuming a setup of regular replication to a MySQL instance from one of the Galera cluster nodes.
Read More
We were working on setting up Percona XtraDB (Galera) Cluster following the Documentation for version 5.6+. This blog post is a use-case of a debugging / troubleshooting & fixing different SSTÂ issues we faced while bringing-up the cluster nodes.
We already have a successfully bootstrapped node-1 and now we’re adding second node (node-2) which was causing following error.
"2015-01-15 17:33:19 24618 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role 'joiner' --address '10.10.10.1' --auth 'sstuser:xxx' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '24618' '' : 32 (Broken pipe) 2015-01-15 17:33:19 24618 [ERROR] WSREP: Failed to read uuid:seqno from joiner script. 2015-01-15 17:33:19 24618 [ERROR] WSREP: SST failed: 32 (Broken pipe) 2015-01-15 17:33:19 24618 [ERROR] Aborting"