You have a working MySQL database setup, but it's taking too long to complete the backups because the size of the volume is extremely large. Is there a way to reduce the amount of time that's required to complete a backup of the database?
To decrease the amount of time it takes to perform a backup you should increase the numbers of volumes in your stripe. For example, if you are using a single volume that's 100GB, you can decrease the amount of time to perform a backup by 4x if you migrate to a stripe of four 25GB volumes. Follow the tutorial below and use the EBS_STRIPE_COUNT input to change the number of volumes in the stripe.
Note: Changing the instance size of the database server will not affect the time required to complete a backup snapshot. The time required to complete a snapshot of a volume is only affected by the size of the volume and its data, not the instance size.
© 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.