5.7.2 The list certs Command

list certs [--active|-A] [--all|-a] [--retired|-r] cluster_name

The command lists the files created by the create certs command for the MySQL NDB Cluster named cluster_name. By default, it shows for each host the number of active, retired, and pending certificates, as well as the total number of certificates:

mcm> list certs mycluster;
+---------+--------+---------+---------+-------+
| Host    | Active | Retired | Pending | Total |
+---------+--------+---------+---------+-------+
| tonfisk | 8      | 1       | 0       | 9     |
| flundra | 6      | 1       | 0       | 7     |
+---------+--------+---------+---------+-------+

With the --active option, the command shows the active certificates found on each host, listing the last-modification timestamp, full path, and filename for each certificate:

mcm> list certs --active mycluster;
+---------+----------------------+-------------------------------------------------------------------+
| Host    | Timestamp            | File                                                              |
+---------+----------------------+-------------------------------------------------------------------+
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/NDB-Cluster-cert           |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/NDB-Cluster-private-key    |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/ndb-api-cert               |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/ndb-api-private-key        |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/ndb-data-node-cert         |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/ndb-data-node-private-key  |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/ndb-mgm-server-cert        |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/ndb-mgm-server-private-key |
| flundra | 2024-09-25 11:59:11Z | /opt/mcm_data/clusters/mycluster/certs/NDB-Cluster-cert           |
| flundra | 2024-09-25 11:59:11Z | /opt/mcm_data/clusters/mycluster/certs/NDB-Cluster-private-key    |
| flundra | 2024-09-25 11:59:11Z | /opt/mcm_data/clusters/mycluster/certs/ndb-api-private-key        |
| flundra | 2024-09-25 11:59:11Z | /opt/mcm_data/clusters/mycluster/certs/ndb-api-cert               |
| flundra | 2024-09-25 11:59:13Z | /opt/mcm_data/clusters/mycluster/certs/ndb-data-node-private-key  |
| flundra | 2024-09-25 11:59:13Z | /opt/mcm_data/clusters/mycluster/certs/ndb-data-node-cert         |
+---------+----------------------+-------------------------------------------------------------------+

With the --retired option, the command shows the same information for the retired certificates found on each host:

mcm> list certs --retired mycluster;
+---------+----------------------+-------------------------------------------------------------------+
| Host    | Timestamp            | File                                                              |
+---------+----------------------+-------------------------------------------------------------------+
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/ndb-data-node-retired-cert |
| flundra | 2024-10-23 14:05:57Z | /opt/mcm_data/clusters/mycluster/certs/ndb-data-node-retired-cert |
+---------+----------------------+-------------------------------------------------------------------+

With the --all option, the command shows the active, retired, and pending certificates found on each host:

mcm> list certs --all mycluster;
+---------+----------------------+-------------------------------------------------------------------+
| Host    | Timestamp            | File                                                              |
+---------+----------------------+-------------------------------------------------------------------+
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/NDB-Cluster-cert           |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/NDB-Cluster-private-key    |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/ndb-api-cert               |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/ndb-api-private-key        |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/ndb-data-node-cert         |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/ndb-data-node-private-key  |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/ndb-data-node-retired-cert |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/ndb-mgm-server-cert        |
| tonfisk | 2024-11-05 13:05:06Z | /opt/mcm_data/clusters/mycluster/certs/ndb-mgm-server-private-key |
| flundra | 2024-09-25 11:59:11Z | /opt/mcm_data/clusters/mycluster/certs/NDB-Cluster-cert           |
| flundra | 2024-09-25 11:59:11Z | /opt/mcm_data/clusters/mycluster/certs/NDB-Cluster-private-key    |
| flundra | 2024-09-25 11:59:11Z | /opt/mcm_data/clusters/mycluster/certs/ndb-api-cert               |
| flundra | 2024-09-25 11:59:11Z | /opt/mcm_data/clusters/mycluster/certs/ndb-api-private-key        |
| flundra | 2024-09-25 11:59:13Z | /opt/mcm_data/clusters/mycluster/certs/ndb-data-node-cert         |
| flundra | 2024-09-25 11:59:13Z | /opt/mcm_data/clusters/mycluster/certs/ndb-data-node-private-key  |
| flundra | 2024-10-23 14:05:57Z | /opt/mcm_data/clusters/mycluster/certs/ndb-data-node-retired-cert |
+---------+----------------------+-------------------------------------------------------------------+