Data Management for VMware Tanzu – Self-Service DBaaS
Tags: vmware, configure, datamanagement, database
Published: 2021-08-19 13:08:56

---
title: Data Management for VMware Tanzu – Self-Service DBaaS
published: true
date: 2021-08-11 22:05:08 UTC
tags: VMware,Configure,DataManagement,database
canonical_url: https://veducate.co.uk/dms-self-service/?utm_source=rss&utm_medium=rss&utm_campaign=dms-self-service
---

In my [first blog post](https://veducate.co.uk/dms-tanzu-getting-started), I covered the prerequisites and how to deploy the components for the Data Management for VMware Tanzu platform.

In this blog post we will cover using this new infrastructure for Self-Service Database-as-a-Service deployment and configuration.

##### Configure Database Templates and Instance Plans

- Log into your Provider Appliance as the Provider administrator account.

The last actions to configure are publishing the database templates and configuring Instance Plans. (If you have setup your Organisation to use instance plans).

- Click Templates from the left-hand navigation pane
- Select your Template which has been sync’d from the Tanzu Net (Or repo as air-gap configuration).
- Publish the Template

[![Data Management for Tanzu - Publish Template](https://i0.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Publish-Template.jpg?resize=604%2C153&ssl=1)](https://i0.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Publish-Template.jpg?ssl=1)

- Click Instance Plans from the left-hand navigation pane
- Click “Add New Plan”
- Configure as necessary

[![](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Instance-Plans.jpg?resize=604%2C195&ssl=1)](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Instance-Plans.jpg?ssl=1)

##### Configure additional Org Users

Configuring users is the same process as previously adding an Admin user to the Org. You just select the Org User role instead. So, I won’t repeat that here.

You do also have the option to synchronise with an LDAP server as an identity provider instead of configuring local users.

##### Adding new Organisations to an existing Agent

- Click on the Infrastructure tab on the left-hand navigation pane.
- Select your Agent
- On the bottom right of the Agent’s Details pane, you can add additional organisations as needed.

[![Data Management for Tanzu - Add Organisation to existing Agent](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Add-Organisation-to-existing-Agent.jpg?resize=604%2C273&ssl=1)](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Add-Organisation-to-existing-Agent.jpg?ssl=1)

##### Creating a Service Instance (Database VM)

OK, now we are ready to consume the platform and request a Database instance to be deployed so that I can use it to store data for my application.

- Log into the Provider Appliance as an Organisation Admin or User (these screenshots will show myself using a Org User account, but the view is the same as an admin)
- Click Databases on the left-hand navigation pane, and then “Create DB”

[![Data Management for Tanzu - Org User - Create Database](https://i0.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database.jpg?resize=604%2C69&ssl=1)](https://i0.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database.jpg?ssl=1)

- Select the Database Software you want to deploy
- Either use the name provided or provide your own
- Select the environment (vCenter) you are deploying to
- Select the Database version

Now you have two choices, you can provision this DB the really easy way with the default configuration.

- You can review the default configuration [parameters here](https://docs.vmware.com/en/Data-Management-for-VMware-Tanzu/1.0/tanzu-data-management/GUID-user-create_db_form.html)

Or you can specify all the settings yourself by clicking “VM Settings”, which is the path I’ll take in this blog post.

[![Data Management for Tanzu - Org User - Create Database - Select Database](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Select-Database.jpg?resize=604%2C301&ssl=1)](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Select-Database.jpg?ssl=1)

- Select your Virtual Machine Resources
  - I’ve shown the options for both Free Plan and Instance Plan modes

[![Data Management for Tanzu - Org User - Create Database - Resource Configuration](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Resource-Configuration.jpg?resize=604%2C368&ssl=1)](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Resource-Configuration.jpg?ssl=1)

- Set your monitoring configuration
  - You can find more details about the [two options here](https://docs.vmware.com/en/Data-Management-for-VMware-Tanzu/1.0/tanzu-data-management/GUID-provider-monitor_dbinst.html#service-instance-metrics-7).
- Enable or disable Data Protection
- Enable or disable if you want to have your database instances updated automatically for minor versions
- Enable or disable the Maintenance Window
  - DMS applies Service Instance updates that require a service or VM restart only during the maintenance window configured

[![Data Management for Tanzu - Org User - Create Database - Management Configuration](https://i0.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Management-Configuration.jpg?resize=604%2C198&ssl=1)](https://i0.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Management-Configuration.jpg?ssl=1)

Under Additional Configuration, we can configure a number of options for our Database instance.

- Set the Database Name, Port, Admin User + Password
- Configure the Datastore and Application network to deploy the Virtual Machine too

[![Data Management for Tanzu - Org User - Create Database - Additional Configuration](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Additional-Configuration.jpg?resize=604%2C241&ssl=1)](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Additional-Configuration.jpg?ssl=1)

- Set the Database Backup Schedule and Retentions
- Set the maintenance window for any upgrades
- Set if TLS is to be configured for connectivity to the Database instance

[![Data Management for Tanzu - Org User - Create Database - Additional Configuration 2](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Additional-Configuration-2.jpg?resize=604%2C261&ssl=1)](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Additional-Configuration-2.jpg?ssl=1)

- Configure your specific DB Options
  - _DB Options Configuration_ – Configure database engine-specific options:
    - [PostgreSQL DB Options Configuration](https://docs.vmware.com/en/Data-Management-for-VMware-Tanzu/1.0/tanzu-data-management/GUID-postgresql.html#dbopt_cfg)
    - [MySQL DB Options Configuration](https://docs.vmware.com/en/Data-Management-for-VMware-Tanzu/1.0/tanzu-data-management/GUID-mysql.html#dbopt_cfg)

[![Data Management for Tanzu - Org User - Create Database - Additional Configuration 3](https://i0.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Additional-Configuration-3.jpg?resize=604%2C264&ssl=1)](https://i0.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Additional-Configuration-3.jpg?ssl=1)

Clicking summary will present you with a total summary of all the options selected. Finish by clicking “Create Database”.

[![Data Management for Tanzu - Org User - Create Database - Summary Create Database](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Summary-Create-Database.jpg?resize=604%2C332&ssl=1)](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Summary-Create-Database.jpg?ssl=1)

You’ll be taken to the Databases UI again. You should see the new DB instance listed and the status as Init.

You can click the DB instance object to be taken to the UI with more information. If you click the vCenter name in blue this will take you the infrastructure page instead.

[![Data Management for Tanzu - Org User - Create Database - Init](https://i0.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Init.jpg?resize=604%2C87&ssl=1)](https://i0.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Init.jpg?ssl=1)

Clicking the Operations tab will show you the progress of the deployment, and you can click this task to find further information.

[![Data Management for Tanzu - Org User - Create Database - Operations - Create DB](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Operations-Create-DB.jpg?resize=604%2C82&ssl=1)](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Operations-Create-DB.jpg?ssl=1)

[![Data Management for Tanzu - Org User - Create Database - Operations - Create DB - State History - Request Data](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Operations-Create-DB-State-History-Request-Data.jpg?resize=604%2C407&ssl=1)](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Operations-Create-DB-State-History-Request-Data.jpg?ssl=1)

Below we can see the vCenter tasks of the Virtual Machine deployment.

[![Data Management for Tanzu - Org User - Create Database - vCenter Tasks](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-vCenter-Tasks.jpg?resize=604%2C213&ssl=1)](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-vCenter-Tasks.jpg?ssl=1)

Once the Virtual Machine has been successfully deployed, run its initialisation scripts and reported back to the Agent Appliance, the status will change to Online in the UI.

[![Data Management for Tanzu - Org User - Create Database - Online](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Online.jpg?resize=604%2C67&ssl=1)](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Create-Database-Online.jpg?ssl=1)

##### Managing your Deployed Database

Clicking into the Database instance, you can now see a details screen populated full of information.

Calling out some of the items on the details page:

- In the purple box you can see the details you’ll need to connect to the database instance using your preferred SQL client tool of choice
  - You’ll notice the FQDN is that of the DNS suffix provided when you register the agent. If we run an NSLOOKUP from my client machine, we’ll see my main DNS server forward the request to the Agent Appliance for the lookup.
- Database actions include cloning the DB Instance, power off or delete.
- You can configure the TLS setting if not already configured, access the SSL certificates, and regenerate the SSL Certificates.
- Enable SSH access to the Database Instance Virtual Machine

[![Data Management for Tanzu - Org User - Database Details](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Database-Details.jpg?resize=604%2C432&ssl=1)](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Database-Details.jpg?ssl=1)

Under Monitoring Tab, you will see the Health status of the Instance appliance and status updates and alerts.

[![Data Management for Tanzu - Org User - Database Monitoring - Health Status](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Database-Monitoring-Health-Status.jpg?resize=604%2C328&ssl=1)](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Database-Monitoring-Health-Status.jpg?ssl=1)

Clicking DB Metrics will show you exactly as the name suggests. You will also see the monitoring configuration (Normal/Enhanced).

Further details of the Service Instance Status details can be [found here](https://docs.vmware.com/en/Data-Management-for-VMware-Tanzu/1.0/tanzu-data-management/GUID-provider-monitor_dbinst.html).

[![Data Management for Tanzu - Org User - Database Monitoring - DB Metrics](https://i0.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Database-Monitoring-DB-Metrics.jpg?resize=604%2C333&ssl=1)](https://i0.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Database-Monitoring-DB-Metrics.jpg?ssl=1)

I’ll skip over the Operations Tab as we’ve already looked at this whilst deploying the instance, however for a new instance, an immediate backup will occur to the local S3 bucket and Cloud S3 bucket configured for the Agent Instance.

On the Backup Tab, we can see the schedule.

- Ability to perform an immediate backup
- Ability to perform a full restore of the latest backup or a point-in-time restore

[![Data Management for Tanzu - Org User - Backup](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Backup.jpg?resize=604%2C186&ssl=1)](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Backup.jpg?ssl=1)

On the VM Settings tab, you can change the compute resources and also extend the disk of the appliance as well.

[![Data Management for Tanzu - Org User - VM Settings](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-VM-Settings.jpg?resize=604%2C166&ssl=1)](https://i2.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-VM-Settings.jpg?ssl=1)

On the logs tab, you can generate a logs bundle from the Service Instance appliance and download it.

[![Data Management for Tanzu - Org User - Logs](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Logs.jpg?resize=604%2C126&ssl=1)](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Logs.jpg?ssl=1)

##### Cloning or Restoring a Database Instance

You can clone a new instance of an existing database.

Provide the details as requested, and a new Service Instance Virtual Machine will be created in the vCenter.

The same can be said by selecting one of the restore options as well. A new instance will be deployed.

[![Data Management for Tanzu - Org User - Clone Database](https://i0.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Clone-Database.jpg?resize=604%2C410&ssl=1)](https://i0.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Clone-Database.jpg?ssl=1)

[![Data Management for Tanzu - Org User - Restore Database](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Restore-Database.jpg?resize=604%2C367&ssl=1)](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Restore-Database.jpg?ssl=1)

You can view the events on the Database Operations tab from the left-hand navigation pane.

[![Data Management for Tanzu - Org User - Database Operations](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Database-Operations.jpg?resize=604%2C123&ssl=1)](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-Database-Operations.jpg?ssl=1)

##### Connecting to a Database Instance

The last piece of the puzzle is connecting to a Database instance. You can do this using the details from the Database Details page and your chosen client.

[![Data Management for Tanzu - Org User - MySQL workbench](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-MySQL-workbench.png?resize=604%2C425&ssl=1)](https://i1.wp.com/veducate.co.uk/wp-content/uploads/2021/08/Data-Management-for-Tanzu-Org-User-MySQL-workbench.png?ssl=1)

 

##### Wrap-up

Over both blog posts, we have cover how to deploy the Data Management for VMware Tanzu infrastructure, configure the minimum requires to enable the platform to be used by a user to deploy a Database Service Instance on demand. And then as a user use the platform to request a database instance.

This is the first GA release of the offering, so of course there are features we will need to wait for, and the documentation even states platforms such as Kubernetes will be supported to deploy to in the future.

I’m very much looking forward to seeing this product develop in the future.

Regards

[Follow @Saintdle](https://twitter.com/saintdle)<script async="" src="https://platform.twitter.com/widgets.js" charset="utf-8"></script>

[Dean Lewis](https://uk.linkedin.com/in/saintdle?trk=profile-badge)

The post [Data Management for VMware Tanzu – Self-Service DBaaS](https://veducate.co.uk/dms-self-service/) appeared first on [vEducate.co.uk](https://veducate.co.uk).