mycontroller-org / mycontroller-v1-legacy

The Open Source Controller
http://www.MyController.org
Apache License 2.0
148 stars 90 forks source link

Move H2 database to external storage #368

Closed Redferne closed 7 years ago

Redferne commented 7 years ago

I tried to move the H2 database to a NFS server by changing this in mycontroller.properties.

mcc.db.url=jdbc:h2:file:../conf/mycontroller;MVCC=TRUE

to

#mcc.db.url=jdbc:h2:file:/mnt/nfsdisk//mycontroller;MVCC=TRUE

But I does not pick up the new location?

jkandasa commented 7 years ago

@Redferne can you try mcc.db.url=jdbc:h2:file:/mnt/nfsdisk/mycontroller;MVCC=TRUE

Just I removed // in >> nfsdisk//mycontroller

jkandasa commented 7 years ago

@Redferne Did this worked?

Redferne commented 7 years ago

Yes. I was hoping for an increase in access speed for the database by hosting it on a fileserver. But that did not pan out. Thanks!