To migrate an existing MySQL EBS database setup that is using the MySQL-S3 ServerTemplate ("MySQL Bootstrap" and "MySQL Additional") to the one of the 11H1 ServerTemplates (Database Manager with MySQL 5.0 - 11H1 or Database Manager with MySQL 5.1 - 11H1), which supports EBS volume striping and other enhancements that are not available in the MySQL EBS v1 ServerTemplate.
Table of Contents
The 11H1 MySQL ServerTemplates let you use a set of striped EBS volumes for the database. Although this tutorial assumes that you are going to take advantage of the EBS striping capability, it is not required. You can still migrate to the 11H1 template and continue to use a non-striped EBS volume for backups (EBS_STRIPE_COUNT=1).
Note: You cannot restore a backup of a MySQL EBS server with striping onto a server that does not support EBS stripes. (See FAQ 137 for alternative solutions.)
These enhancements are included in the MySQL EBS v2 and later ServerTemplate versions—including the current 11H1 compatibilty release ServerTemplates:
There are potentially two migration paths to start using the 11H1 ServerTemplate:
Follow the steps below to migrate from a MySQL S3 setup where backups of the database are saved directly to S3 as *.tar files to a setup that uses a set of striped EBS volumes.
© 2006-2014 RightScale, Inc. All rights reserved.
RightScale is a registered trademark of RightScale, Inc. All other products and services may be trademarks or servicemarks of their respective owners.