topic Re: MySql Is really that bad? in Nuxeo Forum

MySql Is really that bad?

lethal2k18_ — Wed, 09 Nov 2011 19:58:55 GMT

I want to know how really bad is MySql, or if im missing some configuration, i didnt have any issue with the default nuxeo configuration (H2+Derby) but when i configure nuxeo to work with MySql a lot of issues begin to show, time connection errors, unknown errors when i try to reach some folders, content not displayed,and the list goes on and on, ive readed the documentation, and the only configuration that its mentioned is the JBOSS configuration, and i have TOMCAT, plus it just say that the only configuration needed its the my.cnf lower_case_table_names=1, besides that and the autoReconnect=1 do i have to do something else?

Re: MySql Is really that bad?

Benjamin_Jalon1 — Wed, 09 Nov 2011 23:05:25 GMT

We strongly recommend for our customers to use PostgreSQL or Oracle or MS SQL for production and H2/Derby for test. We have created an entry into the documentation to explain why we think Nuxeo on MySQL is a bad idea.

Re: MySql Is really that bad?

Florent_Guillau — Mon, 21 Nov 2011 19:33:41 GMT

Nevertheless in normal basic use MySQL should be ok and you should never have unknown errors and weird stuff happening.