You use the Data Management for VMware Tanzu console to provision a database on an Onboarded Cluster. You can also provision a database using the Data Management for VMware Tanzu API.
When you configure a database for provisioning, you specify:
You can configure the database yourself, or you can choose to create a database using the default database configuration. In some cases, the configuration properties available and their default values vary depending upon the database engine and version that you select for provisioning.
Before you provision a database, ensure that you can identify:
You must perform this task on a host that has network connectivity to the Data Management for VMware Tanzu console.
Also consider and be prepared to identify:
Perform the following procedure to provision a database with Data Management for VMware Tanzu.
Perform the following procedure to log in to the Data Management for VMware Tanzu console:
Open a browser window, and enter the Data Management for VMware Tanzu console URL. For example, if the service is running on a host with IP address10.10.10.11
enter:
https://10.10.10.11/login
The login screen displays.
Log in to the Data Management for VMware Tanzu console using your assigned Provider Administrator, Organization Administrator, or Organization User credentials. If this is your first time logging in, Data Management for VMware Tanzu will prompt you to change your password and re-log in.
The User Dashboard or Provider Dashboard displays. See About the User Console or About the Provider Consolefor more information about the metrics and information available on these views.
When you configure a database, you must identify the database engine type and version, the Onboarded Cluster in which to provision the database, and a name for the database. After you select or enter these values, you can choose to configure the individual database settings yourself, or you can 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.
Perform these steps to configure the database:
Click Databases in the left navigation pane of the console.
The Databases view opens. This page displays a list of the provisioned databases, and provides information about the database engine type, version, and environment, as well as the status of each database.
Click the CREATE DB button located in the upper right-hand corner of the view.
This action displays the Create Database form, and automatically expands the Select Database [Database and Version] configuration pane.
You identify the database engine type, name the database, and identify the Onboarded Cluster vSphere environment and the database version by setting or selecting values for these properties:
Property Name | Value |
---|---|
Database | Choose either MySQL, PostgreSQL, or SQL Server. |
Database Version | Use the dropdown menu to select from the available template versions of the database. |
VM Name | Enter a unique name for this database VM, or retain the default name. |
Namespace | Use the dropdown menu to select the Namespace that will be used to provision the database. |
Tags | Select one or more tags from the list of created tags or type the name of a new tag, and then click the Create New Tag button that appears below the dropdown menu. |
You must set or select a value for each property identified above.
At this point, you either choose to create the database with the default configuration, or you can configure the individual database settings yourself.
If you choose to create the database with the default configuration, click CREATE DB WITH DEFAULT CONFIGURATION, and skip ahead to Monitoring Database Creation.
Note: When you create a database with the default configuration, Data Management for VMware Tanzu uses default values for certain database-specific configuration parameters. Refer to:
for more information about these settings. (You can change these settings after database deployment as described in Changing Database Options.)
If you choose to configure the database settings yourself, continue on to the next step.
Click VM SETTINGS to expand the Resource Configuration [vCPU, Memory and Storage Configuration] pane, and then use the sliders or enter the values to set the vCPU (Cores), Memory (GBs), and Storage (GBs) size settings that best represent your database resource requirements.
Click MANAGEMENT SETTINGS to expand the Management Configuration [Monitoring, Backup, and Notifications] pane. You configure these properties to select the level of monitoring Data Management for VMware Tanzu performs on the database, to opt in or opt out of certain database management and backup policies, and to enable or disable email notifications for database. (You configure the rules for each opted-in policy in the next step.)
In the Database Management section, select the monitoring level, and opt in or out of management policies as desired:
Property Name | Value | Default |
---|---|---|
Monitoring Type | Use the slider to choose either NORMAL or ENHANCED monitoring. | ENHANCED |
Enable Automated Backups | Click the checkbox to enable or disable automated database backups. | Selected |
Enable Auto Minor Version Upgrade | Click the checkbox to enable or disable automated minor version software updates to the database. | Selected |
In the Email Notification section, select the configuration of email notifications for status change of the database and operation failure of the database, as desired:
Property Name | Value | Default |
---|---|---|
Email Address | Email ID of the owner of the database. | Email ID of the owner of the database. |
Emails for Database Status Change | Click the checkbox to enable or disable email notification to notify change of status of the database to WARNING, CRITICAL, LOST CONNECTIVITY, or FATAL. | Selected |
Emails for Database Operation Failure | Click the checkbox to enable or disable email notification to notify any operation failure of the databasee. | Seected |
Click ADDITIONAL SETTINGS to expand the Additional Configuration [Database, Environment & Backup Configuration] pane. Several configuration categories are represented in this pane, and certain categories will be present only if you opted-in to the related management policy in MANAGEMENT SETTINGS.
Database Configuration - Configure the default database, server port number and administrator credentials for the database.
Set these properties for your database:
Property Name | Value |
---|---|
Database Name | The name of the database. |
Database Port No | The port number on which the database server runs. (Read-only) |
Username | The database administrator user name. |
Password | The password for the database adminstrator. |
Backup Configuration - Configure the backup schedule and retention policies for the database if you opted in to Enable Automated Backups.
Set or select each property value as specified:
Property Name | Value |
---|---|
Daily Backup Time | Use the dropdown menus to select the time of day to back up the database. |
Local Backup Retention | Use the dropdown menu to specify the number of days to retain a backup on local storage. |
Remote Backup Retention | Use the dropdown menu to specify the number of days to retain a backup on cloud/remote storage. |
Maintenance Configuration - Configure the maintenance window for software updates for the database.
Set or select each property value as specified:
Property Name | Value |
---|---|
Start Day | Use the dropdown menus to select the maintenance window day of the week. |
Start Time | Use the dropdown menus to select the time of day in which to start the maintenance window. |
Duration | Use the dropdown menu to specify the duration of the maintenance window (hours). |
TLS Configuration - Configure the TLS requirements for database clients.
If you want the database to reject non-secure connections and require Transport Layer Security certificate verification for clients, enable by clicking the Require Client TLS checkbox.
DB Options Configuration - Configure database engine-specific options:
Click SUMMARY to review the configuration of your database.
Finally, click CREATE DATABASE in the bottom left of the Summary pane to create and provision the database.
Data Management for VMware Tanzu generates a management operation of type CREATE_DB.
Monitor the status of the database creation and provisioning operation in the Operations view:
If Data Management for VMware Tanzu encounters an error when provisioning the database, the Operations view Status for the CREATE DB operation displays FAILED, and error information is returned in the Error Info tab.
When Data Management for VMware Tanzu successfully provisions a database, the Operations view Status for the CREATE DB operation displays SUCCESS, and the Databases view Status for the database is ONLINE. Additionally, Data Management for VMware Tanzu automatically takes a full local and cloud backup of the database. As described in the monitoring section above, you can similarly examine the BACKUP DB operation details.
You successfully created and provisioned a database. Next, you may want to: