MySQL versions

Posted on 2009-02-21
Medium Priority
Last Modified: 2013-12-16
We had a discussion with our operations last week regarding to what MySQL server to install to develop a new application for one of our clients. Currently we use a 4.1.22 version and definitely we need a version higher than 5.0 as we are going to need to built views and maybe stored procedures. We are talking about Linux as OS.

As DBA my idea was to go for the last released version, which I think it is 5.1.31 but the guys from Operations said that they would like to stick with the 5.0.66 version because we already use that for another client. They want to keep a consistency in regards with the MySQL version we they install and we use at our company.

I have to admit that 5.0.66 already has the feature that we will need to implement this application and if an upgrade is anyway imminent for that client then why not use the last version of MySQL.

My question is how justified is that position to keep a consistency over the MySQL servers? What exactly would be the overheads in order to maintain different versions of MySQL from the application, operations and maintenance points of view.

As a DBA I see no problems to go directly to 5.1.31 if we upgrade anyway this client.
Question by:Zberteoc
  • 3
  • 2
  • 2
  • +1
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 400 total points
ID: 23700310
> but the guys from Operations said that they would like to stick with the 5.0.66 version because we already use that for another client.
if you have only 2 clients for that same thing, that is a defendable argument.

however, sooner or later you will get more clients, or at least 1 client/installation requesting you to upgrade to another version, while others might refuse that...
... hence requesting you to "invest" some time/resources in the management of the different versions anyhow.
so, why not start today.
LVL 27

Author Comment

ID: 23700414
That's what I said but they replied that we will do it when that time will come. For me is totally nonsense as we already use 2 versions anyway. Upgrading one to the last version will get us in the same position.

The only valid reason might be that they already have their installation/configuration scripts adapted for the 5.0.66 release from when they had to install it for the other client, which kind of make sense. In that case my question is how difficult is to adapt those scripts if they really need any modifications at all.

As I see it you just get a different installation kit and go with it, regardless of the version.
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 23700445
the differences in the mysql versions mentioned should actually be so minor that the ddl should not differ, aka what works in the 5.0.66 should also work in the 5.1.31 version.

to know for sure:
just test run on a spare test server...
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

LVL 27

Author Comment

ID: 23700468
I agree, but I am not talking about DDL here but about installations/configuration scripts they might use when preparing the box. They are the ones that install Linux and what software needed for any new server.

In regards to the application there will still be some differences, minor as you said, no matter if we upgrade to 5.0.66 or to 5.1.31. So from this respect 5.1.31 would be still preferable.

LVL 26

Accepted Solution

Umesh earned 800 total points
ID: 23700543
But I don't suggest you to go for 5.1.31 directly into production.  Its buggy and needs lots of fixes. Also, note that you are migrating from 4.1 to 5.0( or 5.1.31) which is major upgrade  and needs lots of testing before pushing this to production or live environment.

See what MySQL founder has to say about 5.1.x


Anyways, its up to you but If I had to do this.. I would have preferred first 4.x to 5.0.x in staging  and once verified all the things pushed to Live/production.
LVL 81

Assisted Solution

arnold earned 800 total points
ID: 23700602
Here is an alternate approach from the operations point.
What OS is being deployed? RHEL/Centos 5, ubuntu server, etc.? The preference is to have the mysql that comes with the OS version distribution.  This way vendor issued updates will not have an impact on the operations of the installed application.

The other point, is that operations needs to be sufficiently familiar with the newer version to quickly troubleshoot issues to determine whether the issue is the database or something else. Whether the server can be further tunned to enhance the performance.
LVL 27

Author Closing Comment

ID: 31549582
I think I got the answer now. Arnold seems to have pointed out the main issue here that of the operation point of view, which I really needed to understand.

Thank you usharty and angel for the links, very informative, and for your answers.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Suggested Courses
Course of the Month15 days, 14 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question