HI Team,
I have a server running with mysql with huge db of 1 TB.
Now, I want to take full backup and incremental backup through the xtrabackup.
But I follow the direct approach of full backup, server storage is getting consumed at huge.
So,I am using below commands to perform full backup compressed.
xtrabackup --backup --stream=xbstream --compress --target-dir=./ > backup.xbstream
Now, xbstream file contains all the backup file and I can transfer this to different server and can take backup. This is fine.
Now, I need to take incremental backups after a full backup which needs to have access to base dir and the need to be reading data from main server where sql is running. How can I achieve this ?