Problem solve Get help with specific problems with your technologies, process and projects.

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.

Dig Deeper on Linux servers

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.