Managing Backups

    vtctldclient provides two commands for managing backups:

    • GetBackups displays the existing backups for a keyspace/shard in chronological order.

      1. vtctldclient --server=<vtctld_host>:<vtctld_port> GetBackups <keyspace/shard>

    • RemoveBackup deletes a specified backup for a keyspace/shard.

      1. 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:

    1. /vt/vtdataroot/backups/commerce/0/2021-03-10.205419.zone1-0000000102:
    2. backup.xbstream.gz  MANIFEST

    Each backup contains a manifest file with general information about the backup:

    1. MySQL 8.0 xbstream Manifest
    2. {
    3.   "BackupMethod": "xtrabackup",
    4.   "Position": "MySQL56/c022ad67-81fc-11eb-aa0e-1c1bb572885f:1-50",
    5.   "BackupTime": "2021-03-11T00:01:37Z",
    6.   "FinishedTime": "2021-03-11T00:01:42Z",
    7.   "FileName": "backup.xbstream.gz",
    8.   "ExtraCommandLineParams": "--no-server-version-check",
    9.   "StreamMode": "xbstream",
    10.   "NumStripes": 0,
    11.   "StripeBlockSize": 102400,
    12.   "SkipCompress": false
    13. }