Databases
Databases is a standard configuration interface for maintaining the various database servers and the database connection information that can be used by Unified Assurance. The redundant database settings will also be available in this interface after running the RedundancyWizard. Other external database connection information can also be stored for use in the Query Tools interface, and in other interfaces as well.
Refer to the Standard Configuration Interface guide for details on interacting with the grid and form.
This user interface calls REST methods from api/database/databases.
The UI path for this interface is Configuration -> Databases -> Databases.
Grid Details
-
State - Database state is based on the states reported by the DatabaseWatchdog. Possible states are:
-
Unknown - State not yet checked by DatabaseWatchdog, or the database type can not be connected to using the watchdog. Unified Assurance applications will attempt to use.
Note:
If DatabaseWatchdog is not running, all states will be reported as Unknown.
-
Running - Database is reported up. Unified Assurance applications will attempt to use.
-
Stopped - Database is reported as down or disabled. Unified Assurance applications will NOT attempt to use.
-
Re-syncing - Database is reported up but re-syncing. Unified Assurance applications will NOT attempt to use it. Only applicable for mysql type databases in redundant environment.
-
Form Fields
-
Name - The name of the database.
-
Description - The description of the database.
-
Shard # - The database shard identifier.
-
Failover Type - An indicator of whether the database is the primary or backup database.
-
Type - The type of database.
-
Schema Name - Which database schema to use.
-
Host FQDN - The FQDN of the database server.
-
Port (tcp) - The TCP Port for the database connection.
-
Timeout (secs) - The timeout for the database connection, in seconds.
-
Username - The username used for database authentication.
-
Password - The password used for database authentication.
-
Confirm - Confirm the password used for database authentication.
-
Status - The status of the database. Disabled prevents any Unified Assurance application from utilizing.
Best Practice
Database entries are uniquely identified by Schema Name, Failover Type and Database Shard. i.e. there cannot be two primary, shard 1, databases of the same schema name.