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)
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).