Home > Casper, JSS, Linux > Updating Red Hat Enterprise Linux and MySQL for Casper JSS server running on Linux

Updating Red Hat Enterprise Linux and MySQL for Casper JSS server running on Linux

In my own shop, I’m currently running Casper 8.x on a Red Hat Enterprise Linux server. The server had been set up initially with Red Hat Enterprise Linux 6.0 and MySQL 5.1.47 and it had stayed there for a while. However, I looked ahead to Casper 9.x and saw the following versions of MySQL were now listed as being required:

MySQL Enterprise Edition 5.5 or later, or MySQL Community Server 5.5 or later

I’m still running Casper 8.x, but I wanted to get ahead of the curve and not have to deal with a MySQL upgrade at the same time as a future Casper 9.x upgrade. Thanks to the Linux folks at my workplace, I was able to do so with a minimum of hassle. See below the jump for the details.

When I checked with my colleague Peter Bukowinski, it became apparent that RHEL would need to be upgraded as well in order to support MySQL 5.5.x. With that information, here was the projected start and end states.

Start state:
Red Hat Enterprise Linux Server release 6.0 (Santiago)

MySQL 5.1.47

Projected end state:

Red Hat Enterprise Linux Server release 6.4 (Santiago)

MySQL Community Server 5.5.34

One hitch was that the latest version of MySQL available from any of the official Red Hat repositories is MySQL 5.1.69. In order to upgrade to MySQL 5.5, we had two options: compile from source code, or find an third-party repository offering the necessary MySQL RPMs. Compiling from source was not an option we wanted to pursue, so we looked at other repos.

Since the official Red Hat repositories didn’t offer what we needed, we needed to identify a third-party repository that we could trust. Fortunately, there was one available that we had used before and trusted – Les RPM de Remi

Les RPM de Remi is a popular RPM repository for LAMP and one of its stated goals is “providing the latest versions of the LAMP stack, and some other software, to the Fedora and Enterprise Linux (RHEL, CentOS, Oracle, Scientific Linux, …) users.”

Remi had MySQL 5.5.34 Community Server available, so we could use this repository to update our existing MySQL installation. The remi repository has dependencies in the EPEL (Extra Packages for Enterprise Linux) repository, so we needed to install two repositories:

rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

The remi and remi-test repositories are disabled by default since their packages will often conflict with official RHEL packages. To verify availability of the required MySQL version, we have to tell yum to enable the repositories for the duration of the command shown below:

yum --enablerepo=remi,remi-test list mysql mysql-server

Screen Shot 2013-10-09 at 10.52.29 AM
Your output may differ slightly, but MySQL 5.5.x should appear as being available for installation. Assuming the existing MySQL instance was installed via RPM, which ours was, it should be possible to update MySQL in place.

Once we verified that MySQL 5.5 was an available update, we made plans for upgrading our test Casper server and then our production Casper server.
To update our Casper servers from RHEL 6.0 to RHEL 6.4, we ran the following command as root:

yum -y update

Screen Shot 2013-10-09 at 11.10.40 AM
Once updated, we ran the following command to reboot:

reboot

Screen Shot 2013-10-09 at 11.10.56 AM
Next, I updated from MySQL 5.1 to 5.5 using the following commands. All commands were run as root

Backup all databases into one MySQL dumpfile and store it as /tmp/mysql.sql:

mysqldump -u root --events --all-databases > /tmp/mysql.sql

Screen Shot 2013-10-09 at 11.08.41 AM
Stop MySQL:

service mysqld stop

Screen Shot 2013-10-09 at 11.11.36 AM

Update from MySQL 5.1 to MySQL 5.5 Community Server:

yum update mysql mysql-server --enablerepo=remi,remi-test

Screen Shot 2013-10-09 at 11.08.23 AM
Start MySQL:

service mysqld start

Screen Shot 2013-10-09 at 11.11.44 AM
Restart the Linux VM

reboot

Screen Shot 2013-10-09 at 11.10.56 AM
After the second restart, I was running the following:

Red Hat Enterprise Linux Server release 6.4 (Santiago)

5.5.34-log MySQL Community Server (GPL) by Remi

After the MySQL upgrade, the Casper software started normally and I verified that everything appeared to be working properly.

Screen Shot 2013-10-09 at 11.16.24 AM

Most of the heavy lifting in this process was done by Peter, as he was the one who researched and then put the needed repository support in place. Thanks to his expertise, I just needed to back up the MySQL databases and know the right commands to run.

Categories: Casper, JSS, Linux
  1. October 9, 2013 at 5:35 pm | #1

    I thought that –enablerepo= was enabling the repo for good, but it is not the case. Good to know

  2. Ben LeRoy
    October 18, 2013 at 6:19 pm | #2

    Worked like a charm Rich, thanks to you and your team on this!

  3. flyer228
    October 21, 2013 at 11:44 pm | #3

    Thanks, worked great for me!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 126 other followers

%d bloggers like this: