Previous Topic: Managing AuthMinder Server Logging ConfigurationsNext Topic: Reading Instance Timestamp Details

CA AuthMinder Administration Guide › Managing AuthMinder Server Instances › Setting Up Server Instances › Configuring Database Parameters

Configuring Database Parameters

AuthMinder uses connection pooling, which avoids the overhead of establishing a new database connection every time the server requires access to the database. By using the instance-specific page, you can configure these connection pooling parameters for the instance. The data displayed in the Instance Statistics (see "Monitoring Instance Statistics") page depends on the parameters configured on this page.

To change the database configuration parameters:

  1. Ensure that you are logged in as the MA.
  2. Activate the Services and Server Configurations tab in the main menu.
  3. Ensure that the WebFort tab in the submenu is active.
  4. Under the Instance Configurations section, click the Instance Management link to display the WebFort Instances page.
  5. Click the required instance link in the Instance Name column.

    The Instance name: <selected_instance> page appears.

  6. Edit the fields in the Database Configurations section, as required. The following table describes the fields of this section:

Field

Description

Minimum Connections

Enter the minimum number of connections that will be created between AuthMinder Server and the database when the server starts up.

Maximum Connections

Enter the maximum number of connections that can be created between the AuthMinder Server and the database.

Note: You must set this value depending on the maximum connections that the database supports, because this overrides the MaxConnections parameter. See your database vendor documentation for more information.

Increment Connections by

Enter the number of connections that will be added to the existing connections at a time, when the need arises.

Important! The total number of connections cannot exceed the maximum number of connections.

Monitor Thread Sleep Time (in Seconds)

Enter the time for which the monitoring thread will sleep between successive heartbeat checks for all databases.

Monitor Thread Sleep Time in Fault Conditions (in Seconds)

Enter the interval at which the database monitor thread will check the health of the connection pool in case of faulty database connections.

Log Query Details

Enable this option if you want to log the details for all database queries.

Monitor Database Connectivity

Enable checking of the pools proactively in the database monitor thread.

Auto-Revert to Primary

Enable this option if you want the AuthMinder Server to switch from the backup database to the primary database when the primary database becomes available again after a failover condition.
  1. Click Save to save the changes.
  2. Refresh the AuthMinder Server instance for which you made the preceding changes. See "Refreshing a Server Instance" for instructions on how to do this.