To view the status of each MySQL HeatWave node:

mysql> SELECT ID, STATUS 
          FROM performance_schema.rpd_nodes;
+----+---------------+
| ID | STATUS        |
+----+---------------+
|  0 | AVAIL_RNSTATE |
|  1 | AVAIL_RNSTATE |
+----+---------------+

For column descriptions, see Section 8.1.6, “The rpd_nodes Table”.