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.
2 replies Latest Post - 2012-08-29T14:47:22Z by SystemAdmin
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 PostsACCEPTED ANSWER
Re: Recommended Database to Install with Worklight Server?2012-08-29T08:57:56Z in response to SystemAdmin> 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.