Red Hat Bugzilla – Bug 1017218
Test upgrade of RHOS 3.0 mysql 5.1 databases to mariadb 5.5 database for RHOS 4.0
Last modified: 2014-09-08 01:41:46 EDT
RHOS 3.0 users relied on the mysql 5.1 database shipped in RHEL 6.4
RHOS 4.0 users will be using mariadb 5.5 which is available as part of the Red Hat Software Collections (RHSCL)
We need to make sure that migration path from RHOS 3.0/mysql5.1 to RHOS 4.0/mariadb5.5 is well documented and stable.
This bug is to track creation of a set of scripts/HOWTO on this migration (which should be offline)
From RHSCL docs https://access.redhat.com/site/documentation/en-US/Red_Hat_Software_Collections/1/html/1.0_Release_Notes/chap-Installation_and_Usage.html#idp1872056 (just replace s/mysql55/mariadb55/)
Upgrading MySQL 5.1 to MariaDB 5.5 on RHOS 3/RHEL 6.4 seems to work smoothly just following the instructions in the RHSCL docs for an in-place upgrade.
The only additional information necessary in a HOWTO is a note about shutting down all OpenStack services before the upgrade and starting them up afterwards. I talked with pbrady briefly about adding a script to openstack-utils to make this easier, but right now it requires the local admin to both (a) which hosts comprise their openstack installation and (b) which services are active on each host.
(In reply to Lars Kellogg-Stedman from comment #3)
> Upgrading MySQL 5.1 to MariaDB 5.5 on RHOS 3/RHEL 6.4 seems to work smoothly
> just following the instructions in the RHSCL docs for an in-place upgrade.
Can you provide a link to that here for RHOS QE benefit?
> The only additional information necessary in a HOWTO is a note about
> shutting down all OpenStack services before the upgrade and starting them up
This is a prerequisite for a RHOS 3.0 to 4.0 upgrade in general anyhow, so should be part of the normal procedure until we can close gaps around doing online/rolling ugprades upstream
I was using Alan's link from comment #1 (which is correct other than the naming).
Staring with RHEL6.5/RHEL-OSP4:
- Installed RHEL-OSP4 via 'packstack --allinone' (this is MySQL 5.1)
- Shutdown openstack services
- Shutdown mysql
- Add RDO Icehouse repository
- Uninstall mysql-server
- Install mariadb-galera-server (5.5.36-9)
- Start mysql-server
- Run mysql_upgrade
- Start openstack services
Everything works with nary an error in sight.
testing per Lars comment#7.
I've Deployed a working RHOS 4.0 (latest Havana release - 2014-05-22.1)
Then followed the steps from Lars's comment:
- Stopped all openstack services
- Stopped mysql
- Added Icehouse repository (latest - 2014-05-29.3)
- Uninstalled mysql-server
- Run yum update
- Installed mariadb-galera-server
- Started mysql-server
- Run mysql_upgrade
- Started openstack services
- Verified the environment is working correctly
- Created/deleted resources (Image, Instances, storage, etc.) without any problems
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.
For information on the advisory, and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.