As you may have heard in recent communications, Rackspace Cloud Sites will be upgrading all MySQL database servers from MySQL 5.0 to MySQL 5.1 beginning in early 2013. The planned start date has been postponed from the original date of August 2012. Below are some key highlights to consider during the upgrade.
| What problems might be encountered after upgrading 5.0 to 5.1? |
|---|
|
There are many possible answers to this but the best way to answer this is to consult the official MySQL documentation 2.13.1.1. Upgrading from MySQL 5.0 to 5.1 |
| Could I lose data during the upgrade? |
|---|
|
No. The upgrade is done in place on a block level copy of the databases on a slave machine and any failure in the process will rollback to an untouched 5.0 copy of the databases on the master machine.
|
| Will my hostname change? |
|---|
|
Hostnames may eventually be changed to provide more uniformity in naming, however, no change will occur during this upgrade process. Thus, at this time, no code changes will be required to update your connection strings.
|
| Will my host IP change? |
|---|
|
The IP designation of the database for external connections will remain the same and will not change as a result of this upgrade.
|
| What differences will I see? |
|---|
|
Beyond increases in stability and performance you should generally not be able to detect any changes in the operation of your database. However, due to the fact that MySQL 5.1 has seen improvements in foreign key handling, greater RFC compliance and error handling advancements it is possible that web applications may encounter errors that previously they did not. This is actually a good thing, in that MySQL 5.0 did not report such errors and allowed data to be entered or deleted by the application when it should have been prevented. Application code that is faulty may now report errors and/or halt where before it was allowed to continue regardless of propriety.
|
| Will my website be down during the upgrade, if so, how long? |
|---|
|
In order to obtain a perfect snapshot of data the database must be taken down completely for a period of 10 to 15 minutes. Directly after that hard down time the database will be in a read-only state for 30 to 45 more minutes while the in place upgrade is being performed. Full function will return directly after the upgrade is completed in 40 minutes to an hour after the upgrade maintenance window begins.
|
| Will I need to make any changes once the migration is complete? |
|---|
|
Generally speaking no, you will not have to make changes once the migration is complete. Base post migration tasks will be performed for you to ensure that tables, views, indexes, functions and procedures are repaired if necessary. You may however need to make adjustments to application code, user defined functions, and/or stored procedures if the advanced error handling of MySQL 5.1 causes non-compliant code to fault.
|
| Will I be able to fall back to 5.0 if I come across issues after the upgrade? |
|---|
| During the upgrade process if a problem with the upgrade should arise we will rollback to the MySQL 5.0 version until deficiencies preventing the upgrade have been resolved, however, once the upgrade to MySQL 5.1 is complete there will be no opportunity to downgrade. As stated by ORACLE, MySQL 5.0 has reached the "End of Product Lifecycle" and "Active development for MySQL Database Server version 5.0 has ended.", consequently that version of the server will be deprecated permanently. |
© 2011-2013 Rackspace US, Inc.
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License
