Skip to content

Databases

Databases is a standard configuration interface for maintaining the various database servers and the database connection information that can be used by Assure1. The redundant database settings will also be available in this interface after the RedundancyWizard has been executed. 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. Assure1 applications will attempt to use.

      Note

      If DatabaseWatchdog is not running, all states will be reported as Unknown.

    • Running - Database is reported up. Assure1 applications will attempt to use.

    • Stopped - Database is reported as down or disabled. Assure1 applications will NOT attempt to use.

    • Re-syncing - Database is reported up but re-syncing. Assure1 applications will NOT attempt to use it. Only applicable for mysql type databases in redundant environment.

Form Fields

  • Database Name - The name of the database.

  • Description - The description of the database.

  • Database Shard - The database shard identifier.

  • Failover Type - An indicator of whether the database is the primary or backup database.

  • 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 Assure1 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.

Meta

Default Databases

  • Primary Assure1 Management Database on [Server Name]

  • Primary Graph Database on [Server Name]

  • Primary Metric Database on [Server Name]

  • Primary Real-time Event Database on [Server Name]