Time expectations on log scan?

dvogtdvogt EntrantCurrent User Role Participant
The problem:
Using innobackupex, the files copy over quickly (10 minutes) to a remote server and then the log scanning starts.
The log scanning was taking over 5 hours before I cancelled the backup.
I know the documentation says it can take a long time on a large database, but that is all relevant.

Background:
I just started testing xtrabackup. In the past I was just using mysqldump
I was in the habit of performing 4 snapshots a day on 50GB MySQL databases. This is not obtainable in this scenario.
I was looking for a number in the 1 hour range for a backup. Ultimately I will need to restore this to the Master server.

My questions:
Is it normal to wait 5+ hours for the log scanning?
Is there any benchmarking data with different size databases?
Is there a better strategy for this process?

At this point, I don't live and breath MySQL on a daily basis so any guidance would be helpful.

Thank you
Derrald


THE ENVIRONMENT:

The database has about 18 GB of data.
This is a slave system.
It has 8 Cores and is idle most of the time during the backup.

This is the command I am using:
innobackupex \
--user=user \
--password=password \
--slave-info \
--safe-slave-backup \
--compress --stream=xbstream ./ | \
ssh [EMAIL="user@10.0.0.2"][email protected][/EMAIL] \
"cat - > /data/xtrabackup/2012-05-28_11_37.xbstream"

innobackupex: Starting mysql with options: --password=xxxxxxxx --user='user' --unbuffered --
innobackupex: Connected to database with mysql child process (pid=14380)
innobackupex: Connection to database server closed
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".

innobackupex: Using mysql Ver 14.14 Distrib 5.5.20, for Linux (x86_64) using readline 5.1
innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

innobackupex: Created backup directory /root
innobackupex: Starting mysql with options: --password=xxxxxxxx --user='user' --unbuffered --
innobackupex: Connected to database with mysql child process (pid=14410)
innobackupex: Connection to database server closed

innobackupex: Starting ibbackup with command: xtrabackup_55 --backup --suspend-at-end --target-dir=/data/mysql_tmp --compress --compress-threads=1 --stream=xbstream
innobackupex: Waiting for ibbackup (pid=14417) to suspend
innobackupex: Suspend file '/data/mysql_tmp/xtrabackup_suspended'


END

Comments

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.