VMware Tanzu SQL with MySQL for VMs

Note: In v2.9 and later, MySQL for VMware Tanzu is named VMware Tanzu SQL with MySQL for VMs.

Page last updated:

This topic provides an overview of the on-demand VMware Tanzu SQL with MySQL for VMs service.

About Tanzu SQL for VMs

Tanzu SQL for VMs enables developers to provision and use dedicated instances MySQL database on demand. When you install Tanzu SQL for VMs, the tile deploys and maintains a single service broker that integrates Tanzu SQL for VMs with Ops Manager.

Tanzu SQL for VMs is configured with sensible settings by default so that the service meets user expectations for a general-use relational database.

Tanzu SQL for VMs supports the following VM topologies:

  • Single node.
  • Leader-follower. For more information, see About Leader-Follower.
  • Highly available (HA) cluster. For highly available clusters Tanzu SQL for VMs 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 Tanzu SQL for VMs.

Element Details
Version 2.9.2
Release date November 6, 2020
Compatible Ops Manager versions 2.10, 2.9, 2.8, 2.7, and 2.6
Compatible VMware Tanzu Application Service for VMs (TAS for VMs) versions 2.10, 2.9, 2.8, 2.7, and 2.6
IaaS support AWS, Azure, GCP, OpenStack, and vSphere
IPsec support Yes

On-Demand Service

Tanzu SQL for VMs 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 Tanzu SQL for VMs you have more options for how and when instances are provisioned. Tanzu SQL for VMs enables both the operator and developer to configure MySQL settings and resource use.

The Tanzu SQL for VMs on-demand service uses the on-demand service broker. For information about the on-demand service broker, see On-Demand Services SDK.

On-Demand Service Plan

Tanzu SQL for VMs 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 Tanzu SQL for VMs has the features needed to support your enterprise:

Plans and Instances More Information
On-Demand, Dedicated-VM Plans Tanzu SQL for VMs 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 Tanzu SQL for VMs 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 Tanzu SQL for VMs supports sharing service instances between different orgs and spaces. Share Service Instances
Installation and Upgrades More Information
Product Upgrades Tanzu SQL for VMs can be upgraded within the v2 tile series. Upgrading Tanzu SQL for VMs
Deployment Smoke Tests Tanzu SQL for VMs 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 Tanzu SQL for VMs provides metrics for monitoring service plan usage, service quotas, and MySQL component metrics. Tanzu SQL for VMs can also forward metrics to an external service. Monitoring Tanzu SQL for VMs
Backup and Restore Tanzu SQL for VMs provides backups to an external storage solution on a configurable schedule. Tanzu SQL for VMs also provides a restore process. Configuring Automated Backups and Backing Up and Restoring Tanzu SQL for VMs
Scale and AvailabilityMore Information
ScalingOperators can scale the size of VMs up, but not down. Installing Configuring Tanzu SQL for VMs
Rolling Deployments Tanzu SQL for VMs supports rolling deployments when upgrading HA clusters. However, single node and leader-follower service instances are unavailable during upgrades. Upgrading Tanzu SQL for VMs
AZ Support Tanzu SQL for VMs 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) Tanzu SQL for VMs 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 Tanzu SQL for VMs has been tested successfully with the BOSH IPsec Add-on. IPsec Add-on

Feedback

Please send any issues, feature requests, or questions to the Feedback list.