Kenneth, No connection between these EBS settings. 'MySQL settings' tab EBS tunables is for MySQL storage volume. 'EBS' tab used to manage volumes for whatever you need but MySQL storage.
Nick 2009/9/9 kenvogt <[email protected]>: > > 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 -~----------~----~----~----~------~----~------~--~---
