I am installing WL 5 Server in Ubuntu 12.04. I know I have a choice to install it with Derby, add configuration for a pre-installed DB2, or configure for MySQL (or anything else) after install.
All three options are relational SQL based databases, so I know this question might be hard to answer, but:
Is there a preferred database, or one that is "officially" supported (vs just available)?
It seems having Derby installed and configured during installation would be the best choice. Are there other considerations that would make DB2 or MySQL a better choice?
This topic has been locked.
Pinned topic Recommended Database to Install with Worklight Server?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
slowhand 110000R3FM35 Posts
Re: Recommended Database to Install with Worklight Server?2012-08-29T08:57:56ZThis is the accepted answer. This is the accepted answer.> Is there a preferred database, or one that is "officially" supported (vs just available)?
All 4 choices (Derby embedded, MySQL, DB2, Oracle) are officially supported, see the system requirements page.
What is preferred, depends on your use.
- In an enterprise production environment, you will want a scalable database server. I think this means DB2 or Oracle.
- In a small department's production environment, a small database server will do. I think this means DB2 (Express edition) or MySQL.
- For a single developer's machine, Derby embedded fits the bill better: Unlike the other three choices, it does not require a database server process (that eats up memory), and it has zero setup costs.
SystemAdmin 110000D4XK300 Posts
Re: Recommended Database to Install with Worklight Server?2012-08-29T14:47:22ZThis is the accepted answer. This is the accepted answer.Thanks a ton, that is exactly the info I was looking for.