Hi Everyone, We are having some issues with xtrabackup at the moment.
We have a 226Gb database that need to be backed up and used to create a slave server.
We have to do this regularly for several clients,etc… so it is crucial we get this figured out.
What we are experiencing is the following:
Xtrabackup is started and it immediately starts copying the relevant files to the backup location, and within about an hour or maybe a bit more, it has copied over 218Gb of the data.
The backup then goes into a hellishly long cycle of “Scanned up to log xxxxxxxxxxx” and that has been running now for 24 hours and the disk space on the destination has only increased by 2Gb since then.
We are experiencing the same type of issue on our other 1.4TB db’s as well where it runs very well untill the last about 6gb then it just goes into the cycle of “scanned logs up to xxxxxxxx”.
With the previous 200Gb database we left it running for over a week and it was still doing the same thing.
We have been trying to google to no end and have not found any reason or solution to this and have had to resolve back to the msqldump routes as we were not able to complete a backup and restore via xtrabackup as yet and the main reason for wanting to use xtra backup is because of the sizes of our databases.
I would really appreciate it if someone can assist me in telling me what we are doing wrong.
Current system is as follows:
- ubuntu 12.04 server lts 64bit
- mysql 5.1
- command being run: innobackupex --ibbackup=xtrabackup