You use the Data Management for VMware Tanzu console, Databases view, to create a database Service Instance 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 Service Instance.
| Property Name | Description | Default Value |
|---|---|---|
| Database | The type of database engine to provision; choices are MySQL or PostgreSQL. | None |
| Instance Name | The database Service Instance name; this name must be unique within a Data Management for VMware Tanzu installation. | An auto-generated instance name of the format VMware‑<dbengine>‑<dbversion>‑<buildnum>. |
| Environment | The vSphere environment representing a specific Onboarded Cluster. | The first name in an alphabetically-ordered list of vCenter IP-Cluster names. |
| Database Version | The version of the database. | The newest published Data Management for VMware Tanzu template version of the database. |
vCPU, Memory and Storage Configuration
These properties specify the amount of compute and disk resources to allot to the database Service Instance. 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 Service Instance. | 2 cores |
| Memory | The amount of memory to allocate to the database Service Instance. | 4GB |
| vCPU & Memory | The predefined combination of vCPU and memory settings to allocate to the database Service Instance. | The plan that utilizes the lowest resources (vCPU, memory). |
| Storage | The amount of virtual disk space (GBs) to allocate to the database Service Instance. | 20GB |
Monitoring and Backup
Use these properties to identify the level of monitoring for the database Service Instance, and to opt the instance in or out of certain database management policies.
| Property Name | Description | Default Value |
|---|---|---|
| Monitoring Type | The level of monitoring that Data Management for VMware Tanzu performs on the database Service Instance; 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). | NORMAL |
| Enable Data Protection | The switch to enable or disable automated database backups. | On |
| Enable Auto Minor Version Upgrade | The switch to enable or disable automated minor version database software updates to the database Service Instance. | On |
| Customize Maintenance Window | The switch to enable or disable customizing the default maintenance window for the database Service Instance. | On |
Database Instance, 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 Instance Configuration
The properties in this pane identify database connection parameters. The default values are specific to the type of database engine that you are provisioning.
| Property Name | Description | Default Value |
|---|---|---|
| Database Name | The name of the default database. | PostgreSQL, MySQL |
| Database Port No | The port number on which the database server runs. (Read-only) | PostgreSQL, MySQL |
| Admin Username | The database administrator username. | PostgreSQL, MySQL |
| Admin Password | The password for the database adminstrator. | PostgreSQL, MySQL |
Environment Configuration
The properties in this pane identify the vSphere disk and network configuration.
| Property Name | Description | Default Value |
|---|---|---|
| VM Datastore | The VM datastore configuration. | The datastore selected when the Environment cluster was onboarded. |
| Application Network | The network on which client applications will access the database Service Instance. | The Application Network selected when the Environment cluster was onboarded. |
Backup Configuration
These properties specify the backup schedule and retention periods, and are configurable only when automated backups are enabled for the database Service Instance (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 Days | The number of days to retain a backup on local storage. | 7 days |
| Remote Backup Days | 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 Service Instance. Software updates are applied in this window when Customize Maintenance Window and Enable Auto Minor Version Upgrade are on.
| 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 |
When Customize Maintenance Window is off and Enable Auto Minor Version Upgrade is on, software updates are applied in the default maintenance window.
TLS Configuration
This property configures the TLS requirements for database clients.
| Property Name | Description | Default Value |
|---|---|---|
| Require Client TLS | The switch to enable/disable TLS. | off |
DB Options Configuration
The database options properties specify runtime configuration settings for the database, and are engine-specific:
