Note: Please go to docs.rightscale.com to access the current RightScale documentation set. Also, feel free to Chat with us!
Home > ServerTemplates > Archive > 11H1 > Runbooks > Database Manager for MySQL Stripe Runbook > MySQL Stripe Problem Scenarios > I want faster backups

I want faster backups

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.

Required actions: What recipes should I apply to solve the situation?

  1. Change the Number of Volumes in a Stripe

 

You must to post a comment.
Last modified
21:33, 16 May 2013

Tags

Classifications

This page has no classifications.

Announcements

None


© 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.