Open Stack

for posterity yes the info isn't hard to find in the database:

mysql> select id,vcpus,vcpus_used,memory_mb,memory_mb_used  from compute_nodes;

I'm not terribly keen on SQL as an interface, guess if it bothers me
enough I'll implement a different interface...

On Wed, Jul 11, 2012 at 10:34 PM, Jonathan Proulx <jon at jonproulx.com> wrote:
> On Wed, Jul 11, 2012 at 8:58 PM, Chris Behrens <cbehrens at codestud.com> wrote:
>> Hi Jon,
>>
>> There's actually a review up right now proposing to add an OS API extension
>> to be able to give some of this data:
>>
>> https://review.openstack.org/#/c/9544/
>
> that seems to be based on quota limits where as I'm look for just now
> is over all physical limits for all users.
>
>> I don't know how you may be looking to query it, but it's not too difficult
>> to get it directly from the instances table in the database, either.
>
> I guess I'm looking for something like:
>
> eucalyptus-describe-availibility-zones verbose
> AVAILABILITYZONE |- vm types free / max cpu ram disk
> AVAILABILITYZONE |- m1.small 0000 / 0000 1 128 2
> AVAILABILITYZONE |- c1.medium 0000 / 0000 1 256 5
> AVAILABILITYZONE |- m1.large 0000 / 0000 2 512 10
> AVAILABILITYZONE |- m1.xlarge 0000 / 0000 2 1024 20
> AVAILABILITYZONE |- c1.xlarge 0000 / 0000 4 2048 20
>
> (well not with the zeros, but it's the first example I could find)
>
> where with euca2ools and openstack I get essentially the output of
> 'nova-manage service list' which is useful but not for the same
> things.  Guess I'll dig into the database shouldn't be too hard to get
> close to what I want, the eucalyptus output also takes into account
> fragmentation, which is nice since if I have 100 free cpu slots but on
> 100 different compute nodes I'm in a bit more trouble than if they are
> only spread across 10 since in the later case multicore instances can
> start (for a while anyway).
>
> Thanks,
> -Jon