No, I understand that - what I meant to say is, with a default Scalr GPL install, where I created (and deleted) 2 farms, and now have 1 "running" one with 4 roles (and a max of 2 instances per role, so I guess a theoretical max of 8 instances) and the default "Max AWS instances" setting set to 20, Scalr tells me that I have "-26 spare instances" available (and this is why, I assume, it does not scale when needed).
Incidentally, this number has been crawling up, even though nothing has scaled. This morning, I noticed it was telling me I have -46 spare instances, so I raised the "max" limit to 170. Again - not a single new instance has been instantiated. How is this number calculated, and does it have any effect on scaling? Maybe I am looking for the problem (no new instances being created) in the wrong place? On Tue, Apr 20, 2010 at 4:18 PM, Sebastian Stadil <[email protected]>wrote: > Max instances in your AWS is a limit set by Amazon to protect you against > spinning many instances by mistake, and puts a ceiling to that. > > To raise the limit, please request it from here: > aws.amazon.com/contact-us/ec2-request/ then set your max to that given to > you by Amazon. > > This is the reason your farm is not scaling. > > On Tue, Apr 20, 2010 at 7:23 AM, GB <[email protected]> wrote: > >> Got it - that fixed it. Thanks very much for the reply. >> >> I am also having a strange issue with scaling. My farm just ... does not >> scale. I created a 4-role farm (www, memcache, mysql-lvm and app); I >> customized the 'app' role (added my webroot, added an SVN script, etc) and >> 'synchronized' it. Now, the following things happen: >> >> - it is set to 1 instance min, max 4. If I raise the minimum to 2, 3, 4, >> whatever, nothing happens (no new instances scale). This is the case for the >> customized app instance, but also for the default memcached instance. >> - if I configure scaling by LA, the setting does not seem to save (when I >> return to the same tab after clicking 'Save', the checkbox is not checked >> and the settings do not seem to be present). >> >> I don't know if it's related, but the message on top says "You have -36 >> spare instances in your Amazon account" (not sure why so few; but I went to >> AWS Settings and set "max AWS instances" to something like 70, just to get a >> positive number in that box). >> >> Any thoughts appreciated. Thanks again. >> >> -j >> >> >> On Tue, Apr 20, 2010 at 2:09 AM, Igor Savchenko <[email protected]>wrote: >> >>> Hello Jason, >>> >>> >>> Please use latest version from SVN: >>> http://code.google.com/p/scalr/source/browse/ >>> >>> Tuesday, April 20, 2010, 5:33:45 AM, you wrote: >>> >>> > Hi all, >>> >>> > I did the v1.2.0 install, and ran the database.sql. It seems, though, >>> > that some MySQL tables weren't set up properly. Here are some examples >>> > of what I am getting in the logs: >>> >>> > Cannot store event in database: mysql error: [1054: Unknown column >>> > 'event_object' in 'field list'] in EXECUTE("INSERT INTO events SET >>> > farmid = '3', type = 'MysqlBackupComplete', dtadded = NOW(), message = >>> > 'MySQL backup complete ', short_message = 'MySQL backup complete ', >>> > event_object = >>> > 'O:24:"MysqlBackupCompleteEvent":7:{s:10:"DBInstance";O: >>> > 10:"DBInstance":13:{s:2:"ID";s:1:"4";s:6:"FarmID";s:1:"3";s: >>> > 10:"InstanceID";s:10:"i-xxxxxx";s:5:"AMIID";s:12:"ami-xxxxxx";s: >>> > 10:"InternalIP";s:14:"xx.xxx.xxx.xxx";s:10:"ExternalIP";s: >>> > 13:"xxx.xx.xx.xxx";s:9:"AvailZone";s:10:"us-east-1c";s:5:"Index";s: >>> > 1:"1";s:6:"Region";s:9:"us-east-1";s:10:"FarmRoleID";s:1:"5";s: >>> > 8:"RoleName";s:8:"mysqllvm";s:22:"DBInstanceDBFarmRole";O: >>> > 10:"DBFarmRole":5:{s:2:"ID";s:1:"5";s:6:"FarmID";s:1:"3";s:5:"AMIID";s: >>> > 12:"ami-d09572b9";s:21:"DBFarmRoleRoleAlias";s:5:"mysql";s: >>> > 20:"DBFarmRoleRoleName";s:8:"mysqllvm";}s:18:"DBInstanceDBFarm";O: >>> > 6:"DBFarm":4:{s:2:"ID";s:1:"3";s:8:"ClientID";s:1:"1";s:4:"Name";s: >>> > 10:"trailblaze";s:6:"Region";s:9:"us-east-1";}}s:9:"Operation";s: >>> > 6:"bundle";s:12:"SnapshotInfo";N;s:22:"SkipDeferredOperations";b:0;s: >>> > 14:"EventEventID";s:36:"fcc5c2ee-4faa-41d2-a887-9d6b40c95a2d";s: >>> > 13:"EventFarmID";s:1:"3";s:6:"DBFarm";O:6:"DBFarm":4:{s:2:"ID";s: >>> > 1:"3";s:8:"ClientID";s:1:"1";s:4:"Name";s:10:"trailblaze";s: >>> > 6:"Region";s:9:"us-east-1";}}', event_id = 'fcc5c2ee-4faa-41d2- >>> > a887-9d6b40c95a2d' ") >>> > Exception thrown in query-env interface: Cannot retrieve environment >>> > by operation 'list-scripts': mysql error: [1054: Unknown column >>> > 'event_id' in 'where clause'] in EXECUTE("SELECT * FROM events WHERE >>> > event_id='0406b3db-dadc-4bc9-9753-3032ed7ea4de'") >>> >>> >>> >>> > I can alter those tables, but I'm curious what else I might be >>> > missing. >>> >>> > Also: I increased the 'minimum # of instances' of a custom role to 2 >>> > (was 1), but no new instance is being created. Could this be due to >>> > some missing column as well? >>> >>> > Thanks very much. >>> >>> > -j >>> >>> >>> >>> >>> -- >>> Best regards, >>> Igor mailto:[email protected] >>> >>> -- >>> 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]<scalr-discuss%[email protected]> >>> . >>> For more options, visit this group at >>> http://groups.google.com/group/scalr-discuss?hl=en. >>> >>> >> -- >> 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]<scalr-discuss%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/scalr-discuss?hl=en. >> > > -- > 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]<scalr-discuss%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/scalr-discuss?hl=en. > -- 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.
