Hi Team,
Actually my requirement is to take the backup to a remote server as the existing server has no big space.
so, I have followed the steps below:
on sending node:
sudo xtrabackup --backup --stream=xbstream | nc 10.16.125.54 9999
on receiving node:
sudo nc -l 9999 | cat - > /data/backups/backup.xbstream
Streaming of data is happening.
But the problem is after streaming of data, the sending node also backup file is getting created and then backup is being taken. I am not understanding this. I dont want to use my local storage of the sending node as there is no much space left.
221010 11:00:45 Backup created in directory ‘/home/net/xtrabackup_backupfiles/’
I am keeping the output below
221010 11:00:44 [01] Streaming ./prodrec/db.opt to
221010 11:00:44 [01] …done
221010 11:00:44 Finished backing up non-InnoDB tables and files
221010 11:00:45 [00] Streaming
221010 11:00:45 [00] …done
221010 11:00:45 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS…
xtrabackup: The latest check point (for incremental): ‘146727025732’
xtrabackup: Stopping log copying thread.
.221010 11:00:45 >> log scanned up to (146733574716)
221010 11:00:45 Executing UNLOCK TABLES
221010 11:00:45 All tables unlocked
221010 11:00:45 [00] Streaming ib_buffer_pool to
221010 11:00:45 [00] …done
221010 11:00:45 Backup created in directory ‘/home/net/xtrabackup_backupfiles/’
MySQL binlog position: filename ‘mysql-bin.000145’, position ‘58781069’
221010 11:00:45 [00] Streaming
221010 11:00:45 [00] …done
221010 11:00:45 [00] Streaming
221010 11:00:45 [00] …done
xtrabackup: Transaction log of lsn (146724264939) to (146733574716) was copied.
221010 11:00:45 completed OK!
So, what can be done.