Configuring Database Options

Many databases provide configuration parameters that you can set to affect the behavior of the system.

Data Management for VMware Tanzu exposes a pre-defined set of MySQL and PostgreSQL server configuration parameters, and in some cases provides custom default values. You can set these parameters when you create a database, or at any time after database provisioning as described in the procedure below.

Note:

• Changing certain database parameters may require a reboot of the database.
• You can edit database options only when the database is in ONLINE, WARNING, CRITICAL, or FATAL status.

Prerequisites

Before you configure the database parameters of a databasee, ensure that you can:

• Identify the configuration parameter(s) that you want to change, as well as the new value(s). Refer to the database-specific documentation for more information on the parameters that you can set:
  • MySQL DB Options Configuration
  • PostgreSQL DB Options Configuration
• Identify whether or not a restart is required for the parameter; if so, consider waiting until the maintenance window of the database to make the change.

Procedure

Perform the following procedure to configure engine-specific database options for a database:

1. Select Databases from the left navigation pane.

   This action displays the Databases view, a table that lists the provisioned databases.

2. Examine the databases listed in the table, identify the database for which you want to update database options, and navigate to that table row.

3. Click the database VM Name.

   The database information Details tab displays.

4. Locate the Server Information section of the pane, and click EDIT.

   The Change Database Options dialog displays.

5. Configure/set the desired parameters for the database.

   Note: If you want to set a parameter to the database server default, you must remove/clear the entry.

6. Click SAVE.

   Data Management for VMware Tanzu initiates the task, generating an operation of type CHANGE_DB_OPTIONS.

7. Monitor the progress of the task in the Operations tab or in the DB Operations view:

   1. Locate the CHANGE_DB_OPTIONS operation type and click it.
   2. Select the State History tab to view the subtasks and their status.
   3. If the operation fails, select the Error Info tab to examine the returned error information.