Upgrade from MySQL 5.5.20 wsrep 23.4 to MySQL 5.5.23 wsrep 23.5 : Severalnines Support

Forums/Knowledge Base/MySQL Galera

Upgrade from MySQL 5.5.20 wsrep 23.4 to MySQL 5.5.23 wsrep 23.5

Johan
posted this on April 27, 2012 16:42

This is applies to Commercial users only:

Download the New Version

Go to

https://launchpad.net/galera/2.x/23.2.0

Debian/Ubuntu users should download:

Redhat/Centos users should download:

Create a new Software Package and Upload

Go into the CMON web interface: http://127.0.0.1/cmon/software.php?cid=1

Create a new Package, I called it "5.5.23 - wsrep 23.5".

Upload the new Version to the package so it looks like (this is a Debian/Ubuntu view). You MUST upload the Galera provider!

galera-23.5-upgrade.png

Make sure you have selected the new Package for Deployment and press Save Changes.

Install the new Software Package

RPM Install : A rolling restart is performed during the 'Install' of the new package. This is because the rpm upgrade implicitly performs a stop/start of the MySQL service. This is beyond the control of Severalnines.

Now move into Upgrade:

http://127.0.0.1:8080/cmon/upgrade.php?cid=1

Verify that the Package to install is indeed the package you created!

Press Install and follow the Progress in Job Messages.

When the Install has finished you should perform a Rolling Restart

Perform a Rolling Restart

Go to: http://127.0.0.1:8080/cmon/upgrade.php?cid=1

And press 'Rolling Restart'.

There will be a checkbox "Perform an initial rolling restart", that can be ignored. It is not applicable in Galera, and not used (will be removed from web gui).

During the Rolling Restart one Server at a time will be upgraded. In the picture below you see that ubuntu02 has been updated (see the Version),

Don't hesitate to contact us on support.severalnines.com if you have questions how to do this.

Comments

Bradley Watkins

I'm having an issue trying to upload the files necessary to perform the upgrade I'm getting this error when I attempt to do so:

"Invalid file - upload failed"

Any hints?

May 19, 2012 04:04

Johan

Severalnines

Hi Bradley,

A couple of questions:

* What OS are you using?

* What browser are you using?

* What CMON version are you using - i do recommend you upgrade to 1.1.27 if you are not on that already?

Best regards,

May 20, 2012 22:39

This is on Fedora 16 and I've tried both Firefox and Chrome. I did upgrade to cmon 1.1.27 before I tried the MySQL upgrade.

May 21, 2012 12:35

Hi,

Do you have any errors in /var/log/httpd/error_log ?

If you want, you can email it to me on johan@severalnines.com or paste the last lines here after trying to do the upload to see if there are any apache issue.

Thanks ,

May 21, 2012 12:58

Add a comment