MySQL for VMware Tanzu
Note: Pivotal Platform is now part of VMware Tanzu. In v2.8 and later, MySQL for Pivotal Platform is named MySQL for VMware Tanzu.
Page last updated:
This topic provides an overview of the on-demand MySQL for VMware Tanzu service.
MySQL for VMware Tanzu enables developers to provision and use dedicated instances MySQL database on demand. When you install MySQL for VMware Tanzu, the tile deploys and maintains a single service broker that integrates MySQL for VMware Tanzu with Ops Manager.
MySQL for VMware Tanzu is configured with sensible settings by default so that the service meets user expectations for a general-use relational database.
MySQL for VMware Tanzu supports the following VM topologies:
- Single node.
- Leader-follower. For more information, see About Leader-Follower.
- Highly available (HA) cluster. For highly available clusters MySQL for VMware Tanzu uses a patched Galera Cluster named Percona XtraDB Cluster (PXC). For more information about PXC, see Percona XtraDB Cluster.
Multi‑Site Replication. For more information, see About Multi‑Site Replication.
Note: Multi‑Site Replication plans are currently in beta. If you discover any bugs, contact Support.
The following table provides version and version-support information about MySQL for VMware Tanzu.
|Release date||May 21, 2020|
|Software component version||Percona Server 5.7.28-31|
|Compatible Ops Manager versions||2.9, 2.8, 2.7, and 2.6|
|Compatible VMware Tanzu Application Service for VMs (TAS for VMs) versions||2.9, 2.8, 2.7, and 2.6|
|IaaS support||AWS, Azure, GCP, OpenStack, and vSphere|
MySQL for VMware Tanzu is an on-demand service. This means that the service provides dedicated instances of MySQL that developers can provision on-demand using the cf CLI or Apps Manager.
With MySQL for VMware Tanzu you have more options for how and when instances are provisioned. MySQL for VMware Tanzu enables both the operator and developer to configure MySQL settings and resource use.
The MySQL for VMware Tanzu on-demand service uses the on-demand service broker. For information about the on-demand service broker, see On-Demand Services SDK.
MySQL for VMware Tanzu offers an on-demand service plan called
Operators can configure and update the plan settings.
When operators update the VM or disk size these settings are applied to all existing instances. If an operator decreases the disk size, data loss might occur in existing instances.
Review the following table to determine if MySQL for VMware Tanzu has the features needed to support your enterprise:
|Plans and Instances||More Information|
|On-Demand, Dedicated-VM Plans||MySQL for VMware Tanzu provides on-demand service plans.||On-Demand Networking|
|Customizable Plans||Operators can customize the VM, disk size, and availability zone for service plans.||Configure Service Plans|
|Custom Schemas||MySQL for VMware Tanzu supports custom schemas. Using custom schemas enables apps to share a MySQL service instance and isolate app data by schema.||Use Custom Schemas|
|Share Service Instances||MySQL for VMware Tanzu supports sharing service instances between different orgs and spaces.||Share Service Instances|
|Installation and Upgrades||More Information|
|Product Upgrades||MySQL for VMware Tanzu can be upgraded within the v2 tile series.||Upgrading MySQL for VMware Tanzu|
|Deployment Smoke Tests||MySQL for VMware Tanzu installations and upgrades run a post-deployment BOSH errand that validates basic MySQL operations.||smoke-tests|
|Maintenance and Backups||More Information|
|Operational Monitoring and Logging||MySQL for VMware Tanzu provides metrics for monitoring service plan usage, service quotas, and MySQL component metrics. MySQL for VMware Tanzu can also forward metrics to an external service.||Monitoring MySQL for VMware Tanzu|
|Backup and Restore||MySQL for VMware Tanzu provides automatic backups to an external storage solution on a configurable schedule. MySQL for VMware Tanzu also provides a restore process.||Backing Up MySQL for VMware Tanzu
Restoring MySQL for VMware Tanzu
|Scale and Availability||More Information|
|On-Demand Plans||MySQL for VMware Tanzu provides up to 200 on-demand instances across all plans.|
|Scaling||Operators can scale the size of VMs up, but not down.||Installing Configuring MySQL for VMware Tanzu|
|Rolling Deployments||MySQL for VMware Tanzu supports rolling deployments when upgrading HA clusters. However, single node and leader-follower service instances are unavailable during upgrades.||Upgrading MySQL for VMware Tanzu|
|AZ Support||MySQL for VMware Tanzu can be deployed to multiple zones to ensure availability if an unplanned outage of a zone occurs.||About Availability Zones|
|Transport Layer Security (TLS)||MySQL for VMware Tanzu supports TLS. Enabling TLS provisions a MySQL server with a certificate so that apps and clients can establish an encrypted connection with the data service.||Preparing for TLS|
|Encrypted Communication in Transit||MySQL for VMware Tanzu has been tested successfully with the BOSH IPsec Add-on.||IPsec Add-on|
Please provide any bugs, feature requests, or questions to the Feedback list.