list backups [{--backupid=|-I }backup_id] [-all|-a] cluster_name
list backups [{--backupid=|-I }backup_id] [--agent|-A] site_name
如果没有该
选项,该命令将列出此 MySQL Cluster Manager 实例已知--agent
的 MySQL NDB Cluster 的所有备份
。cluster_name
输出包括备份和节点 ID 以及每个备份的 UTC 时间戳,如下所示:
mcm> list backups mycluster;
+----------+--------+---------+----------------------+---------+
| BackupId | NodeId | Host | Timestamp | Comment |
+----------+--------+---------+----------------------+---------+
| 1 | 1 | tonfisk | 2016-10-24 22:24:54Z | |
| 1 | 2 | tonfisk | 2016-10-24 22:24:54Z | |
| 2 | 1 | tonfisk | 2016-10-24 22:24:54Z | |
| 2 | 2 | tonfisk | 2016-10-24 22:24:54Z | |
+----------+--------+---------+----------------------+---------+
4 rows in set (0.02 sec)
该Timestamp
列显示出现在任何备份实例文件夹中的第一个文件的时间戳(UTC)。每个备份文件集中有 3 个文件:
*.ctl
、*.data
和
*.log
。如果备份实例文件夹为空,则显示文件夹本身的时间戳。
使用该--backupid
选项后,这些命令仅列出具有指定 ID 的备份:
mcm> list backups --backupid=2 mycluster;
+----------+--------+---------+----------------------+---------+
| BackupId | NodeId | Host | Timestamp | Comment |
+----------+--------+---------+----------------------+---------+
| 2 | 1 | tonfisk | 2016-10-24 22:24:54Z | |
| 2 | 2 | tonfisk | 2016-10-24 22:24:54Z | |
+----------+--------+---------+----------------------+---------+
2 rows in set (0.02 sec)
对于 MySQL Cluster Manager 1.4.1 及更高版本:该
使用该选项时由命令
backup cluster
列出元数据备份由备份列表中
的注释标记
list
backups
--all
Schema
mcm> list backups --all newcluster;
+----------+--------+---------+----------------------+---------+
| BackupId | NodeId | Host | Timestamp | Comment |
+----------+--------+---------+----------------------+---------+
| 1 | 1 | tonfisk | 2016-08-12 16:55:52Z | |
| 1 | 2 | tonfisk | 2016-08-12 16:55:52Z | |
| 1 | 3 | tonfisk | 2016-08-12 16:55:52Z | |
| 1 | 4 | tonfisk | 2016-08-12 16:55:52Z | |
| 1 | 50 | tonfisk | 2016-08-12 16:55:55Z | Schema |
+----------+--------+---------+----------------------+---------+
5 rows in set (0.02 sec)
有关元数据备份的详细信息,请参阅导航台表元数据的逻辑备份。
对于 MySQL Cluster Manager 1.4.6 及更高版本:使用该
--agent
选项并site_name
指定 a 时,该命令会列出为特定站点创建的代理备份:
mcm> list backups --agent mysite;
+------------+-------+---------+----------------------+---------+
| BackupId | Agent | Host | Timestamp | Comment |
+------------+-------+---------+----------------------+---------+
| 1522914101 | 0 | tonfisk | 2018-04-05 07:41:41Z | |
| 1522914105 | 0 | tonfisk | 2018-04-05 07:41:45Z | |
| 1522914121 | 0 | tonfisk | 2018-04-05 07:42:01Z | |
+------------+-------+---------+----------------------+---------+
3 rows in set (0.00 sec)
备份 ID 反映了进行备份时的 Unix Epoch 时间。
可以使用以下
--backupid
选项过滤输出:
mcm> list backups --agent --backupid=1522914121 mysite;
+------------+-------+---------+----------------------+---------+
| BackupId | Agent | Host | Timestamp | Comment |
+------------+-------+---------+----------------------+---------+
| 1522914121 | 0 | tonfisk | 2018-04-05 07:42:01Z | |
+------------+-------+---------+----------------------+---------+
1 row in set (0.07 sec)