How do I rate limit mysqldump from a remote host?

Question

I'm running mysqldump from a remote machine to do periodic backups of our database and want to ensure it isn't using up all of the available bandwidth.

The command I'm running is:

mysqldump --compress --opt --add-drop-database --skip-lock-tables --single\
-transaction -u$USER -p$PASSWD -h $HOST $DB > $SCRIPT_DIR/$DB.$HOST_NAME\
.sql

I'd rather not have to rely on running the backups locally and using SCP/SFTP if possible.

something like this maybe? http://www.debian-administration.org/articles/187 — CasualT, Sep 06 '12 at 17:26

score 0 · Accepted Answer · answered Sep 17 '12 at 14:11

0

Trickle looks like it'll do the trick.

The nice thing about this is it doesn't require root credentials to work.

answered Sep 17 '12 at 14:11

hafichuk

10,351
10
38
53

How do I rate limit mysqldump from a remote host?

1 Answers1