You use the VMware Data Services Manager console to create a database in a vSphere cluster. This reference identifies the Create Database form configuration property names, descriptions, and default values.

Basic Information

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

Property Name Description Default Value
Database Engine The database engine of the database. Choices are MySQL and PostgreSQL. None
Database Version The version of the database.

The newest published VMware Data Services Manager template version of the database.

Note: Availability of template versions depends on whether your data service is enabled in full or limited preview mode. For more information, see Activate Data Services in VMware Data Services Manager.
Instance Name (PostgreSQL) or Group Name (MySQL)

The database instance name; this name must be unique within a VMware Data Services Manager installation.

 None
Replica Mode The number of nodes to create for this cluster. Select one of the following:
  • Single Server - One node with no replicas. You can use vSphere HA.

  • Single vSphere Cluster - Multiple nodes co-located on a single vSphere cluster providing node resiliency.

    A three-node topology (1 replica) is supported for all database engines.

 None
Topology Configuration for the database nodes depending on the replica mode you selected. If you selected Single Server as a replica mode, the default value is 1 (Primary + Monitor, 0 Replica). Topology of Single vSphere Clusterdepends on the type of database you are configuring.
Database Name (PostgreSQL) The name of the database. Same as Instance Name.
Admin Username (PostgreSQL) The administrator username for the database. None
Admin Password (PostgreSQL) Provide admin user password. If omitted, the system autogenerates it.
Enable Directory Service Authentication If you configured a directory service, you can activate directory service authentication. For information, see Configuring a Directory Service in VMware Data Services Manager. None
DNS Names Comma separated FQDNs. The DNS names are used in the Subject Alternative Name (SAN) fields of the TLS certificate. None

Infrastructure

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
Infrastructure Policy An infrastructure policy defines the quality and quantity of resources the database can consume from vSphere clusters. To be available for selection, infrastructure policies must be created and enabled by a vSphere administrator. None
Cluster A vSphere cluster for the database placement if you opt for a manual placement. None
Storage Policy A storage policy specifies storage placement and resources for the database VM. You must select a storage policy from the list of storage policies associated with the infrastructure policy. None
VM Class You select a VM class from the list of VM classes associated with the infrastructure policy. VM classes define the amount of vCPU and memory resources to allocate to the database. None
Disk Size Virtual disk space (GBs) to allocate to the database VM. 60 GB

Backup and Maintenance

The backup properties specify the backup location, schedule, and retention periods, and are configurable only when automated backups are enabled for the database.

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

Property Name Description Default Value
Enable Backups You can opt-in or opt-out of automated backups. If you opt-in for automated backups, you have to set the Backup Location, Backup Retention Period, and Backup Schedule. On
Backup Location Specifies the location for the backups to be stored. None
Backup Retention Specifies the number of days to retain a backup on the selected storage location. 30 days. Minimum required is 1 day.
Backup Schedule Specify if you want to use default or customized backup schedule:
  • Use Default Backup Schedule - Use the schedule provided by the system and set the start time.
  • Add Customized Backup Schedule - Specify whether you want the backup to be full or incremental. Set up the start time and the frequency of the backup.
 Default Backup Schedule
Enable Maintenance Window You can opt-in or opt-out of automatic upgrade to the next minor versions during the maintenance window that you configure. On
Day of the Week 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

Advanced Settings

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