HSQL verse MYSQL

[b33gopher]

I am running Ubuntu 14.04 64bit with OpenKM 6.4.15. Processor: Intel Xeon CPU E3127 3.4 GHz RAM: 2.0GB RAM. I am wondering when is it appropriate to use the default HSQL verses MySQL? What are the limitations of HSQL verses MySQL? We will roughly be storing about 300,000 documents at any given time with each document being about 2MB in size. I am leaning towards MySQL but need some guidance as to how to migrate from HSQL to MySQL. Here are links I've found but do they still apply to 6.4.15?

http://wiki.openkm.com/index.php/MySQL_-_OpenKM_6.2
http://forum.openkm.com/viewtopic.php?f ... SQL#p29422
http://wiki.openkm.com/index.php/Migrat ... .11_to_6.2

[pavila]

NEVER use HSQL in production. ALWAYS use a real database like MySQL or PostgreSQL.

[b33gopher]

Pavila,

Thanks for the reply. Yes, it was my intention to not use HSQL in production as I've come across a few posts that indicate it is not acceptable for production systems. We are in the process of trialing the software and have not gone live yet. I was curious as to the differences between the two from a technical perspective and the process on how to migrate from HSQL to MySQL using our specific version. I have installed MySQL and OpenKM on another system using the same OS to test the migration process. The documentation wasn't clear if the processes would still work with 6.4.15.

[pavila]

But OpenKM 6.4.15 is a trial from the Professional version.

[b33gopher]

I take that to mean, the trial isn't capable of working with MySQL only HSQL?

[pavila]

Trial may work with different databases. I mean, that the trial is for testing and will expire.