MySQL for Pivotal Cloud Foundry

Page last updated:

This topic provides an overview of the on-demand MySQL for Pivotal Cloud Foundry (PCF) service.

About MySQL for PCF

MySQL for PCF enables developers to provision and use dedicated instances MySQL database on demand. When you install MySQL for PCF, the tile deploys and maintains a single service broker that integrates MySQL for PCF with Pivotal Cloud Foundry.

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

MySQL for PCF 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 PCF uses a patched Galera Cluster named Percona XtraDB Cluster (PXC). For more information about PXC, see Percona XtraDB Cluster.

    Warning: Highly available plans are currently in beta. HA clusters are for advanced use cases only.

Product Snapshot

The following table provides version and version-support information about MySQL for PCF.

Element Details
Version 2.6.8
Release date May 20, 2020
Software component version Percona Server v5.7.28-31
Compatible Ops Manager versions 2.8, 2.7, 2.6, 2.5, 2.4, and 2.3
Compatible Pivotal Application Service (PAS) versions 2.8, 2.7, 2.6, 2.5, 2.4, and 2.3
IaaS support AWS, Azure, GCP, OpenStack, and vSphere
IPsec support Yes

On-Demand Service

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

The MySQL for PCF 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

MySQL for PCF 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 MySQL for PCF has the features needed to support your enterprise:

Plans and Instances More Information
On-Demand, Dedicated-VM Plans MySQL for PCF 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 PCF 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 PCF supports sharing service instances between different orgs and spaces. Share Service Instances
Installation and Upgrades More Information
Product Upgrades MySQL for PCF can be upgraded within the v2 tile series. Upgrading MySQL for PCF
Deployment Smoke Tests MySQL for PCF 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 PCF provides metrics for monitoring service plan usage, service quotas, and MySQL component metrics. MySQL for PCF can also forward metrics to an external service. Monitoring MySQL for PCF
Backup and Restore MySQL for PCF provides automatic backups to an external storage solution on a configurable schedule. MySQL for PCF also provides a restore process. Backing Up MySQL for Pivotal Cloud Foundry
Restoring MySQL for Pivotal Cloud Foundry
Scale and AvailabilityMore Information
On-Demand Plans MySQL for PCF provides up to 200 on-demand instances across all plans.
ScalingOperators can scale the size of VMs up, but not down. Installing Configuring MySQL for PCF
Rolling Deployments MySQL for PCF supports rolling deployments when upgrading HA clusters. However, single node and leader-follower service instances are unavailable during upgrades. Upgrading MySQL for PCF
AZ Support MySQL for PCF can be deployed to multiple zones to ensure availability if an unplanned outage of a zone occurs. About Availability Zones
EncryptionMore Information
Transport Layer Security (TLS) MySQL for PCF 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 PCF has been tested successfully with the BOSH IPsec Add-on. IPsec Add-on

Feedback

Please provide any bugs, feature requests, or questions to the Pivotal Cloud Foundry Feedback list.