Not the answer you need?
Register and ask your own question!

using xtrabackup on production servers

unix196unix196 EntrantCurrent User Role Beginner
Good day! I have some question about using xtrabackup on loaded servers. Characteristics this server
debian stretch
percona-server-server-5.7  5.7.21-21-3.stretch
percona-xtrabackup-24   2.4.12-1.stretch
hardware memory 96G
16 core
load average - 10-12

innodb_buffer_pool_size                 = 72G
459G - size of the db
QPS - 6500

We planning migrate backup database from mysqldump)) to xtrabackup => try test backup on production server.
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, height: 1"]
[TD="bgcolor: #f5f5f5"]
[TD="bgcolor: #f5f5f5"]
[TD="bgcolor: #f5f5f5"]
datadir - is SSD, target-dir - HDD
I try use ionice and throttle, but during backup our monitoring system + haproxy balancer peridically reported that database is unavailable (in nagios - checks fall of with timeout, haproxy - report that backend is unavailable) + ssh terminal on this database server peridically begin slow down.
Try backup on other production database server - there the same problem.

I got the impression that xtrabackup must be using on slave server without user load (i.e. slave server for backup purpose ). Is it true?
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.