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 Service Instance, or at any time after Service Instance provisioning as described in the procedure below.
Before you configure the database parameters of a Service Instance, ensure that you can:
Perform the following procedure to configure engine-specific database options for a Service Instance:
Select Databases from the left navigation pane.
This action displays the Databases view, a table that lists the provisioned database instances.
Examine the databases listed in the table, identify the instance for which you want to update database options, and navigate to that table row.
Click the database Instance Name.
The database information Details tab displays.
Locate the Server Information section of the pane, and click EDIT.
The Change Database Options dialog displays.
Configure/set the desired parameters for the database.
Click SAVE.
Data Management for VMware Tanzu initiates the task, generating an operation of type CHANGE_DB_OPTIONS.
Monitor the progress of the task in the Operations tab or in the DB Operations view: