Whoops, I guess I have more than one additional question. After getting all your terrific answers, I used the application wizard to create a new application. When I went in to configure the mysqllvm64 role, the "Storage engine" dropdown box on the "MySql settings" tab was grayed out. Why is that?
On Sep 9, 12:28 pm, Nickolas Toursky <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
