Upgrading to MySQL 5.0.45 on RHEL and CentOS

July 18, 2007 by · 26 Comments 

As happens every 2 months or so, the community release of MySQL has been updated. The 5.0.45 release contains a substantial number of bug fixes since the last community release (5.0.41) but perhaps more interestingly, there were about 100 bug fixes since the last Enterprise release (5.0.44) just two weeks prior! This is definitely a release that I'd recommend all users of MySQL 5.0 upgrade to.

While MySQL does provide binary RPMs for RHEL & CentOS for their community releases, the binaries provided are not packaged in the same format as those that ship with RHEL, CentOS and Fedora. For those that want to stick with the "Red Hat"-style packages, add my yum repository to your system and run a "yum update".

Continue Reading 'Upgrading to MySQL 5.0.45 on RHEL and CentOS' »

Upgrading to MySQL 5.0.41 on RHEL and CentOS

May 11, 2007 by · 14 Comments 

As happened with 5.0.36 and 5.0.37, it looks like the MySQL 5.0.40 Enterprise-only release has been followed almost immediately by a community version of 5.0.41. As the purpose of my Yum repository is to keep your LAMP stack on the bleeding-edge, I bring you RHEL/CentOS RPMs for "MySQL 5.0.41"!

I don't have an actual changelog for 5.0.40 to 5.0.41 because the only changelogs that are published are for 5.0.36 -> 5.0.38 -> 5.0.40 and 5.0.37 -> 5.0.41 for Enterprise and Community releases respectively. That said, if anyone would like to go through the changelogs for 5.0.38, 5.0.40 and 5.0.41 and find a list of differences, I'd be happy to post up the details with proper credit given.

Continue Reading 'Upgrading to MySQL 5.0.41 on RHEL and CentOS' »

Upgrading to MySQL 5.0.37 on RHEL and CentOS

March 9, 2007 by · 11 Comments 

Well, I'm back again with yet another release of MySQL. Coming only a few short days after the Enterprise release of 5.0.36 under the Monthly Rapid Update program, MySQL has decided to release 5.0.37 as a community edition.

As with my last release, this one is based on the latest Fedora src.rpm from the development tree and has been modified to use the newest source package, package new files that didn't exist before, remove patches that have been integrated into the main code-base, and, as a first for me, to add a patch to reverse part of a recent commit that breaks regression testing.

Continue Reading 'Upgrading to MySQL 5.0.37 on RHEL and CentOS' »

Upgrading to MySQL 5.0.33 on RHEL and CentOS

January 12, 2007 by · 11 Comments 

If you follow the MySQL Announcement list then you already know that version 5.0.33 was just released. Unfortunately, those of you on RHEL/CentOS (and even Fedora, at least for the time being) do not have any way to install it unless you compile from the tar.gz source because MySQL has decided to only regularly release binaries to those that pay them for the Enterprise version. Compiling from source, by the way, is something that MySQL does NOT recommend that you do, even though, at current, this is the only option that they give you. Funny, isn't it?

That said, I've taken a slightly different approach to this tutorial as compared to my "Upgrade to MySQL 5.0.27" tutorial. That how-to dealt with rebuilding the src.rpm from the FC7 development tree so that it would work on RHEL & CentOS 4. This how-to uses the spec file from the official MySQL src.rpm for 5.0.27, upgrades the source to 5.0.33, and then adapts it so that it generates RH/Fedora-style RPMs for an easy upgrade.

Continue Reading 'Upgrading to MySQL 5.0.33 on RHEL and CentOS' »

Upgrading to MySQL 5.0.27 on RHEL and CentOS

December 5, 2006 by · 23 Comments 

One of the most common technical recommendations given on the vbulletin.com forums is to upgrade your software versions to the newest available. I've already covered how to upgrade Apache's httpd and PHP so now I'm going to explain how to upgrade your RHEL/CentOS 4 system to use MySQL 5.0.27. This is not a terribly difficult process but it is VERY time consuming. Expect to spend about 10 minutes prepping and about an hour compiling (even on a high-end box).

To start, you'll need three things. First, you're going to need 'root' access to your server. If you don't have it, even if you can build the RPMs, you won't be able to install them. Second, on most machines, you'll need to install a huge list of dependencies. Finally, you'll need the MySQL src.rpm from FC7's development tree.

Continue Reading 'Upgrading to MySQL 5.0.27 on RHEL and CentOS' »