best mysql version for production server DB under Red hat linux

vensali used Ask the Experts™
We are selecting mysql as production db for our new Health care application roll out. as there are 4 versions available, i need the expert  advise for the best version to select.

MySQL Community Edition  -- free
MySQL Standard  - paid
MySQL Enterprise  - paid
MySQL Cluster Carrier Grade  - paid
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2017
Distinguished Expert 2018
How many servers will you be utilising - more than 1.
Do you plan to implement fail over?
Do you plan to implement clustering?
Do you plan to implement replication?
Will you need 24x7 support if something goes wrong?

It is not a simple question to answer - each of those products cater to a certain segment of the market - we would need to know where you fit in.

Essentially the DB engine is the same across all of them - it is the addons you get with each product and the support that you are paying for.

Here is a comparison chart of what each version offers.
Work through it looking for what you need and take the first product from the left that has all the ticks next to the functions you require.
Distinguished Expert 2017

Presumably you are developing software to access/store data, you should use the paid version unless you are ok with providing what you develop under the terms of the GPL or the other similarly situated licensing terms of open source .........

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial