Upgrading to MySQL 5.0.38 on RHEL and CentOS
March 26, 2007 by Jason · 14 Comments
Well, MySQL has released another Enterprise-only version. Not only are there no binary packages for the community, but they haven't even bothered to post a link to the source on the download page. Why they do this, I don't know, because it would really only take another 15 seconds to update the link to the source package on the community release page. As it stands, in order for someone to find out about this release they'd either have to be crawling the MySQL FTP site or watching the Enterprise edition release logs.
In any case, not to be left behind just because I "can't afford"/"refuse to pay" $600 (minimum) per server, I have once again built packages to provide a community release of the newest stable version of MySQL.
Continue Reading 'Upgrading to MySQL 5.0.38 on RHEL and CentOS' »
Announcing the Utter Ramblings EL4 repository
March 14, 2007 by Jason · 33 Comments
If you're a regular reader of the site, you may have noticed the "Yum Repository" link at the top of the page. If so, congratulations, you're one of the first to try out a new service I'm offering on this site.
As it appears, most of the posts on this blog thus far have been how-to's on updating your RHEL & CentOS servers to use the newest versions of httpd, PHP, and MySQL. I'm still planning on creating those articles as needed, but only the source packages will be linked to the page. Binary releases for i386 (x86-64 coming soon) will now be available for easy updating through my brand new yum repository (and yes, before you ask, 'up2date' can read a yum repo).
I'm hoping that this will cut down on not only the effort required to update your systems, but also on the possible glitches that can come from updating a complex set of packages like PHP (where, with prior provided methods, you'd need to type out all of the file names that you wanted to install all at once, otherwise you'd have dependency issues with upgrading from an earlier release).
Continue Reading 'Announcing the Utter Ramblings EL4 repository' »
Upgrading to MySQL 5.0.37 on RHEL and CentOS
March 9, 2007 by Jason · 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' »
Update to “Upgrading to MySQL 5.0.36 on RHEL and CentOS”
March 8, 2007 by Jason · 7 Comments
If you followed my earlier guide on Upgrading to MySQL 5.0.36 on RHEL & CentOS 4, you don't really need to read this. If you haven't, you may want to read the other for reference, but I would strongly recommend that you follow this guide instead.
Continue Reading 'Update to “Upgrading to MySQL 5.0.36 on RHEL and CentOS”' »
Upgrading to MySQL 5.0.36 on RHEL and CentOS
March 6, 2007 by Jason · 9 Comments
Let me start by saying, "yes, I know that MySQL 5.0.36 isn't on the download page yet". That's because this is an enterprise-only release under the Monthly Rapid Update program. That said, there is absolutely nothing preventing the build of this version as a community release.
As with my prior release of MySQL 5.0.33 for RHEL & CentOS 4, the i386 binary packages and the src.rpm are packaged in the "Red Hat"-style that is used for the RHEL-, CentOS-, and Fedora-distributed packages. That means that the client & shared libraries are packaged as "mysql", that the "mysqld" daemon is packaged as "mysql-server", etc.
Continue Reading 'Upgrading to MySQL 5.0.36 on RHEL and CentOS' »
Upgrading to MySQL 5.0.33 on RHEL and CentOS
January 12, 2007 by Jason · 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 Jason · 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' »