| Summary: | Test upgrade of RHOS 3.0 mysql 5.1 databases to mariadb 5.5 database for RHOS 4.0 | |||
|---|---|---|---|---|
| Product: | Red Hat OpenStack | Reporter: | Perry Myers <pmyers> | |
| Component: | distribution | Assignee: | Lars Kellogg-Stedman <lars> | |
| Status: | CLOSED ERRATA | QA Contact: | Daniel Korn <dkorn> | |
| Severity: | high | Docs Contact: | ||
| Priority: | urgent | |||
| Version: | 3.0 | CC: | ajeain, apevec, lars, markmc, pablo.iranzo, yeylon | |
| Target Milestone: | rc | Keywords: | TestOnly | |
| Target Release: | 5.0 (RHEL 7) | |||
| Hardware: | Unspecified | |||
| OS: | Unspecified | |||
| Whiteboard: | ||||
| Fixed In Version: | Doc Type: | Bug Fix | ||
| Doc Text: | Story Points: | --- | ||
| Clone Of: | ||||
| : | 1060926 (view as bug list) | Environment: | ||
| Last Closed: | 2014-07-08 15:12:29 UTC | Type: | Bug | |
| Regression: | --- | Mount Type: | --- | |
| Documentation: | --- | CRM: | ||
| Verified Versions: | Category: | --- | ||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | ||
| Cloudforms Team: | --- | Target Upstream Version: | ||
| Bug Depends On: | ||||
| Bug Blocks: | 1005583, 1060926 | |||
|
Description
Perry Myers
2013-10-09 12:58:33 UTC
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 > afterwards. 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. 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 Finally: - 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. http://rhn.redhat.com/errata/RHEA-2014-0845.html |