MYSQL xtrabackup 全量压缩备份
祖仙教小凡仙 海鲨数据库架构师
只有增加--compress选项,另外我这里对目录自动上时间,原本INNOBACKUPEX自动时间戳的.
xtrabackup --defaults-file=/u01/mysql/mysql8020debug/my.cnf --user=root --password=123456 --backup --target-dir=/u01/mysql/mysql8020debug/backup/Full_mysql8020_`date +%Y-%m-%d-%H-%M-%S` --compress
压缩后所有文件带个GP尾巴
[root@localhost mysql8020debug]# xtrabackup --defaults-file=/u01/mysql/mysql8020debug/my.cnf --user=root --password=123456 --backup --target-dir=/u01/mysql/mysql8020debug/backup/Full_mysql8020_`date +%Y-%m-%d-%H-%M-%S` --compress xtrabackup: recognized server arguments: --datadir=/u01/mysql/mysql8020debug/data xtrabackup: recognized client arguments: --port=3306 --socket=/tmp/mysql.sock --user=root --password=* --backup=1 --target-dir=/u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49 --compress xtrabackup version 8.0.14 based on MySQL server 8.0.21 Linux (x86_64) (revision id: 113f3d7) 210128 23:51:49 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/tmp/mysql.sock' as 'root' (using password: YES). 210128 23:51:49 version_check Connected to MySQL server 210128 23:51:49 version_check Executing a version check against the server... 210128 23:51:49 version_check Done. 210128 23:51:49 Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: /tmp/mysql.sock Using server version 8.0.20-debug xtrabackup: uses posix_fadvise(). xtrabackup: cd to /u01/mysql/mysql8020debug/data xtrabackup: open files limit requested 0, set to 1024 xtrabackup: using the following InnoDB configuration: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 50331648 Number of pools: 1 210128 23:51:49 Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: /tmp/mysql.sock xtrabackup: Redo Log Archiving is not set up. 210128 23:51:49 >> log scanned up to (18284392) xtrabackup: Generating a list of tablespaces xtrabackup: Generating a list of tablespaces Scanning './' Completed space ID check of 2 files. Allocated tablespace ID 1 for sys/sys_config, old maximum was 0 Using undo tablespace './undo_001'. Using undo tablespace './undo_002'. Opened 2 existing undo tablespaces. 210128 23:51:50 [01] Compressing ./ibdata1 to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/ibdata1.qp 210128 23:51:50 [01] ...done 210128 23:51:50 [01] Compressing ./sys/sys_config.ibd to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/sys/sys_config.ibd.qp 210128 23:51:50 [01] ...done 210128 23:51:50 [01] Compressing ./bookstore/books.ibd to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/bookstore/books.ibd.qp 210128 23:51:50 [01] ...done 210128 23:51:50 [01] Compressing ./bookstore/books2.ibd to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/bookstore/books2.ibd.qp 210128 23:51:50 [01] ...done 210128 23:51:50 [01] Compressing ./bookstore/books3.ibd to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/bookstore/books3.ibd.qp 210128 23:51:50 [01] ...done 210128 23:51:50 [01] Compressing ./bookstore/books4.ibd to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/bookstore/books4.ibd.qp 210128 23:51:50 [01] ...done 210128 23:51:50 [01] Compressing ./mysql.ibd to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/mysql.ibd.qp 210128 23:51:50 >> log scanned up to (18284392) 210128 23:51:51 [01] ...done 210128 23:51:51 [01] Compressing ./undo_002 to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/undo_002.qp 210128 23:51:51 >> log scanned up to (18284392) 210128 23:51:51 [01] ...done 210128 23:51:51 [01] Compressing ./undo_001 to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/undo_001.qp 210128 23:51:52 [01] ...done 210128 23:51:52 >> log scanned up to (18284392) 210128 23:51:53 Starting to backup non-InnoDB tables and files 210128 23:51:53 [01] Compressing mysql/slow_log_203.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/mysql/slow_log_203.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing mysql/slow_log.CSM to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/mysql/slow_log.CSM.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing mysql/general_log_202.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/mysql/general_log_202.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing mysql/general_log.CSM to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/mysql/general_log.CSM.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing mysql/slow_log.CSV to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/mysql/slow_log.CSV.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing mysql/general_log.CSV to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/mysql/general_log.CSV.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/replication_conn_157.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/replication_conn_157.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_waits_his_79.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_waits_his_79.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/session_account__144.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/session_account__144.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_stages_su_111.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_stages_su_111.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/variables_by_thr_174.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/variables_by_thr_174.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_statement_122.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_statement_122.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_transacti_127.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_transacti_127.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_statement_118.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_statement_118.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_waits_sum_83.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_waits_sum_83.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/setup_objects_98.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/setup_objects_98.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/memory_summary_b_147.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/memory_summary_b_147.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/socket_summary_b_142.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/socket_summary_b_142.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/replication_conn_155.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/replication_conn_155.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/status_by_thread_170.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/status_by_thread_170.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/data_lock_waits_154.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/data_lock_waits_154.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_waits_sum_86.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_waits_sum_86.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/user_variables_b_167.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/user_variables_b_167.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_transacti_126.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_transacti_126.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/file_instances_87.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/file_instances_87.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_errors_su_133.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_errors_su_133.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/session_connect__143.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/session_connect__143.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/host_cache_90.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/host_cache_90.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_stages_cu_104.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_stages_cu_104.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/replication_appl_161.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/replication_appl_161.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/binary_log_trans_180.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/binary_log_trans_180.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/performance_time_93.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/performance_time_93.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/table_lock_waits_102.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/table_lock_waits_102.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_transacti_124.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_transacti_124.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_stages_hi_105.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_stages_hi_105.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/file_summary_by__89.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/file_summary_by__89.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/user_defined_fun_179.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/user_defined_fun_179.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_stages_su_109.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_stages_su_109.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_statement_119.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_statement_119.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_errors_su_134.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_errors_su_134.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_statement_117.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_statement_117.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/global_variables_175.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/global_variables_175.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/keyring_keys_145.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/keyring_keys_145.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/data_locks_153.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/data_locks_153.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/hosts_139.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/hosts_139.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_statement_121.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_statement_121.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_errors_su_132.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_errors_su_132.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/replication_appl_158.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/replication_appl_158.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/persisted_variab_178.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/persisted_variab_178.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/threads_103.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/threads_103.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/status_by_host_169.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/status_by_host_169.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/replication_appl_164.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/replication_appl_164.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/replication_appl_163.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/replication_appl_163.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/setup_actors_95.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/setup_actors_95.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_statement_120.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_statement_120.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/global_status_172.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/global_status_172.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_waits_his_80.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_waits_his_80.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/memory_summary_b_148.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/memory_summary_b_148.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_transacti_131.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_transacti_131.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_errors_su_135.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_errors_su_135.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_stages_su_110.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_stages_su_110.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/memory_summary_b_150.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/memory_summary_b_150.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/objects_summary__92.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/objects_summary__92.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/status_by_user_171.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/status_by_user_171.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/memory_summary_g_146.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/memory_summary_g_146.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/socket_summary_b_141.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/socket_summary_b_141.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/replication_grou_156.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/replication_grou_156.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_waits_sum_81.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_waits_sum_81.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/status_by_accoun_168.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/status_by_accoun_168.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/setup_threads_99.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/setup_threads_99.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/replication_grou_162.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/replication_grou_162.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/variables_info_177.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/variables_info_177.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_statement_123.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_statement_123.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_waits_cur_78.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_waits_cur_78.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_transacti_128.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_transacti_128.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_statement_115.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_statement_115.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/table_handles_151.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/table_handles_151.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/prepared_stateme_166.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/prepared_stateme_166.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_waits_sum_84.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_waits_sum_84.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/table_io_waits_s_100.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/table_io_waits_s_100.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/session_status_173.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/session_status_173.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_stages_su_108.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_stages_su_108.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_stages_hi_106.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_stages_hi_106.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_waits_sum_85.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_waits_sum_85.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/cond_instances_77.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/cond_instances_77.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_errors_su_136.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_errors_su_136.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_waits_sum_82.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_waits_sum_82.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_statement_114.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_statement_114.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/setup_instrument_97.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/setup_instrument_97.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/replication_appl_159.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/replication_appl_159.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_statement_112.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_statement_112.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/log_status_165.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/log_status_165.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/file_summary_by__88.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/file_summary_by__88.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_statement_116.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_statement_116.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/metadata_locks_152.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/metadata_locks_152.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/mutex_instances_91.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/mutex_instances_91.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_stages_su_107.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_stages_su_107.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/memory_summary_b_149.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/memory_summary_b_149.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_transacti_130.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_transacti_130.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_transacti_125.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_transacti_125.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/accounts_138.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/accounts_138.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/session_variable_176.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/session_variable_176.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/replication_appl_160.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/replication_appl_160.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/users_137.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/users_137.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/rwlock_instances_94.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/rwlock_instances_94.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/socket_instances_140.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/socket_instances_140.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/table_io_waits_s_101.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/table_io_waits_s_101.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_statement_113.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_statement_113.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/events_transacti_129.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/events_transacti_129.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 [01] Compressing performance_schema/setup_consumers_96.sdi to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/performance_schema/setup_consumers_96.sdi.qp 210128 23:51:53 [01] ...done 210128 23:51:53 Finished backing up non-InnoDB tables and files 210128 23:51:53 Executing FLUSH NO_WRITE_TO_BINLOG BINARY LOGS 210128 23:51:53 Selecting LSN and binary log position from p_s.log_status 210128 23:51:53 [00] Compressing /u01/mysql/mysql8020debug/data/binlog.000032 to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/binlog.000032.qp up to position 156 210128 23:51:53 [00] ...done 210128 23:51:53 [00] Compressing /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/binlog.index.qp 210128 23:51:53 [00] ...done 210128 23:51:53 [00] Compressing /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/xtrabackup_binlog_info.qp 210128 23:51:53 [00] ...done 210128 23:51:53 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS... xtrabackup: The latest check point (for incremental): '18284392' xtrabackup: Stopping log copying thread at LSN 18284402. 210128 23:51:53 >> log scanned up to (18284412) Starting to parse redo log at lsn = 18284082 210128 23:51:54 All tables unlocked 210128 23:51:54 [00] Compressing ib_buffer_pool to /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/ib_buffer_pool.qp 210128 23:51:54 [00] ...done 210128 23:51:54 Backup created in directory '/u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/' MySQL binlog position: filename 'binlog.000032', position '156' 210128 23:51:54 [00] Compressing /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/backup-my.cnf.qp 210128 23:51:54 [00] ...done 210128 23:51:54 [00] Compressing /u01/mysql/mysql8020debug/backup/Full_mysql8020_2021-01-28-23-51-49/xtrabackup_info.qp 210128 23:51:54 [00] ...done xtrabackup: Transaction log of lsn (18284392) to (18284422) was copied. 210128 23:51:55 completed OK!
[root@localhost backup]# cd Full_mysql8020_2021-01-28-23-51-49/ [root@localhost Full_mysql8020_2021-01-28-23-51-49]# ll 总用量 2780 -rw-r----- 1 root root 459 1月 28 23:51 backup-my.cnf.qp -rw-r----- 1 root root 190 1月 28 23:51 binlog.000032.qp -rw-r----- 1 root root 93 1月 28 23:51 binlog.index.qp drwxr-x--- 2 root root 4096 1月 28 23:51 bookstore -rw-r----- 1 root root 988 1月 28 23:51 ib_buffer_pool.qp -rw-r----- 1 root root 167011 1月 28 23:51 ibdata1.qp drwxr-x--- 2 root root 4096 1月 28 23:51 mysql -rw-r----- 1 root root 2183662 1月 28 23:51 mysql.ibd.qp drwxr-x--- 2 root root 4096 1月 28 23:51 performance_schema drwxr-x--- 2 root root 4096 1月 28 23:51 sys -rw-r----- 1 root root 223243 1月 28 23:51 undo_001.qp -rw-r----- 1 root root 211918 1月 28 23:51 undo_002.qp -rw-r----- 1 root root 105 1月 28 23:51 xtrabackup_binlog_info.qp -rw-r----- 1 root root 95 1月 28 23:51 xtrabackup_checkpoints -rw-r----- 1 root root 540 1月 28 23:51 xtrabackup_info.qp -rw-r----- 1 root root 509 1月 28 23:51 xtrabackup_logfile.qp -rw-r----- 1 root root 130 1月 28 23:51 xtrabackup_tablespaces.qp [root@localhost Full_mysql8020_2021-01-28-23-51-49]# cd bookstore/ [root@localhost bookstore]# ll 总用量 24 -rw-r----- 1 root root 5729 1月 28 23:51 books2.ibd.qp -rw-r----- 1 root root 4026 1月 28 23:51 books3.ibd.qp -rw-r----- 1 root root 4022 1月 28 23:51 books4.ibd.qp -rw-r----- 1 root root 7000 1月 28 23:51 books.ibd.qp
最后解压参数是 --decompress 压缩算法 默认的是quicklz
--compress[=name] Compress individual backup files using the specified
compression algorithm. Supported algorithms are 'quicklz'
and 'lz4'. The default algorithm is 'quicklz'.
查看更多关于MYSQL xtrabackup 全量压缩备份的详细内容...
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did162072