Alex, It seems that Scalr does the bundles and backups on the master instance. Is there any way to switch this or give an option to doing it on a slave? I am thinking along the lines of:
1. Pull slave out of DNS and /etc/aws/hosts/mysql 2. Bundle data 3. Bring slave back That way the master never encounters extra load to bundle and upload the instances. Our application is very write heavy, so our master instance is under high load, even with an m1.xlarge instance. (Crazy I know ;)) Moving bundling to a slave instance would help preserve any precious resources on the master and I would gladly pay the extra cost to have an extra slave running if it helps with the stability of the master. The truth is we are bumping up against the limits of a master/slave replication based architecture as our writes are continuing to build. I am looking into alternative designs including sharding, ScaleDB (beta), etc. In the mean time, it would be nice to squeeze every last ounce out of the master that I can. Mike On Oct 23, 1:30 pm, Alex Kovalyov <[EMAIL PROTECTED]> wrote: > Guys will be able to check this in few hours only.. > Enough space on instance? Using InnoDB? What's in mysql logs? > > On 23.10.08 23:06, "mikeytag" <[EMAIL PROTECTED]> wrote: > > > > > As of 5 AM PST this morning, my mysqllvm64 master instance would hang > > on inserts. Selects were fine, but nothing would get inserted. I > > noticed that this all started when it received a bundle trap. We do a > > bundle every 5 hours. Fearing this as the culprit I unchecked the > > bundling box for now. However, on that screen I noticed that it says > > my db instance (custom mysqllvm64 role) is Based on role: mysql. > > Maybe this is the culprit? Did Scalr somehow switch my db instances > > into operating as mysql roles instead of mysqllvm64 roles? > > My farm id is 517 if that helps at all. > > Thanks, > > Mike --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
