MySQL 5 on its way

[Matt]

Due to popular demand, we will begin upgrades on MySQL 4.1 to bring it to version 5 starting the week of Monday, August 14th, 2006 and continuing throughout the week until all shared and fully managed dedicated servers are completed. If you have a semi-managed dedicated server or a fully managed dedicated server, you must request this upgrade, it will not be done automatically for you.

This upgrade will entail a brief period of database inaccessibility due to the fact the we need to shut the database server down to perform the upgrade. Once it has been upgraded we will restart the database server.

This will not affect any other services on your machine. Mail and web services should run fine. PHP and other scripts that rely on MySQL for functionality will be temporarily disrupted.

We plan on doing this as late at night as possible for the least possible disruption during regular business hours.

This should only take 15-30 minutes to complete if all goes well.

Please make certain that your scripts are up to date and compatible with mysql 5.0. We will be keeping the haylee server on mysql 4.1 for those of you that inadvertantly have problems with the upgrade you may host your sites their temporarily while you upgrade any incompatible scripts.

Problematic scripts know to break on this uppgrade are almost all OSCommerce-based shopping carts including creloaded, oscmax and zend cart. Invision Power Board also has issues with this upgrade.

We have found and created patches for some of these scripts that you may find useful.

Shopping Carts:

OS Commerce and MySQL 5 patch
Zen Cart MySQL 5 patch
Creloaded MySQL 5.0 Patch
OSCmax MySQL 5 Patch
advanced_search_result.php patch for MySQL 5

Invision Power Board:

Invision Power Poard MySQL 5 Patch

Other:

General information Regarding MySQL 5 JOIN issues


Please check this thread as we will post the servers in real time that are undergoing the upgrades, as well as when they are completed. This will prevent you from having to open a ticket to ask us if the upgrades have been completed. If the upgrades have been completed, and you have errors on your site, then please open up a support ticket and we will try to assist.

[Matt]

Missy Server has been completed. Will post more as we go along....

[sergey]

We are going to upgrade MySQL on the Alex, Fran and Ginger servers tonight in 1-2 hours. We will post once the upgrade is completed.

[sergey]

The Alex server has been completed. MySQL is being upgraded on the Fran server now.

[sergey]

The Fran server has been completed. We are upgrading MySQL on Ginger now.

[sergey]

We have completed the upgrade of MySQL on Ginger. The other servers will be done tomorrow. We will post 1-2 hours before we start the upgrade on the rest servers.

[sergey]

MySQL will be upgraded on Izzy, Lisa and Nicole servers tonight in 1-2 hours. We will post when the upgrade is completed on each server.

[sergey]

The Izzy server has been completed. We are upgrading MySQL on Lisa now.

[sergey]

We have completed the upgrade of MySQL on Lisa. MySQL is being upgraded on the Nicole server now.

[sergey]

The Nicole server has been completed.