MySQL for Pivotal Cloud Foundry

This guide describes setting up and using MySQL for Pivotal Cloud Foundry (PCF) as an on-demand service.

Note: This documents MySQL for PCF v2.4, an on-demand service that creates dedicated, single-tenant service instances dynamically. For the older, pre-provisioned service, see the v1.10 documentation or select v1.10 from the drop-down menu above.

About MySQL for PCF

MySQL for PCF enables PCF app developers to provision and use a MySQL database with a single command.

The MySQL for PCF product delivers dedicated instances on demand, “Database as a Service”, to PCF users. When installed, the tile deploys and maintains a single Service Broker that is responsible for PCF integration. The service is configured with sane defaults, following the principle of least surprise for a general-use relational database service.

For more information about MySQL for PCF v2.4, see Minor Overview.

MySQL for PCF v2 introduces a new type of service, an on-demand service. MySQL for PCF v2 offers an alternative to the pre-provisioned service that was in the v1.x series.

This table summarizes the main differences between the two:

Available Since VMs it Runs On How VMs are Created Metrics Name Prefix
On-Demand Service New for v2 Dedicated instance VM(s) dynamically provisioned on demand PCF creates each VM on-demand when an app developer creates service instance p.mysql (with a dot)
Pre-Provisioned Service v1.4 Multi-tenant VMs shared by apps across PCF deployment PCF creates all VMs when the operator deploys or updates service p-mysql (with a dash)

Product Snapshot

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

Element Details
Version v2.4.6
Release date June 14, 2019
Software component version Percona Server 5.7.24-26
Compatible Ops Manager version(s) 2.2, 2.3, and 2.4
Compatible Pivotal Application Service (PAS) version(s) 2.2, 2.3, and 2.4
IaaS support AWS, Azure, GCP, OpenStack, and vSphere
IPsec support Yes

MySQL for PCF and Other PCF Services

Some PCF services offer on-demand service plans. These plans let developers provision service instances when they want.

These contrast with the more common pre-provisioned service plans, which require operators to provision the service instances during installation and configuration through the service tile UI.

The following PCF services offer on-demand service plans:

  • MySQL for PCF v2.0 and later

  • RabbitMQ for PCF

  • Redis for PCF

  • Pivotal Cloud Cache (PCC)

These services package and deliver their on-demand service offerings differently. For example, some services, like Redis for PCF, have one tile, and you configure the tile differently depending on whether you want on-demand service plans or pre-provisioned service plans.

For other services, like PCC and MySQL for PCF, only on-demand service plans are available.

The following table lists and contrasts the different ways that PCF services package on-demand and pre-provisioned service offerings.

PCF service tile Standalone product related to the service Versions supporting on demand Versions supporting pre-provisioned
RabbitMQ for PCF Pivotal RabbitMQ v1.8 and later All versions
Redis for PCF Redis v1.8 and later All versions
MySQL for PCF MySQL v2.x
PCC Pivotal GemFire All versions NA


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

Create a pull request or raise an issue on the source for this page in GitHub