Kenneth, You could set 'Storage engine' when you are adding MySQL role to the farm. After it was already configured, this setting cannot be changed (work around is to uncheck MySQL role, save farm, then enable role, choose storage engine and save the farm again. This will terminate all your current MySQL instances and start new ones using the last data bundle from S3).
"Automatically mount to ___ mount point" is used when you wish Scalr to automatically attach and mount the EBS volume to every instance of the corresponding role upon its initialization. "mount point" is the path, to where EBS volume filesystem should be mounted. Nick 2009/9/10 kenvogt <[email protected]>: > > 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 -~----------~----~----~----~------~----~------~--~---
