Re: [one-users] Keep all the data from host_pool

2011-05-24 Thread Carlos Martín Sánchez
Hi,

There is no straight-forward way to do this. We don't have configuration
options for DB manipulation.
I think the best workaround is to create a SQL Trigger [1] [2] , that will
copy the rows to be deleted from 'host_pool' to a new table,
'history_host_pool'.

Please be aware of this bug [3], in some rare cases you may have a new Host
using the ID of an old deleted one.


Regards,
Carlos.

[1] http://dev.mysql.com/doc/refman/5.6/en/triggers.html
[2] http://www.sqlite.org/lang_createtrigger.html

[3] http://dev.opennebula.org/issues/566
--
Carlos Martín, MSc
Project Major Contributor
OpenNebula - The Open Source Toolkit for Cloud Computing
www.OpenNebula.org http://www.opennebula.org/ | cmar...@opennebula.org


2011/5/23 Carlos Fernández Iglesias cigles...@cesga.es

 Hello,

 I've noticed that when a host is deleted from opennebula it's information
 is also deleted from the database. This also applies to images, networks and
 users.

 For accounting purposes it will be great to have none of the database
 information erased as you may need that info in some scenario, and it may
 not be there.

 Is there some way to prevent this from happening?

 Thanks.
 ___
 Users mailing list
 Users@lists.opennebula.org
 http://lists.opennebula.org/listinfo.cgi/users-opennebula.org

___
Users mailing list
Users@lists.opennebula.org
http://lists.opennebula.org/listinfo.cgi/users-opennebula.org


[one-users] Keep all the data from host_pool

2011-05-23 Thread Carlos Fernández Iglesias

Hello,

I've noticed that when a host is deleted from opennebula it's 
information is also deleted from the database. This also applies to 
images, networks and users.


For accounting purposes it will be great to have none of the database 
information erased as you may need that info in some scenario, and it 
may not be there.


Is there some way to prevent this from happening?

Thanks.
___
Users mailing list
Users@lists.opennebula.org
http://lists.opennebula.org/listinfo.cgi/users-opennebula.org