You can restore the backup data of the JCS for Percona service to the self-built database.
mysql_backup_extract.py
, and the using instances are as follows.# View Help Manual ./mysql_backup_extract.py -h # Unzipping backup data of the JCS for Percona service instance ./mysql_backup_extract.py -v 5.7 -f ./backup.xbstream
wget -c '<Data backup download link>' -O <Customized backup file name>.xbstream -c: Start breakpoint upload -O: Save downloaded results as the assigned files and note that the suffix of files must be .xbstream
./mysql_backup_extract.py -v 5.7 -f <Customized backup file name>.xbstream -v Parameters may not be assigned, the default value is 5.7, and view the -h Help Manual for details of variables following -v.
innobackupex --defaults-file=$HOME/tmp_snapshot/backup-my.cnf --apply-log $HOME/tmp_snapshot
# The MySQL server [mysqld] innodb_checksum_algorithm=innodb #innodb_log_checksum_algorithm=strict_crc32 innodb_data_file_path=ibdata1:512M;ibdata2:512M:autoextend innodb_log_files_in_group=3 innodb_log_file_size=536870912 #innodb_fast_checksum=false #innodb_page_size=16384 #innodb_log_block_size=512 innodb_undo_directory=. innodb_undo_tablespaces=0 #redo_log_version=1
chown -R mysql:mysql $HOME/tmp_snapshot
mysqld --defaults-file=$HOME/tmp_snapshot/backup-my.cnf --user=mysql --datadir=$HOME/tmp_snapshot --socket=$HOME/tmp_snapshot/mysql.sock &
mysql -uroot -p --socket=$HOME/tmp_snapshot/mysql.sock