Thank you for the clear explanation. I know I sent a flurry of questions. There was one in the middle I didn't see the answer to:
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 ? On Sep 9, 8:52 am, Nickolas Toursky <[email protected]> wrote: > Kenneth, > > Both 'backup' and 'bundle' are the complete MySQL data backups. The > difference is 'backup' is an SQL mysqldump file, and 'bundle' is the > MySQL datadir snapshot. > > Backup locks database for longer time than bundle. > > Database lock for LVM and EBS storage engines takes a few seconds. > > Role name includes "LVM" suffix for historical reasons. You are free > to use whatever storage engine you wish with this role. > > To restore SQL backup, you will need to import SQL file to the MySQL server. > > Bundle should be extracted as MySQL datadir. > > Nick > > 2009/9/9 kenvogt <[email protected]>: > > > > > > > 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 -~----------~----~----~----~------~----~------~--~---
