MySQL 物理备份-xtrabackup之stream流备份

(1) 创建备份用户

    CREATE USER 'backup'@'localhost' IDENTIFIED BY 'backup';
    
    GRANT BACKUP_ADMIN, PROCESS, RELOAD, LOCK TABLES,
    REPLICATION SLAVE, REPLICATION CLIENT 
    ON *.* TO 'backup'@'localhost';
    
    GRANT REPLICATION_SLAVE_ADMIN  ON *.* TO  'backup'@'localhost' ;
    
-- GRANT SELECT ON performance_schema.log_status TO 'backup'@'localhost';
-- GRANT SELECT ON performance_schema.keyring_component_status TO backup@'localhost';
    
    FLUSH PRIVILEGES;

(2) 备份

nohup xtrabackup --backup --compress \
--user=backup \
--password=backup \
--compress-threads=8 \
--stream=xbstream \
--parallel=4 \
--socket=/tmp/mysql.sock \
--target-dir=/backup/tmp  > /backup/backup-db/full_backup.xbstream 2>/tmp/backup-$(date +'%F') &

(3) 解压压缩包

xbstream -x -C "/data/mysql" < full_backup.xbstream