Displaying Domain, Database, and Archive Status

Displays the NuoDB Domain consisting of admin service processes in the Servers section and database processes in the Databases section. The normal run state for an admin service process is "ACTIVE:Connected". The admin service with the "*" indicator at the end is the admin service the current nuocmd show domain command is connected to. Each admin service in the distributed system is either a Leader or Follower. Admin services are responsible for brokering application requests to the database and assigning an available Transaction Engine (TE) to process SQL requests. Database process startup request are also processed through an admin service and started under a specific admin service. Once a database process is started under an admin service it will remain associated with that admin service. If the admin service should shut down for any reason its running database processes then go into a temporary unreachable state until the admin service is restarted. When running in a container management environment such as Red Hat Openshift an admin service that shuts down unexpectedly automatically restarts in seconds.

Displays the NuoDB database processes for each database in the domain. TE and SM processes are types of database process. The normal run state for a database process is "MONITORED:RUNNING".

Displays the NuoDB Storage Manager (SM) database archives, their unique IDs, the database they serve, file location, and the storage server hosting the storage file. The normal run state for an archive is "MONITORED:RUNNING".