One of the things I like about consulting at Percona is the opportunity to be exposed to unusual problems. I recently worked with a customer having issues getting SST to work with Percona XtraDB Cluster. A simple problem you would think. After four hours of debugging, my general feeling was that nothing made sense.
I added a bash trace to the SST script and it claimed MySQL died prematurely:
[ -n '' ]] + ps -p 11244 + wsrep_log_error 'Parent mysqld process (PID:11244) terminated unexpectedly.' + wsrep_log '[ERROR] Parent mysqld process (PID:11244) terminated unexpectedly.' ++ date '+%Y-%m-%d %H:%M:%S' + local readonly 'tst=2017-11-28 22:02:46'
At the same time, from the MySQL error log MySQL was …[Read more]