[one-users] Configurable location for $ONE_LOCATION/var/one.db ?

[Javier Fontan]

Hello,

There's no way to specify the path of the sqlite database. The onlyway
I see to move the sqlite database without modifying he source codeis
moving the database to other local place and symlinking it to
where'oned' expects it to be.

Anyway, if you have a production installation, or at least you
areusing OpenNebula for more than testing how it works I would go
forMySQL. Performance is much better and you can even play with
databasereplication to have your data safe.

Cheers

On Wed, Oct 26, 2011 at 4:20 PM, Robert Parrott
<parrott at seas.harvard.edu> wrote:
> Hi,
>
> We got stung with this issue as well. Our short term approach was to
> create an iscsi mount (i.e. block storage) and put everything in var/
> there, and migrate to MySQL when we have a window of downtime.
>
> As far as I can tell there's no way in ONE to specify that the DB
> location should be separate from the other contents of /var/lib/one or
> $ONE_LOCATION/var, which is why we used a different protocol. I
> consider this a defect, though I haven't filed a ticket on it.
>
> Rob
>
>
> On Wed, Oct 26, 2011 at 10:01 AM, Steffen Neumann <sneumann at ipb-halle.de> wrote:
>> Hi,
>>
>> I have to move one.db (which is currently living on an NFS volume,
>> which is dangerous according to the docs[1]) to a local filesystem
>> on the head node.
>>
>> Where do I specify the path to one.db ? The documentation [2]
>> does not mention further arguments in oned.conf DB section
>> DB = [ backend = "sqlite" ].
>>
>> The only reference to a variable DB location I found was
>> DB: sqlite:///var/one/oneacct.db in $ONE_LOCATION/etc/acctd.conf
>> but nothing for one.db.
>>
>> Do I need to hack the source or switch to MySQL ?
>>
>> Serving $ONE_LOCATION from a central storage/NAS might be a common
>> scenario, so this could be a fairly important issue.
>>
>> Yours,
>> Steffen
>>
>> [1] http://opennebula.org/documentation:rel3.0:sfs
>> [2] http://opennebula.org/documentation:archives:rel2.2:oned_conf
>>
>> --
>> IPB Halle                    AG Massenspektrometrie & Bioinformatik
>> Dr. Steffen Neumann          http://www.IPB-Halle.DE
>> Weinberg 3                   http://msbi.bic-gh.de
>> 06120 Halle                  Tel. +49 (0) 345 5582 - 1470
>>                                  +49 (0) 345 5582 - 0
>> sneumann(at)IPB-Halle.DE     Fax. +49 (0) 345 5582 - 1409
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opennebula.org
>> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>>
>
>
>
> --
> Robert E. Parrott, Ph.D. (Phys. '06)
> Director, Academic Computing
> Harvard University Sch. of Eng. and App. Sci.
> Maxwell-Dworkin  211,
> 33 Oxford St.
> Cambridge, MA 02138
> (617)-496-1520
> _______________________________________________
> Users mailing list
> Users at lists.opennebula.org
> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>



-- 
Javier Fontán Muiños
Project Engineer
OpenNebula Toolkit | opennebula.org