Database Configuration Reference

You use the Data Management for VMware Tanzu console, Databases view, to create a database in an Onboarded Cluster.

After you select the database engine type and version and the vSphere environment on the Create Database form, you can either choose to configure the database yourself, or choose to invoke the Data Management for VMware Tanzu quick create, a single-click action that creates the database for you using the default configuration.

This reference identifies the Create Database form configuration property names, descriptions, and default values.

Database and Version

These properties specify the minimum information required to provision a database.

Property Name	Description	Default Value
Database	The type of database engine to provision; choices are MySQL or PostgreSQL.	None
Database Version	The version of the database.	The newest published Data Management for VMware Tanzu template version of the database.
VM Name	The database VM name; this name must be unique within a Data Management for VMware Tanzu installation.	An auto-generated database VM name of the format VMware‑<dbengine>‑<dbversion>‑<buildnum>.
Namespace	The Namespace that will be used to provision the database.	The first name in an alphabetically-ordered list of Namespaces.
Tags	The tags assigned to the database.	None

vCPU, Memory and Storage Configuration

These properties specify the amount of compute and disk resources to allot to the database. How you specify the vCPU and Memory properties in the UI may differ depending upon the configuration of your organization.

Property Name	Description	Default Value
vCPU	The number of virtual CPUs to allocate to the database.	4 cores
Memory	The amount of memory to allocate to the database.	16GB
Storage	The amount of virtual disk space (GBs) to allocate to the database.	60GB

Monitoring, Backup, and Notifications

Use these properties to identify the level of monitoring for the database, to opt in or opt out of certain database management and backup policies, and to activate or deactivate email notifications for database.

Database Management

The properties in this pane configure monitoring policy and backup policy parameters:

Property Name	Description	Default Value
Monitoring Type	The level of monitoring that Data Management for VMware Tanzu performs on the database; choices are NORMAL (monitors system and service uptime and number of connections) or ENHANCED (in addition to NORMAL monitoring, also reports bytes sent/received and storage usage/reads/writes/pool size).	Enhanced
Enable Automated Backups	The switch to activate or deactivate automated database backups.	On
Enable Auto Minor Version Upgrade	The switch to activate or deactivate automated minor version database software updates to the database.	On

Email Notification

The properties in this pane configure email notification parameters:

Property Name	Description	Default Value
Email Address	Email ID of the owner of the database.	Email ID of the owner of the database.
Emails for Database Status Change	The switch to activate or deactivate email notification to notify change of status of the database to WARNING, CRITICAL, LOST CONNECTIVITY, or FATAL.	On
Emails for Database Operation Failure	The switch to activate or deactivate email notification to notify any operation failure of the database.	On

Database, Environment & Backup Configuration

Several configuration categories are represented in this pane of the Create Database form, and certain categories will be present only if you opted-in to the related management policy in Monitoring and Backup.

Database Configuration

The properties in this pane identify database connection parameters.

Property Name	Description
Database Name	The name of the default database.
Database Port No	The port number on which the database server runs. (Read-only)
Username	The database administrator username.
Password	The password for the database adminstrator.

Backup Configuration

These properties specify the backup schedule and retention periods, and are configurable only when automated backups are enabled for the database (Enable Data Protection is on).

Property Name	Description	Default Value
Daily Backup Time	The time of day to back up the database.	1:00
Local Backup Retention	The number of days to retain a backup on local storage.	7 days
Remote Backup Retention	The number of days to retain a backup on cloud/remote storage.	91 days

Maintenance Configuration

The properties in this pane configure the maintenance window for the database.

Property Name	Description	Default Value
Start Day	The maintenance window day of the week.	Saturday
Start Time	The time of day in which to start the maintenance window.	23:59
Duration	The duration of the maintenance window (hours).	6 hours

If you do not set the values to configure the maintenance window, default values are set and the maintenance window is configured as 6 hours starting each Saturday at 23:59.

TLS Configuration

This property configures the TLS requirements for database clients.

Property Name	Description	Default Value
Require Client TLS	The switch to activate or deactivate TLS.	Off

Note: The default TLS configuration does not require secure client connections.

DB Options Configuration

The database options properties specify runtime configuration settings for the database, and are engine-specific: