MySQL Backup--Xtrabackup備份常見錯誤

1、DDL操作與Xtrabackup備份沖突

當MySQL使用xrabckup進行備份時，如果執行DDL進行表修改，會導緻xrabckup備份失敗。

錯誤類似于：

InnoDB: Last flushed lsn: 3375345258517 load_index lsn 3379255303757
InnoDB: An optimized (without redo logging) DDLoperation has been performed. All modified pages may not have been flushed to the disk yet. 
PXB will not be able take a consistent backup. Retry the backup operation      

2、磁盤性能太差導緻xtrabckup備份失敗

xtrabackup: error: log block numbers mismatch:
xtrabackup: error: expected log block no. 201901064, but got no. 208192508 from the log file.
xtrabackup: error: it looks like InnoDB log has wrapped around before xtrabackup could process all records due to either log copying being too slow, or  log files being too small.
xtrabackup: Error: xtrabackup_copy_logfile() failed.