Not the answer you need?
Register and ask your own question!

xtrabackup (innobackupex-1.5.1) never stops

rajulvorarajulvora EntrantInactive User Role Participant
I am backing up a slave using this command:

innobackupex-1.5.1 --slave-info --stream=tar $BaseDir | ssh remotehost "gzip > /opt/backups/xtra/master/TargetFile.tar.gz"

When I run this on the master, it finishes in 15mins or so. The command above on the slave has been going for over 2 hours now... all I see is lines like this. Should I Control-C and start over? Seems like a bug to me.

>> log scanned up to (41 1808622177)
>> log scanned up to (41 1808623015)
>> log scanned up to (41 1808623015)
>> log scanned up to (41 1808623015)
>> log scanned up to (41 1808624750)
>> log scanned up to (41 1808624750)
>> log scanned up to (41 1808625195)
>> log scanned up to (41 1808625589)
>> log scanned up to (41 1808625589)
>> log scanned up to (41 1808625589)
>> log scanned up to (41 1808626417)
>> log scanned up to (41 1808626417)
>> log scanned up to (41 1808626417)

Comments

  • morgomorgo Entrant Current User Role Participant
    Hi rajulvora,

    Do you mind pasting from the origin server:

    - Your my.cnf file
    - The output from SHOW INNODB STATUS

    I'm interested to know both how far behind on background work InnoDB was at the time of the backup, and what the size of your log files are.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.