Managing Backups
vtctldclient provides two commands for managing backups:
GetBackups displays the existing backups for a keyspace/shard in chronological order.
vtctldclient --server=<vtctld_host>:<vtctld_port> GetBackups <keyspace/shard>
RemoveBackup deletes a specified backup for a keyspace/shard.
vtctldclient --server=<vtctld_host>:<vtctld_port> RemoveBackup <keyspace/shard> <backup name>
You can also confirm your backup finished by viewing the files in your configured --<engine>_backup_storage_root
location. You will still need to test and verify these backups for completeness. Note that backups are stored by keyspace and shard under --<engine>_backup_storage_root
. For example, when using --file_backup_storage_root=/vt/vtdataroot/backups
:
/vt/vtdataroot/backups/commerce/0/2021-03-10.205419.zone1-0000000102:
backup.xbstream.gz MANIFEST
Each backup contains a manifest file with general information about the backup:
MySQL 8.0 xbstream Manifest
{
"BackupMethod": "xtrabackup",
"Position": "MySQL56/c022ad67-81fc-11eb-aa0e-1c1bb572885f:1-50",
"BackupTime": "2021-03-11T00:01:37Z",
"FinishedTime": "2021-03-11T00:01:42Z",
"FileName": "backup.xbstream.gz",
"ExtraCommandLineParams": "--no-server-version-check",
"StreamMode": "xbstream",
"NumStripes": 0,
"StripeBlockSize": 102400,
"SkipCompress": false
}
Managing Backups