About Data Migration in MySQL for Pivotal Platform
Warning: MySQL for Pivotal Platform v2.7x is no longer supported because it has reached the End of General Support (EOGS) phase as defined by the Support Lifecycle Policy. To stay up to date with the latest software and security updates, upgrade to a supported version.
Page last updated:
This topic explains how data migration works in MySQL for Pivotal Platform.
Read this topic before you do in the procedures in Migrating Data in MySQL for Pivotal Platform.
You can use the
mysql-tools CLI plugin to migrate MySQL data with the
migrate command does a streaming
mysqldump and restore to migrate data from
your source MySQL database to a destination MySQL for Pivotal Platform v2 instance.
The command supports connections over TLS. If TLS is configured in the source and destination MySQL instances, the data is securely streamed using TLS. For information about how to configure TLS in a MySQL for Pivotal Platform v2 service instance, see Using TLS.
During data migration, the
- Creates a new MySQL for Pivotal Platform v2 service instance in the destination space with the same name as the source MySQL service instance name.
- Copies the source data over to the new service instance.
-oldto the source service instance name, regardless if the source is a MySQL for Pivotal Platform service instance or a user-provided service instance.
migrate command is used for most migration use cases.
See Use Cases Requiring the migrate Command below.
However, many common migrations, such as from a small to a large database,
can be done with the simpler
See Use Cases Not Requiring the migrate Command below.
If your use case is not listed in this topic, you might need to manually back up and restore your database to migrate your data. See Backing Up and Restoring with mysqldump
The following table lists migration use cases that must be done with the
|Single Node||Highly Available (HA) Cluster|
|HA Cluster||Single Node|
|Off-Platform Database *||MySQL for Pivotal Platform v2|
|Availability Zone (AZ)||Another AZ|
|MySQL for Pivotal Cloud Foundry v1||MySQL for Pivotal Platform v2|
* If your off-platform database has encryption at rest or the Percona PAM Authentication plugin
enabled, you cannot use the
Instead, you must follow the procedure
in Restore from an Off-Platform Logical Backup.
Not all migrations require the
For example, if you are migrating a database to a larger single node or leader-follower plan,
use the simpler
The following table lists migration use cases that can be done with the
For instructions about using the
update-service command, see
Update a Service Instance.
|Single Node||larger Single Node|
|Single Node||Leader-Follower of the same or larger size|
|Leader-Follower||Single Node of the same or larger size|
migrate command does not migrate all stored programs.
The command only migrates views and does not migrate triggers, routines, or events.
To manually migrate triggers, routines, or events,
contact Pivotal Support.
migrate command skips the following system schemas:
cf_metadata: This is metadata for binding information, such as database users mapped to Pivotal Platform GUIDs.
information_schema: This is metadata for the MySQL database.
mysql: This is a MySQL database that describes users, user accounts, and permissions. MySQL for Pivotal Platform uses it to authenticate users.
performance_schema: This is metadata about performance and server execution.
sys: This is a schema that summarizes
information_schema change dynamically with changes on a MySQL for Pivotal Platform
service instance. These schemas are not migrated because the destination database has its own version of the schemas.
You do not need to back up these schemas.