Xtrabackup

gistfile1.txt

# Start netcat on port 9999 on joiner
nc -l -p 9999 | xbstream -x -C .

# Start the backup from donor
innobackupex \
--compress \
--compress-threads=4 \
--parallel=4 \
--stream=xbstream . \
| nc  9999

## Prepare the backup for recovery

# Decompress the backup files and remove the compressed version
xtrabackup --target-dir=. --decompress --remove-original

# Apply the innodb redo log to the data files
xtrabackup --target-dir=. --prepare

# Modify recursively the file ownership to ensure service user owns the database assets
chown -R mysql:mysql .