Note: Please go to docs.rightscale.com to access the current RightScale documentation set. Also, feel free to Chat with us!
Home > FAQs > Upgrade from MySQL 5.1 to MySQL 5.5 ServerTemplate

Upgrade from MySQL 5.1 to MySQL 5.5 ServerTemplate

Q: Does the RS upgrade scripts run the mysql_upgrade command?

Ans: No, currently our templates weren't designed to do a MySQL version upgrade. Presumably this is because Oracle suggests a complete DB dump and import as the "best" way to do a major version upgrade (even though the migration script should work fine), which is why the version checking was put into place with an override.  Since we already detect the MySQL version of the DB I think it's a good idea to run 'mysql_upgrade' when we detect that we're upgrading the version.  This feature is on the roadmap and will be included in the next revision of the template.  We'll make sure to update the documentation to warn users that there could be a potential problem with upgrading this way, but under the circumstances it makes sense to add the feature.
 
Q: Do you know the error that we are seeing? have you seen this in your testing?
call createMultiFolderUser(520002, "qauser3", "XXX", "folder://local//mnt/emailFolderProvi...folder/qauser3", 3002, 2000002, 1)
ERROR 1548 (HY000) at line 1: Cannot load from mysql.proc. The table is probably corrupted
Ans: The error that you're seeing is common when migrating between major revisions because of changes to the schema of the mysql table.
 
Q: We are able to run the mysql_upgrade command which seem to imply that the RS upgrade scripts are not doing this. 
Ans: We'll certainly need to use your script during the upgrade. We expect we'll see this feature rolled into the next MySQL infinity release and the next 12.11 LTS maintenance release.
 
You must to post a comment.
Last modified
21:29, 16 May 2013

Tags

Classifications

This page has no classifications.

Announcements

None


© 2006-2014 RightScale, Inc. All rights reserved.
RightScale is a registered trademark of RightScale, Inc. All other products and services may be trademarks or servicemarks of their respective owners.