You can use on-demand VMware SQL with MySQL for Tanzu Application Service service to provision and use dedicated instances MySQL database on demand.
When you install VMware SQL with MySQL for TAS, the tile deploys and maintains a single service broker that integrates VMware SQL with MySQL for TAS with Ops Manager.
VMware SQL with MySQL for TAS is configured with sensible settings by default so that the service meets user expectations for a general-use relational database.
VMware SQL with MySQL for TAS supports the following VM topologies:
- Single node.
- Leader-follower. For more information, see About Leader-Follower.
- Highly available (HA) cluster. For highly available clusters VMware SQL with MySQL for TAS 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.
Product Snapshot
The following table provides version and version-support information about VMware SQL with MySQL for TAS.
| Element | Details |
|---|---|
| Version | 3.3.0 |
| Release date | May 23, 2023 |
| Compatible Ops Manager versions | 3.0, 2.10 |
| Compatible VMware Tanzu Application Service for VMs (TAS for VMs) versions | 6.0, 5.0, 4.0, 3.0, 2.13, and 2.11 |
| IaaS support | AWS, Azure, GCP, OpenStack, and vSphere |
| IPsec support | Yes |
On-Demand Service
VMware SQL with MySQL for TAS 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 VMware SQL with MySQL for TAS you have more options for how and when instances are provisioned. VMware SQL with MySQL for TAS enables both the operator and developer to configure MySQL settings and resource use.
The VMware SQL with MySQL for TAS on-demand service uses the on-demand service broker. For information about the on-demand service broker, see On-Demand Services SDK for VMware Tanzu.
On-Demand Service Plan
VMware SQL with MySQL for TAS offers an on-demand service plan called p.mysql. 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.
Enterprise-ready checklist
Review the following table to determine if VMware SQL with MySQL for TAS has the features needed to support your enterprise:
| Plans and Instances | More Information | |
|---|---|---|
| On-Demand, Dedicated-VM Plans | VMware SQL with MySQL for TAS 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 | VMware SQL with MySQL for TAS 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 | VMware SQL with MySQL for TAS supports sharing service instances between different orgs and spaces. | Share Service Instances |
| Installation and Upgrades | More Information | |
| Product Upgrades | VMware SQL with MySQL for TAS can be upgraded within the v2 tile series. | Upgrading VMware SQL with MySQL for TAS |
| Deployment Smoke Tests | VMware SQL with MySQL for TAS 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 | VMware SQL with MySQL for TAS provides metrics for monitoring service plan usage, service quotas, and MySQL component metrics. VMware SQL with MySQL for TAS can also forward metrics to an external service. | Monitoring VMware SQL with MySQL for TAS |
| Backup and Restore | VMware SQL with MySQL for TAS provides backups to an external storage solution on a configurable schedule. VMware SQL with MySQL for TAS also provides a restore process. | Configuring Automated Backups and Backing Up and Restoring VMware SQL with MySQL for TAS |
| Scale and Availability | More Information | |
| Scaling | Operators can scale the size of VMs up, but not down. | Installing Configuring VMware SQL with MySQL for TAS |
| Rolling Deployments | VMware SQL with MySQL for TAS supports rolling deployments when upgrading HA clusters. However, single node and leader-follower service instances are unavailable during upgrades. | Upgrading VMware SQL with MySQL for TAS |
| AZ Support | VMware SQL with MySQL for TAS can be deployed to multiple zones to ensure availability if an unplanned outage of a zone occurs. | About Availability Zones |
| Encryption | More Information | |
| Transport Layer Security (TLS) | VMware SQL with MySQL for TAS 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 | VMware SQL with MySQL for TAS has been tested successfully with the BOSH IPsec Add-on. | IPsec Add-on |
Feedback
Please send any issues, feature requests, or questions to Tanzu Support.
