HSQL not recommended for production

[passg1]

Hi Everyone,

I've been using alfresco for a few weeks an uploaded lots of documents and such. Everything installed so smoothly that I didn't notice the alfresco.log message warning about the HSQL database not recommended for production or deployment.

I'm a bit scared because I don't want to lose all the information, but I couldn't find how risky is or what is the real problem using HSQLDB in production. Could I lose my data? Instability?

Thanks in advance.

[kevinr]

HSQL is not considered to be a "production" quality database - so there is definitely a concern. It's an embedded database we (and other opensource companies like Liferay and JBoss) only recommend for testing and evaluating products - you should then move to MySQL or whatever DB is your preference. Alfresco will start and run faster against MySQL than HSQL also.

I suggest you read this:
http://wiki.alfresco.com/wiki/Migrating_from_HSQL

Take a backup of your installation before proceeding! Then if anything goes wrong you won't lose anything.

Thanks,

Kevin