Upgrade from Galera 1.1.0 to 2.0.0

This article describes how to upgrade (online) from Galera 1.1.0 to 2.0.0. Rolling restarts is only supported in the Commercial Version.

Pre-requisite: Upgrade to cmon 1.1.24

Avoid upgrading during Peak Times if possible!!

Download Galera 2.0.0

Two components must be downloaded:

The Galera Replicator
The Galera Enabled MySQL server

Galera Replicator Library (PROVIDER)

Ubuntu 64-bit : Download Galera Provider here . The link is https://launchpad.net/galera/2.x/23.2.0/+download/galera-23.2.0-amd64.deb

Redhat 64-bit: Download Galera provider here. The link is https://launchpad.net/galera/2.x/23.2.0/+download/galera-23.2.0-1.rhel5.x86_64.rpm

Galera Enabled MySQL Server (MYSQL SERVER)

Ubuntu 64-bit: Download here. This is the link https://launchpad.net/codership-mysql/5.5/5.5.23-23.5/+download/mysql-5.5.23_wsrep_23.5-linux-x86_64.tar.gz

Redhat 64-bit: Download here. This is the link https://launchpad.net/codership-mysql/5.5/5.5.23-23.5/+download/MySQL-server-5.5.23_wsrep_23.5-1.rhel5.x86_64.rpm

At this stage you should now have:

cmon 1.1.27 installed and running on all hosts (verify in host management)
two files downloaded (either two files for Ubuntu or two files for Redhat) - remember the location of these.

PLEASE NOTE THAT EXACT VERSION NUMBERS MAY DIFFER!

Create Software Package

You now need to create a Software Package (in the CMON Web UI go to "Software Packages", and you will see the following.

Enter a name and press Create, we have used the name 'galera-2.0.0',

In the section "Upload File to Existing Package", select the package you created from the dropdown menu and press "Choose file", navigate to the files you downloaded, and pick one (start with galera-23.2.0-amd64.deb), and press upload.

Repeat the above once more to upload the MySQL Server file downloaded above. Make sure it is added to the same package as the 'galera' file.

The package MUST contain the PROVIDER and the MYSQL SERVER, thus two files that is.

When done you should have it like this (this is showing a package that will be installed on an Ubuntu system):

Make sure you select the new package for deployment (Press the radio button next , and press Save Changes).

Install the Software Package

Now go to Upgrade (right menu bar), and you will see this:

If you look closely, you will see that the selected Package name is 'galera-2.0.0', and this is the same as we uploaded the files into.

Do step 1) and press Install, then you want to go to Job Message and look that it is getting installed everywhere. Not, we have not yet upgraded, just copied out the files for the new version and installed them in the correct locations.

In the job messages you will see a lot of Job Messages (detailed view):

Eventually the Job will be Finished or Failed, if a problem was encountered (in that case let us know).

After the job has Finished, go back to "Upgrade", and proceed with Step 2a, Rolling Restart.

The rolling restart will start and you will see Job Messages like:

But in the meanwhile, you will also see that it for each node it is restarting, that it is also doing Galera Node Recovery. All in all, when done, the Job Messages list will look like:

Now, your cluster has been upgraded to 2.0.0 (and it was online during this time).

Chris

March 25, 2012 11:20

Cannot upload MySQL server TAR file under Debian 6 64bit. After file upload, there is a short message "Invalid file - upload failed". PHP setup allow upload up to 250MB. What is the root couse?

Chriss

Johan

March 25, 2012 22:00

Hi Chriss,

What is written in /var/log/httpd/error.log or /var/log/apache2/error.log ?

Also, is it a tar.gz file you upload?

BR
johan

March 26, 2012 14:42

Yes, it`s a tar gz as my system is Debian. System (Apache2) error log is clean - only few entrys aby missing favicon.ico file. Check the file attached.

Maybe there is someting broken. I have also a problem with one node, as we are already mailing in different topic. Maybe they are connected?

March 26, 2012 23:50

Ok, problem solved.

My system is Win7 and latest Firefox - upload file is reported as x-tar (not x-gzip). After modify of line 132-133 of the file lib/shared/mgmt/software.php upload not fail.

Is it my problem only or general issue? Under Chrome is the same - wrong value in $_FILES["file"]["type"] (PHP 5.3.3-7+squeeze8 with Suhosin-Patch (cli) (built: Feb 10 2012 13:05:56)).

March 27, 2012 00:00

Me again....

I`ve forgot - update works only with full licence. If we do not have one, from cli the script to fire is deploy or install-deb & install-mysql respectivly ?