Movatterモバイル変換

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

The command lists the files created by thecreate certs command for the MySQL NDB Cluster namedcluster_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 |+---------+----------------------+-------------------------------------------------------------------+