PXC80集群xtrabackup备份在异机恢复过程

2021年3月18日 678点热度 1人点赞 1条评论

■首先用xtrabackup做一个全量备份
xtrabackup --user=inspur --password='passwd' --backup --target-dir=/mysql/nfs/xtrabackup
■然后在异机安装配置同版本的单点PXC集群软件,略

以下在备机操作

■确认mysql服务停止
■确认my.cnf文件配置
从正式库拷贝过来,修改
以下这个参数必须有,ip为空,否则会导致无法操作数据库:
wsrep_cluster_address=gcomm://
■删除datadir所有文件
datadir=/mysql/pxc/data
cd $datadir
rm -rf *
■准备全备份的日志
xtrabackup --prepare --apply-log-only --target-dir=/mysql/nfs/xtrabackup
■准备增量备份的日志 - 未执行
xtrabackup --prepare --apply-log-only --target-dir=/mysql/nfs/xtrabackup --incremental-dir=/mysql/nfs/incrdb
■全备份准备
xtrabackup --prepare --target-dir=/mysql/nfs/xtrabackup
■拷回数据
xtrabackup -user=root --password='password' --port=3306 --copy-back --target-dir=/mysql/nfs/xtrabackup
■修改datadir及所有文件的属性为mysql:mysql
cd $datadir;cd ..;chown -R mysql:mysql data
这一步必须执行,因为拷回数据时,文件属性都是原始属性,一般不是mysql用户
■启动mysql
systemctl start mysql@bootstrap

最后可以正常打开数据库,但是此时无法查询、修改:
select * from i_oa_user limit 10;
ERROR 1047 (08S01): WSREP has not yet prepared node for application use
设置provider_options即可
SET GLOBAL wsrep_provider_options='pc.bootstrap=YES';

以下是操作过程记录,留作参考

■准备全备份的日志
xtrabackup --prepare --apply-log-only --target-dir=/mysql/nfs/xtrabackup

[root@mysqldbk:0 /mysql/nfs/xtrabackup]# xtrabackup --prepare --apply-log-only --target-dir=/mysql/nfs/xtrabackup
xtrabackup: recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksums=1 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=50331648 --innodb_page_size=16384 --innodb_undo_directory=./ --innodb_undo_tablespaces=2 --server-id=125 --innodb_log_checksums=ON --innodb_redo_log_encrypt=0 --innodb_undo_log_encrypt=0 
xtrabackup: recognized client arguments: --prepare=1 --apply-log-only=1 --target-dir=/mysql/nfs/xtrabackup 
xtrabackup version 8.0.22-15 based on MySQL server 8.0.22 Linux (x86_64) (revision id: fea8a0e)
xtrabackup: cd to /mysql/nfs/xtrabackup/
xtrabackup: This target seems to be not prepared yet.
Number of pools: 1
xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(18467564225)
xtrabackup: using the following InnoDB configuration for recovery:
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 = 1
xtrabackup:   innodb_log_file_size = 8388608
xtrabackup: using the following InnoDB configuration for recovery:
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 = 1
xtrabackup:   innodb_log_file_size = 8388608
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
PUNCH HOLE support available
Mutexes and rw_locks use GCC atomic builtins
Uses event mutexes
GCC builtin __atomic_thread_fence() is used for memory barrier
Compressed tables use zlib 1.2.11
Number of pools: 1
Using CPU crc32 instructions
Directories to scan './'
Scanning './'
Completed space ID check of 144 files.
Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M 
Completed initialization of buffer pool
page_cleaner coordinator priority: -20
page_cleaner worker priority: -20
page_cleaner worker priority: -20
page_cleaner worker priority: -20
The log sequence number 231728804 in the system tablespace does not match the log sequence number 18467564225 in the ib_logfiles!
Database was not shutdown normally!
Starting crash recovery.
Starting to parse redo log at lsn = 18467564096, whereas checkpoint_lsn = 18467564225
Doing recovery: scanned up to log sequence number 18467564255
Log background threads are being started...
Applying a batch of 1 redo log records ...
100%
Apply batch completed!
Using undo tablespace './undo_001'.
Using undo tablespace './undo_002'.
Opened 2 existing undo tablespaces.
GTID recovery trx_no: 1142849
Creating shared tablespace for temporary tables
Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
File './ibtmp1' size is now 12 MB.
Scanning temp tablespace dir:'./#innodb_temp/'
Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
8.0.22 started; log sequence number 18467564255
Allocated tablespace ID 57 for wisdom_finance_db/t_eva_base_mkt_catalog, old maximum was 0
xtrabackup: Last MySQL binlog file position 156, file name binlog.000002
xtrabackup: Recovered WSREP position: ba049e8b-7fdc-11eb-bea1-fb3dd450e591:659318
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
FTS optimize thread exiting.
Starting shutdown...
Log background threads are being closed...
Shutdown completed; log sequence number 18467564255
Number of pools: 1
210317 17:27:03 completed OK!

■全备份准备
xtrabackup --prepare --target-dir=/mysql/nfs/xtrabackup

[root@mysqldbk:0 /mysql/nfs/xtrabackup]# xtrabackup --prepare --target-dir=/mysql/nfs/xtrabackup
xtrabackup: recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksums=1 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=50331648 --innodb_page_size=16384 --innodb_undo_directory=./ --innodb_undo_tablespaces=2 --server-id=125 --innodb_log_checksums=ON --innodb_redo_log_encrypt=0 --innodb_undo_log_encrypt=0 
xtrabackup: recognized client arguments: --prepare=1 --target-dir=/mysql/nfs/xtrabackup 
xtrabackup version 8.0.22-15 based on MySQL server 8.0.22 Linux (x86_64) (revision id: fea8a0e)
xtrabackup: cd to /mysql/nfs/xtrabackup/
xtrabackup: This target seems to be already prepared with --apply-log-only.
Number of pools: 1
xtrabackup: notice: xtrabackup_logfile was already used to '--prepare'.
xtrabackup: using the following InnoDB configuration for recovery:
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
xtrabackup: using the following InnoDB configuration for recovery:
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
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
PUNCH HOLE support available
Mutexes and rw_locks use GCC atomic builtins
Uses event mutexes
GCC builtin __atomic_thread_fence() is used for memory barrier
Compressed tables use zlib 1.2.11
Number of pools: 1
Using CPU crc32 instructions
Directories to scan './'
Scanning './'
Completed space ID check of 144 files.
Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M 
Completed initialization of buffer pool
page_cleaner coordinator priority: -20
page_cleaner worker priority: -20
page_cleaner worker priority: -20
page_cleaner worker priority: -20
Creating log file ./ib_logfile101
Creating log file ./ib_logfile1
Renaming log file ./ib_logfile101 to ./ib_logfile0
New log files created, LSN=18467564556
Starting to parse redo log at lsn = 18467564556, whereas checkpoint_lsn = 18467564556
Log background threads are being started...
Applying a batch of 0 redo log records ...
Apply batch completed!
Using undo tablespace './undo_001'.
Using undo tablespace './undo_002'.
Opened 2 existing undo tablespaces.
GTID recovery trx_no: 1142849
Removed temporary tablespace data file: "ibtmp1"
Creating shared tablespace for temporary tables
Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
File './ibtmp1' size is now 12 MB.
Scanning temp tablespace dir:'./#innodb_temp/'
Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
8.0.22 started; log sequence number 18467564556
Allocated tablespace ID 57 for wisdom_finance_db/t_eva_base_mkt_catalog, old maximum was 0
xtrabackup: Last MySQL binlog file position 156, file name binlog.000002
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
FTS optimize thread exiting.
Starting shutdown...
Log background threads are being closed...
Shutdown completed; log sequence number 18467564556
Number of pools: 1
xtrabackup: using the following InnoDB configuration for recovery:
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
PUNCH HOLE support available
Mutexes and rw_locks use GCC atomic builtins
Uses event mutexes
GCC builtin __atomic_thread_fence() is used for memory barrier
Compressed tables use zlib 1.2.11
Number of pools: 1
Using CPU crc32 instructions
Directories to scan './'
Scanning './'
Completed space ID check of 144 files.
Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M 
Completed initialization of buffer pool
page_cleaner coordinator priority: -20
page_cleaner worker priority: -20
page_cleaner worker priority: -20
page_cleaner worker priority: -20
Starting to parse redo log at lsn = 18467564556, whereas checkpoint_lsn = 18467564556
Log background threads are being started...
Applying a batch of 0 redo log records ...
Apply batch completed!
Using undo tablespace './undo_001'.
Using undo tablespace './undo_002'.
Opened 2 existing undo tablespaces.
GTID recovery trx_no: 1142849
Removed temporary tablespace data file: "ibtmp1"
Creating shared tablespace for temporary tables
Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
File './ibtmp1' size is now 12 MB.
Scanning temp tablespace dir:'./#innodb_temp/'
Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
8.0.22 started; log sequence number 18467564556
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
FTS optimize thread exiting.
Trying to access missing tablespace 4294967294
Starting shutdown...
Log background threads are being closed...
Shutdown completed; log sequence number 18467564556
210317 17:30:06 completed OK!

■拷回数据
xtrabackup -user=root --password='passwd' --port=3306 --copy-back --target-dir=/mysql/nfs/xtrabackup

xtrabackup version 8.0.22-15 based on MySQL server 8.0.22 Linux (x86_64) (revision id: fea8a0e)
210317 17:35:04 [01] Copying undo_001 to /mysql/pxc/data/undo_001
210317 17:35:04 [01]        ...done
210317 17:35:04 [01] Copying undo_002 to /mysql/pxc/data/undo_002
210317 17:35:04 [01]        ...done
210317 17:35:04 [01] Copying ib_logfile0 to /mysql/pxc/data/ib_logfile0
210317 17:35:04 [01]        ...done
210317 17:35:04 [01] Copying ib_logfile1 to /mysql/pxc/data/ib_logfile1
210317 17:35:05 [01]        ...done
210317 17:35:05 [01] Copying ibdata1 to /mysql/pxc/data/ibdata1
210317 17:35:05 [01]        ...done
210317 17:35:05 [01] Copying binlog.000020 to /mysql/pxc/data/binlog.000020
210317 17:35:05 [01]        ...done
210317 17:35:05 [01] Copying binlog.index to /mysql/pxc/data/binlog.index
210317 17:35:05 [01]        ...done
210317 17:35:07 [01] Copying ./sbtest/sbtest7.ibd to /mysql/pxc/data/sbtest/sbtest7.ibd
210317 17:35:07 [01]        ...done
210317 17:35:07 [01] Copying ./sbtest/sbtest10.ibd to /mysql/pxc/data/sbtest/sbtest10.ibd
210317 17:35:07 [01]        ...done
210317 17:35:07 [01] Copying ./sbtest/sbtest9.ibd to /mysql/pxc/data/sbtest/sbtest9.ibd
210317 17:35:07 [01]        ...done
210317 17:35:07 [01] Copying ./sbtest/sbtest8.ibd to /mysql/pxc/data/sbtest/sbtest8.ibd
210317 17:35:07 [01]        ...done
210317 17:35:08 [01] Copying ./sbtest/sbtest1.ibd to /mysql/pxc/data/sbtest/sbtest1.ibd
210317 17:35:08 [01]        ...done
210317 17:35:08 [01] Copying ./sbtest/sbtest2.ibd to /mysql/pxc/data/sbtest/sbtest2.ibd
210317 17:35:08 [01]        ...done
210317 17:35:08 [01] Copying ./sbtest/sbtest5.ibd to /mysql/pxc/data/sbtest/sbtest5.ibd
210317 17:35:08 [01]        ...done
210317 17:35:08 [01] Copying ./sbtest/sbtest4.ibd to /mysql/pxc/data/sbtest/sbtest4.ibd
210317 17:35:08 [01]        ...done
210317 17:35:09 [01] Copying ./sbtest/sbtest3.ibd to /mysql/pxc/data/sbtest/sbtest3.ibd
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./sbtest/sbtest6.ibd to /mysql/pxc/data/sbtest/sbtest6.ibd
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./sys/sys_config.ibd to /mysql/pxc/data/sys/sys_config.ibd
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./mysql/wsrep_cluster.ibd to /mysql/pxc/data/mysql/wsrep_cluster.ibd
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./mysql/wsrep_cluster_members.ibd to /mysql/pxc/data/mysql/wsrep_cluster_members.ibd
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./mysql/wsrep_streaming_log.ibd to /mysql/pxc/data/mysql/wsrep_streaming_log.ibd
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./mysql/general_log_217.sdi to /mysql/pxc/data/mysql/general_log_217.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./mysql/general_log.CSV to /mysql/pxc/data/mysql/general_log.CSV
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./mysql/slow_log.CSV to /mysql/pxc/data/mysql/slow_log.CSV
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./mysql/general_log.CSM to /mysql/pxc/data/mysql/general_log.CSM
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./mysql/slow_log_218.sdi to /mysql/pxc/data/mysql/slow_log_218.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./mysql/slow_log.CSM to /mysql/pxc/data/mysql/slow_log.CSM
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./mysql.ibd to /mysql/pxc/data/mysql.ibd
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./test/db.opt to /mysql/pxc/data/test/db.opt
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/cond_instances_90.sdi to /mysql/pxc/data/performance_schema/cond_instances_90.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_waits_his_93.sdi to /mysql/pxc/data/performance_schema/events_waits_his_93.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_waits_cur_91.sdi to /mysql/pxc/data/performance_schema/events_waits_cur_91.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_waits_sum_94.sdi to /mysql/pxc/data/performance_schema/events_waits_sum_94.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_waits_sum_97.sdi to /mysql/pxc/data/performance_schema/events_waits_sum_97.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_waits_his_92.sdi to /mysql/pxc/data/performance_schema/events_waits_his_92.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_waits_sum_95.sdi to /mysql/pxc/data/performance_schema/events_waits_sum_95.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_waits_sum_96.sdi to /mysql/pxc/data/performance_schema/events_waits_sum_96.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_waits_sum_99.sdi to /mysql/pxc/data/performance_schema/events_waits_sum_99.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_waits_sum_98.sdi to /mysql/pxc/data/performance_schema/events_waits_sum_98.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/file_instances_100.sdi to /mysql/pxc/data/performance_schema/file_instances_100.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/file_summary_by__102.sdi to /mysql/pxc/data/performance_schema/file_summary_by__102.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/file_summary_by__101.sdi to /mysql/pxc/data/performance_schema/file_summary_by__101.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/host_cache_103.sdi to /mysql/pxc/data/performance_schema/host_cache_103.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/mutex_instances_104.sdi to /mysql/pxc/data/performance_schema/mutex_instances_104.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/objects_summary__105.sdi to /mysql/pxc/data/performance_schema/objects_summary__105.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/performance_time_106.sdi to /mysql/pxc/data/performance_schema/performance_time_106.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/rwlock_instances_107.sdi to /mysql/pxc/data/performance_schema/rwlock_instances_107.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/setup_objects_111.sdi to /mysql/pxc/data/performance_schema/setup_objects_111.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/setup_actors_108.sdi to /mysql/pxc/data/performance_schema/setup_actors_108.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/table_io_waits_s_113.sdi to /mysql/pxc/data/performance_schema/table_io_waits_s_113.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/setup_threads_112.sdi to /mysql/pxc/data/performance_schema/setup_threads_112.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/setup_consumers_109.sdi to /mysql/pxc/data/performance_schema/setup_consumers_109.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/table_io_waits_s_114.sdi to /mysql/pxc/data/performance_schema/table_io_waits_s_114.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/setup_instrument_110.sdi to /mysql/pxc/data/performance_schema/setup_instrument_110.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/table_lock_waits_115.sdi to /mysql/pxc/data/performance_schema/table_lock_waits_115.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/threads_116.sdi to /mysql/pxc/data/performance_schema/threads_116.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_stages_cu_117.sdi to /mysql/pxc/data/performance_schema/events_stages_cu_117.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_stages_hi_118.sdi to /mysql/pxc/data/performance_schema/events_stages_hi_118.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_stages_su_120.sdi to /mysql/pxc/data/performance_schema/events_stages_su_120.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_stages_hi_119.sdi to /mysql/pxc/data/performance_schema/events_stages_hi_119.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_stages_su_121.sdi to /mysql/pxc/data/performance_schema/events_stages_su_121.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_stages_su_123.sdi to /mysql/pxc/data/performance_schema/events_stages_su_123.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_stages_su_122.sdi to /mysql/pxc/data/performance_schema/events_stages_su_122.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_stages_su_124.sdi to /mysql/pxc/data/performance_schema/events_stages_su_124.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_statement_126.sdi to /mysql/pxc/data/performance_schema/events_statement_126.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_statement_127.sdi to /mysql/pxc/data/performance_schema/events_statement_127.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_statement_125.sdi to /mysql/pxc/data/performance_schema/events_statement_125.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_statement_128.sdi to /mysql/pxc/data/performance_schema/events_statement_128.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_statement_129.sdi to /mysql/pxc/data/performance_schema/events_statement_129.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_statement_130.sdi to /mysql/pxc/data/performance_schema/events_statement_130.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_statement_132.sdi to /mysql/pxc/data/performance_schema/events_statement_132.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_statement_131.sdi to /mysql/pxc/data/performance_schema/events_statement_131.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_statement_134.sdi to /mysql/pxc/data/performance_schema/events_statement_134.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_statement_133.sdi to /mysql/pxc/data/performance_schema/events_statement_133.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_statement_135.sdi to /mysql/pxc/data/performance_schema/events_statement_135.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_statement_136.sdi to /mysql/pxc/data/performance_schema/events_statement_136.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_transacti_137.sdi to /mysql/pxc/data/performance_schema/events_transacti_137.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_transacti_141.sdi to /mysql/pxc/data/performance_schema/events_transacti_141.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_transacti_139.sdi to /mysql/pxc/data/performance_schema/events_transacti_139.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_transacti_138.sdi to /mysql/pxc/data/performance_schema/events_transacti_138.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_transacti_140.sdi to /mysql/pxc/data/performance_schema/events_transacti_140.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_transacti_142.sdi to /mysql/pxc/data/performance_schema/events_transacti_142.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_transacti_143.sdi to /mysql/pxc/data/performance_schema/events_transacti_143.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_transacti_144.sdi to /mysql/pxc/data/performance_schema/events_transacti_144.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_errors_su_145.sdi to /mysql/pxc/data/performance_schema/events_errors_su_145.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_errors_su_149.sdi to /mysql/pxc/data/performance_schema/events_errors_su_149.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_errors_su_147.sdi to /mysql/pxc/data/performance_schema/events_errors_su_147.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_errors_su_148.sdi to /mysql/pxc/data/performance_schema/events_errors_su_148.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/events_errors_su_146.sdi to /mysql/pxc/data/performance_schema/events_errors_su_146.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/users_150.sdi to /mysql/pxc/data/performance_schema/users_150.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/hosts_152.sdi to /mysql/pxc/data/performance_schema/hosts_152.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/accounts_151.sdi to /mysql/pxc/data/performance_schema/accounts_151.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/socket_instances_153.sdi to /mysql/pxc/data/performance_schema/socket_instances_153.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/socket_summary_b_154.sdi to /mysql/pxc/data/performance_schema/socket_summary_b_154.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/session_connect__156.sdi to /mysql/pxc/data/performance_schema/session_connect__156.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/socket_summary_b_155.sdi to /mysql/pxc/data/performance_schema/socket_summary_b_155.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/session_account__157.sdi to /mysql/pxc/data/performance_schema/session_account__157.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/keyring_keys_158.sdi to /mysql/pxc/data/performance_schema/keyring_keys_158.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/memory_summary_g_159.sdi to /mysql/pxc/data/performance_schema/memory_summary_g_159.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/memory_summary_b_160.sdi to /mysql/pxc/data/performance_schema/memory_summary_b_160.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/memory_summary_b_161.sdi to /mysql/pxc/data/performance_schema/memory_summary_b_161.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/metadata_locks_165.sdi to /mysql/pxc/data/performance_schema/metadata_locks_165.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/memory_summary_b_163.sdi to /mysql/pxc/data/performance_schema/memory_summary_b_163.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/memory_summary_b_162.sdi to /mysql/pxc/data/performance_schema/memory_summary_b_162.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/table_handles_164.sdi to /mysql/pxc/data/performance_schema/table_handles_164.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/data_locks_166.sdi to /mysql/pxc/data/performance_schema/data_locks_166.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/data_lock_waits_167.sdi to /mysql/pxc/data/performance_schema/data_lock_waits_167.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/replication_appl_171.sdi to /mysql/pxc/data/performance_schema/replication_appl_171.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/replication_conn_168.sdi to /mysql/pxc/data/performance_schema/replication_conn_168.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/replication_conn_170.sdi to /mysql/pxc/data/performance_schema/replication_conn_170.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/replication_appl_172.sdi to /mysql/pxc/data/performance_schema/replication_appl_172.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/replication_grou_169.sdi to /mysql/pxc/data/performance_schema/replication_grou_169.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/replication_appl_173.sdi to /mysql/pxc/data/performance_schema/replication_appl_173.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/replication_appl_176.sdi to /mysql/pxc/data/performance_schema/replication_appl_176.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/replication_appl_174.sdi to /mysql/pxc/data/performance_schema/replication_appl_174.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/replication_grou_175.sdi to /mysql/pxc/data/performance_schema/replication_grou_175.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/log_status_178.sdi to /mysql/pxc/data/performance_schema/log_status_178.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/replication_appl_177.sdi to /mysql/pxc/data/performance_schema/replication_appl_177.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/prepared_stateme_179.sdi to /mysql/pxc/data/performance_schema/prepared_stateme_179.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/user_variables_b_180.sdi to /mysql/pxc/data/performance_schema/user_variables_b_180.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/status_by_accoun_181.sdi to /mysql/pxc/data/performance_schema/status_by_accoun_181.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/status_by_host_182.sdi to /mysql/pxc/data/performance_schema/status_by_host_182.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/status_by_thread_183.sdi to /mysql/pxc/data/performance_schema/status_by_thread_183.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/status_by_user_184.sdi to /mysql/pxc/data/performance_schema/status_by_user_184.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/global_status_185.sdi to /mysql/pxc/data/performance_schema/global_status_185.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/session_status_186.sdi to /mysql/pxc/data/performance_schema/session_status_186.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/variables_by_thr_187.sdi to /mysql/pxc/data/performance_schema/variables_by_thr_187.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/global_variables_188.sdi to /mysql/pxc/data/performance_schema/global_variables_188.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/variables_info_190.sdi to /mysql/pxc/data/performance_schema/variables_info_190.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/binary_log_trans_193.sdi to /mysql/pxc/data/performance_schema/binary_log_trans_193.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/persisted_variab_191.sdi to /mysql/pxc/data/performance_schema/persisted_variab_191.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/user_defined_fun_192.sdi to /mysql/pxc/data/performance_schema/user_defined_fun_192.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/tls_channel_stat_194.sdi to /mysql/pxc/data/performance_schema/tls_channel_stat_194.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/session_variable_189.sdi to /mysql/pxc/data/performance_schema/session_variable_189.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./performance_schema/pxc_cluster_view_195.sdi to /mysql/pxc/data/performance_schema/pxc_cluster_view_195.sdi
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./ib_buffer_pool to /mysql/pxc/data/ib_buffer_pool
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./xtrabackup_info to /mysql/pxc/data/xtrabackup_info
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./xtrabackup_binlog_pos_innodb to /mysql/pxc/data/xtrabackup_binlog_pos_innodb
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./xtrabackup_master_key_id to /mysql/pxc/data/xtrabackup_master_key_id
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./xtrabackup_galera_info to /mysql/pxc/data/xtrabackup_galera_info
210317 17:35:09 [01]        ...done
210317 17:35:09 [01] Copying ./ibtmp1 to /mysql/pxc/data/ibtmp1
210317 17:35:09 [01]        ...done
210317 17:35:10 [01] Creating directory ./#innodb_temp
210317 17:35:10 [01] ...done.
210317 17:35:10 completed OK!

liking

我是雪人

文章评论

  • liking

    注意,如果在同一个文件系统copy-back,强烈建议改为使用--move-back,move操作相比copy操作会大大缩短恢复时间!

    2021年12月8日