Using xtrabackup for copying files can really saturate your disks, and that why we made special option
|
1 |
--throttle=rate |
to limit rate of IO per second. But it really works when you do local copy.
What about stream backup ? Even you copy just to remote box with
|
1 |
innobackupex --stream=tar | ssh remotebox "tar xfi -" |
, read may be so intensive so your mysqld feels impact, slave getting behind, etc…
For this there is a nice small utility – pv .
With pv you run:
|
1 |
innobackupex --stream=tar | pv -q -L10m | ssh remotebox "tar xfi -" |
and it will limit channel rate to 10 M per second.
About the Author
Vadim TkachenkoVadim Tkachenko co-founded Percona in 2006 and serves as its Chief Technology Officer. Vadim leads Percona Labs, which focuses on technology research and performance evaluations of Percona’s and third-party products. Vadim’s expertise in LAMP performance and multi-threaded programming help optimize MySQL and InnoDB internals to take full advantage of modern hardware. He also co-authored the book High Performance MySQL: Optimization, Backups, and Replication 3rd Edition.
