We’ve been using xtrabackup for several years with no issues at all. Recently, it became necessary for a rather large instance – 4.4TB – to begin backups. The instance is relatively busy, but not ridiculously so.
The base backup takes about 1.5 hours, which is fine. However, the ensuing apply-logs section (I always opt to do the prepare bit before deeming the full backup complete) is taking a whopping 20 hours, which seems a bit excessive to me.
I really only have one burning, painful question:
What could I do via xtrabackup or innobackupex magick to speed this part of the backup along?
Any input would be appreciated.