Innobackupex incremental backup

# Carry out the first full standby

[root@shou ~]#innobackupex --defaults-file=/usr/local/mysql/etc/my.cnf --host=127.0.0.1 --port=3306 --user=root --password=****** ./restore

# Make the first additional preparation , Based on the last full backup

[root@shou ~]#innobackupex ---defaults-file=/usr/local/mysql/etc/my.cnf --host=127.0.0.1 --port=3306 --user=root --password=****** --incremental ./restore/incer1 --incremental-basedir=./restore/2022-04-23_11-39-31

# Perform the second full backup , Based on the first additional reserve

[root@shou ~]#innobackupex ---defaults-file=/usr/local/mysql/etc/my.cnf --host=127.0.0.1 --port=3306 --user=root --password=****** --incremental ./restore/incer2 --incremental-basedir=./restore/incer1/2022-04-23_11-47-10

########################## Data consolidation during recovery ####################################################

Start backup set for consolidation —— Full backup application log , And designate "--redo-only" Indicates the start of log append

innobackupex --apply-log --use-memory=1G --redo-only ./restore/2022-04-23_11-39-31/

For the first addition set " Get ready ", Add it to the full backup set

innobackupex --apply-log --use-memory=1G --redo-only ./restore/2022-04-23_11-39-31/ --incremental-dir=./restore/incer1/2022-04-23_11-47-10/

The second addition set is " Get ready ", Add it to the full backup set , But no longer apply "--redo-only", Indicates the end point of consolidation

innobackupex --apply-log --use-memory=1G ./restore/2022-04-23_11-39-31/ --incremental-dir=./restore/incer2/2022-04-23_11-53-19/

Conduct an overall review of the integrated full set " Get ready "

innobackupex --apply-log --use-memory=1G ./restore/2022-04-23_11-39-31/

################### Data recovery #############################

innobackupex --defaults-file=/usr/local/mysql3308/etc/my.cnf --copy-back ./restore/2022-04-23_11-39-31/

############### Modify the owner group and start mysqld3308###########

chown mysql:mysql -R /usr/local/mysql3308/data && systemctl start mysqld3308