You use the VMware Data Services Manager 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 VMware Data Services Manager 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
Namespace The Namespace that will be used to provision the database. None
Database Engine The database engine of the database. Choices are MySQL, PostgreSQL, and Microsoft SQL Server. None
Database Version The version of the database. The newest published VMware Data Services Manager template version of the database.
VM Name The database VM name; this name must be unique within a VMware Data Services Manager installation. An auto-generated database VM name of the format VMware‑<dbengine>‑<dbversion>‑<buildnum>.
Database Name The name of the database. dbaas
Database Port No The port number on which the database server runs. 5432
Admin Username The administrator username for the database. dbaas
Admin Password The administrator password for the database. Not applicable
Tags Tags associated with the database. None

vCPU, Memory and Storage

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, Cluster and Maintenance Configuration

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 add or remove cluster nodes for the database.

Monitoring Management

The level of monitoring that VMware Data Services Manager performs on a database is either 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).

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
Enable Automated Backups You can opt-in or opt-out of automated backups. If you opt-in for automated backups, you have to set the Daily Backup Time, Local Backup Retention, and Cloud Backup Retention. On
Daily Backup Time The time of day to back up the database. 01 hours and 00 minutes.
Local Backup Retention The number of days to retain a backup on local storage. 7 days
Cloud 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
Enable Auto Minor Version Upgrade You can opt-in or opt-out of automatic upgrade to the next minor versions during the maintenance window that you configure. On
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

DB Cluster Settings

In the DB Cluster Settings section, you can add or remove Replica databases of the Primary database that you are creating and set the following properties in the table:

Property Name Description Default Value
Replica VM Name Name of the Replica database. None
Namespace Namespace for the Replica database. None
Sync Synchronized Replica database is created. Sync
Candidate Priority The candidate priority for the Replica database. 50
Cluster IP (only for MySQL database) The IP address for the database cluster. None

Alert Set, SMTP, and Webhook

In this section you can select the alert set for the database. Based on the alert set you select, the thresholds for alerts are set. In this section, you also select the webhooks for the database that decide the notification points of the alerts for any status change or operation failure of the database.

TLS and Others

In this section you can set TLS requirements and other database options.

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:

check-circle-line exclamation-circle-line close-line
Scroll to top icon