Open Stack

On 12/02/2013 11:47 AM, Abbass MAROUNI wrote:
> Hello,
> 
> I'm looking for way to a add new attribute to the compute nodes by
>  adding a column to the compute_nodes table in nova database in order to
> track a metric on the compute nodes and use later it in nova-scheduler.
> 
> I checked the  sqlalchemy/migrate_repo/versions and thought about adding
> my own upgrade then sync using nova-manage db sync. 
> 
> My question is : 
> What is the process of upgrading a table in the database ? Do I have to
> modify or add a new variable in some class in order to associate the
> newly added column with a variable that I can use ? 

Don't add this.  :-)

There is work in progress to just have a column with a json blob in it
for additional metadata like this.

https://blueprints.launchpad.net/nova/+spec/extensible-resource-tracking
https://wiki.openstack.org/wiki/ExtensibleResourceTracking

-- 
Russell Bryant