Please explain to this noob the correct way to set up the backup procedure for a server with an active, large (20Gb) database. I do not expect to scale out to any slaves (for reasons I won't go into here). I need to make sure the backup process does not commandeer the database and make it inaccessible to the application server for more than say 30 seconds.
I have selected the mysqllvm64 role for this server and I intend to use an m1.xlarge instance. Under the tab "MySql settings", I don't understand the difference between: * Bundle and save mysql data snapshot every: X hours * Periodically backup databases every: X minutes The default of 48 hours for the former and 180 minutes for the latter doesn't make sense to me. Shouldn't snapshots be more frequent than complete backups? How long would one of these "data snapshots" lock up the database? How about a "periodic backup"? How do I choose the storage engine on the "MySql settings" tab? I would like to use EBS but the role's name includes "lvm". I am confused. Is there any connection between: "EBS size (max. 1000 GB): X GB" on the "MySql settings" tab and "Attach empty volume with size: X GB" on the "EBS" tab ? Once this is all straightened out, what would be the method for restoring from a backup? Thank you for your help. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "scalr-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/scalr-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
