I'm trialing cluster control on a two MariaDB server cluster (master + slave).
Whilst the monitoring appears to work well, I'm having trouble getting a backup to complete successfully.
I configure the backup through the web ui, selecting a full backup using xtrabackup from the slave, and storing the backup on the controller.
I get the same results if I use gzip + single copy thread, or pigz + 8 copy threads (the multi threaded version is much faster!).
innobackupex appears to complete OK which I can tell by looking at the backup.log on the MariaDB slave which has "160418 20:19:26 innobackupex: completed OK!" as the last line, however it has been over an hour since that log message was written yet the process is still sitting there.
The full command is:
Launching 'ulimit -n 256000 && LC_ALL=C /usr/bin/innobackupex --defaults-file=/etc/mysql/my.cnf --parallel 8 --stream=xbstream --no-timestamp . 2>/mnt/dbbackups/tmp/1/mysql_single/backup.log | pigz - | nc 192.168.190.20 9999'
The file on the controller appears to be of the expected size (~12GB zipped), so I'm unsure why the process is sitting around?
Killing the process results in a non-zero exit code, thus the backup job shows up as failed.
Please sign in to leave a comment.