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
mysql:
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"]
[TR]
[TD="bgcolor: #f5f5f5"]
[/TR]
[TR]
[TD="bgcolor: #f5f5f5"]
[/TR]
[TR]
[TD="bgcolor: #f5f5f5"]
[/TR]
[/TABLE]
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?