best mysql version for production server DB under Red hat linux

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
vensaliAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Julian HansenCommented:
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.
http://www.mysql.com/products/
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
arnoldCommented:
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 .........
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.