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 |
DB Options Configuration
The database options properties specify runtime configuration settings for the database, and are engine-specific:
