MySQL5.7热备份-xtrabackup

zcl_ccc

[root@Master_test bin]# ./innobackupex  --defaults-file=/etc/my.cnf --user=root --password=root /bak　　180707 01:28:04 innobackupex: Starting the backup operation
　　IMPORTANT: Please check that the backup run completes successfully.
　　At the end of a successful backup run innobackupex
　　prints "completed OK!".
　　180707 01:28:04  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).
　　Failed to connect to MySQL server as DBD::mysql module is not installed at - line 1327.
　　180707 01:28:04 Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: /tmp/mysql.sock
　　Using server version 5.7.22-log

　　./innobackupex version 2.4.9 based on MySQL server 5.7.13 Linux (x86_64) (revision>　　xtrabackup: uses posix_fadvise().
　　xtrabackup: cd to /data/mysql/mysql3306/data
　　xtrabackup: open files limit requested 65535, set to 65535
　　xtrabackup: using the following InnoDB configuration:
　　xtrabackup:   innodb_data_home_dir = .
　　xtrabackup:   innodb_data_file_path = ibdata1:1G:autoextend
　　xtrabackup:   innodb_log_group_home_dir = ./
　　xtrabackup:   innodb_log_files_in_group = 2
　　xtrabackup:   innodb_log_file_size = 1073741824
　　xtrabackup: using O_DIRECT
　　InnoDB: Number of pools: 1
　　180707 01:28:05 >> log scanned up to (2597729)
　　xtrabackup: Generating a list of tablespaces

　　InnoDB: Allocated tablespace>　　180707 01:28:05 [01] Copying ./ibdata1 to /bak/2018-07-07_01-28-04/ibdata1
　　180707 01:28:06 >> log scanned up to (2597729)
　　180707 01:28:07 >> log scanned up to (2597729)
　　180707 01:28:08 >> log scanned up to (2597729)
　　省略中间信息*****************************************************************
　　180707 01:28:45 [01] Copying ./sys/statements_with_sorting.frm to /bak/2018-07-07_01-28-04/sys/statements_with_sorting.frm
　　180707 01:28:45 [01]        ...done
　　180707 01:28:45 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /bak/2018-07-07_01-28-04/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
　　180707 01:28:45 [01]        ...done
　　180707 01:28:45 >> log scanned up to (2597729)
　　180707 01:28:45 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /bak/2018-07-07_01-28-04/sys/x@0024wait_classes_global_by_avg_latency.frm
　　180707 01:28:45 [01]        ...done
　　180707 01:28:45 Finished backing up non-InnoDB tables and files
　　180707 01:28:45 [00] Writing /bak/2018-07-07_01-28-04/xtrabackup_binlog_info
　　180707 01:28:45 [00]        ...done
　　180707 01:28:45 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
　　xtrabackup: The latest check point (for incremental): '2597720'
　　xtrabackup: Stopping log copying thread.
　　.180707 01:28:45 >> log scanned up to (2597729)
　　180707 01:28:46 Executing UNLOCK TABLES
　　180707 01:28:46 All tables unlocked
　　180707 01:28:46 [00] Copying ib_buffer_pool to /bak/2018-07-07_01-28-04/ib_buffer_pool
　　180707 01:28:46 [00]        ...done
　　180707 01:28:46 Backup created in directory '/bak/2018-07-07_01-28-04/'
　　MySQL binlog position: filename 'mybinlog.000003', position '1311', GTID of the last change 'fe259816-8122-11e8-ab02-000c29fa3266:1-6'
　　180707 01:28:46 [00] Writing /bak/2018-07-07_01-28-04/backup-my.cnf
　　180707 01:28:46 [00]        ...done
　　180707 01:28:46 [00] Writing /bak/2018-07-07_01-28-04/xtrabackup_info
　　180707 01:28:46 [00]        ...done
　　xtrabackup: Transaction log of lsn (2597720) to (2597729) was copied.
　　180707 01:28:46 completed OK!