minor-overview.html.md.erb

---
title: Overview of MySQL for PCF v2
owner: London Services
---

This topic describes the significant features in MySQL for PCF v2.
This topic also presents a checklist that you can use to decide if MySQL for PCF is ready to meet your business requirements.

##<a id="intro"></a> Introduction

MySQL for PCF v2 introduces the On-Demand Service, which provides dedicated instances of
MySQL that App Developers can provision on-demand from the command line.
The MySQL for PCF On-Demand service is designed to improve the flexibility in how and when
instances are provisioned and allows for more efficient and seamless resource use for both Operator and App Developer.
Additionally, both Operator and App Developer can configure essential MySQL settings.
MySQL for PCF v2 can be installed alongside the earlier MySQL for PCF v1.x tiles.

MySQL for PCF's On-Demand Service leverages the [on-demand service broker](https://docs.pivotal.io/svc-sdk/odb/0-15/).

## <a id="service"></a>On Demand Service Plan Descriptions

PCF MySQL offers five on-demand plans as the `p.mysql` service within the PCF MySQL tile.
The plans can be configured in any way that you see fit.
However, plans should be configured such that they increase in size.

For each service plan, the operator can configure the **Multi-Node**, **Plan name**, **Plan description**, **Server VM type** and **Server Disk type**, or choose to disable the plan completely.

Operators can update certain plan settings after the plans have been created.
If the Operator updates the VM size or disk size these settings will be implemented in all instances already created.
Operators should not downsize the VMs or disk size as this can cause data loss in pre-existing instances.

##<a id="tls"></a> Transport Layer Security (TLS)

In MySQL for PCF v2.3 and later, you can enable TLS. 
Enabling TLS provisions a MySQL server with a certificate so 
that apps and clients can establish an encrypted connection with the data service.

For more information on TLS, and the workflow for enabling and using it, see [Preparing for TLS](./prepare-tls.html).


##<a id="checklist"></a> Enterprise-Ready Checklist

Review the following table to determine if MySQL for PCF v2 has the features needed to support your enterprise.

<table border="1" class="nice">
<tr><th colspan=2>Plans and Instances</th><th>More Information</th></tr>
<tr><td>On-Demand, Dedicated-VM plans</td><td>MySQL for PCF provides On-Demand VM plans</td><td><a href="./about.html">Architecture</a></td></tr>
<tr><td>Customizable plans</td><td>For the On-Demand Plan, the operator can customize the VM, disk size, and availability zone.</td><td><a href="./install-config.html#active">Configuring</a></td></tr>

<tr><th colspan=2>Installation and Upgrades</th><th>More Information</th></tr>
<tr><td>Product upgrades</td><td>MySQL for PCF can be upgraded within the v2.x tile series. Additionally, it can be installed alongside the MySQL for PCF v1.X tiles to enable easy manual migrations</td>
     <td><a href="./upgrade.html">Upgrading MySQL for PCF</a></td></tr>
<tr><td>Deployment Smoke Tests</td><td>MySQL for PCF installation and upgrade runs
        a post deployment BOSH errand that validates basic MySQL operations</td>
    <td></td></tr>

<tr><th colspan=2>Maintenance and Backups</th><th>More Information</th></tr>
<tr><td>Operational Monitoring and Logging</td><td>MySQL for PCF v2 provides metrics for monitoring On-Demand plan usage and quotas, as well as MySQL component metrics. Additionally, MySQL for PCF provides syslog redirection to external log ingestors.</td>
    <td><a href="./monitor.html">Monitoring MySQL for PCF</a></td></tr>
<tr><td>Backup and Restore</td><td>MySQL for PCF v2 includes automatic backups on a configurable schedule to a variety of destinations, as well as a simple restore process.
</td><td><a href="./backup-and-restore.html">Manual Backup and Restore of MySQL for PCF</a></td></tr>

<tr><th colspan=2>Scale and Availability</th><th>More Information</th></tr>
<tr><td>On-Demand Plan</td><td>MySQL for PCF provides up to 50 on-demand instances across all plans</td><td></td></tr>
<tr><td>Ability to Scale Up / Down</td><td>Operators can scale VMs up, but not down</td><td><a href="./install-config.html">Configuring</a></td></tr>
<tr><td>Rolling Deployments</td><td>MySQL for PCF does not support rolling deployments because it is single node; the service is unavailable during upgrades.</td><td><a href="./upgrade.html">Upgrades</a></td></tr>
<tr><td>AZ Support</td><td>MySQL for PCF can be deployed to multiple zones to increase availability during unplanned outages of a zone.</td>
    <td><a href="#other-notes">About Multiple AZs in MySQL for PCF</a></td></tr>

<tr><th colspan=2>Encryption</th><th>More Information</th></tr>
<tr><td>Encrypted Communication in Transit</td><td>MySQL for PCF has been tested successfully with the BOSH IPsec Add-on</td>
    <td><a href="https://docs.pivotal.io/addon-ipsec/index.html">Securing Data in Transit with the IPsec Add-on</a></td></tr>

</table>


## <a id="other-notes"></a>About Multiple AZs in MySQL for PCF v2

MySQL for PCF v2 supports configuring multiple AZs.
However, assigning multiple AZs to MySQL jobs does not guarantee high availability.

* On-Demand plans can be assigned to any of the configured availability zones. 
* You can select two AZs
  for the multi-node plans to increase the availability. 
  Choosing three AZs for multi-node plans does not increase the number of AZs assigned to three.
* You can select one AZ for the single-node plan.
  Choosing two AZs for the single-node plan does not increase the number of AZs assigned to two.