You use the VMware Data Services Manager console to provision a database on a vSphere cluster.
When you configure a database for provisioning, you specify:
- The database engine type, number of replicas, and version.
- The amount of CPU, memory, and storage resources to allot to the database.
- Backup and maintenance parameters.
- Database-engine-specific runtime properties.
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.
Prerequisites
Before you provision a database, ensure that you can identify:
- The host name or IP address of the VMware Data Services Manager console.
- Appropriate credentials for the VMware Data Services Manager console.
- The vSphere environment that represents the cluster on which you will provision the database.
- Infrastructure policies and other resources configured for the database VM.
- The network on which client applications will access the database.
You must perform this task on a host that has network connectivity to the VMware Data Services Manager console. To connect to the VMware Data Services Manager console, see Accessing the VMware Data Services Manager Console.
Other Considerations
Also consider and be prepared to identify:
- The database engine type that you want to provision, and the version.
- The amount of CPU, memory, and disk resources you want to allot to the database.
- Topology to use for the database.
- Which of the backup and maintenance window management policies you wish to opt-in to, and under what schedule.
Configure the Database in VMware Data Services Manager
When you configure a database VMware Data Services Manager, you must identify such values as the database engine type and version, a name for the database, and infrastructure policies to associate with the database.
The Database Configuration Reference describes each of the database configuration properties and provides the default value for each.
Procedure
Monitor Database Creation
Monitor the status of the database creation and provisioning operation in the Operations view.
Procedure
- Click Operations in the left navigation pane of the console.
- Locate the CREATE DATABASE CLUSTER operation type and check its status.
Results
If VMware Data Services Manager encounters an error when provisioning the database, the Operations view Status for the CREATE DATABASE CLUSTER operation displays FAILED.
When VMware Data Services Manager successfully provisions a database, the Status for the CREATE DATABASE CLUSTER operation displays SUCCESS, and the Databases view Status for the database is READY.
Additionally, VMware Data Services Manager automatically takes a full backup of the database.
What to do next
You successfully created and provisioned a database. Next, you can perform one of these tasks:
Connect to the database. See Connecting to a Database.
Examine database operations and alerts. See Monitoring Databases from the VMware Data Services Manager Console.