Q

Choosing between MySQL 4.0 and MySQL 5.0 for client server app development

MySQL expert Mike Hillyer explains why sometimes IT shops should be aggressive with newer versions of MySQL.

In our company, we are plan to develop a client server application using PHP and MySQL. We are planning to use either MySQL4 or MySQL5. Which is better preferable? Is MySQL5 more stable?

Your choice will depend on what you need from your MySQL server. At a bare minimum, you should be using the latest release of MySQL 4.1. From there we need to look at your needs. Do you need Stored Procedures? Views? Triggers?

The full list of what MySQL 5.0 adds is available here. The tradeoff is that ,while MySQL 5.0 is declared production-ready, it is less proven than MySQL 4.1.

For a shop that is in the planning stage or development stage of a project, I would recommend being more agressive with the version of MySQL used because as you develop and mature your product, the version of MySQL you have chosen will also mature. As such, you may even want to look at the feature list of MySQL 5.1 and see if there are features you can take advantage of.

This was first published in April 2006

Dig deeper on Linux administration tools

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close