Support for MySQL 5.1 and PHPMyAdmin 3

[cpanelkenneth]

Note: This is also an announcement. However it is better served as a thread.

Summary
cPanel now supports MySQL 5.1 and PHPMyAdmin 3

Details
A new interface for managing the process of upgrading MySQL is available as of cPanel 11.25.0 build 41963. The new interface is found in the Software section in WHM. The MySQL version selection is removed from Tweak Settings. Support for MySQL 5.1 and PHPMyAdmin 3 are limited to cPanel 11.25.0 and higher.

Rather than being a simple radio buttton in Tweak Settings, as in prior versions, the MySQL Upgrade interface walks you through the upgrade process. This process typically includes rebuilding PHP for Apache and sometimes for cPanel. The majority of the process may be accomplished unattended.

The interface only supports upgrading versions, for example from MySQL 4.1 to MySQL 5.1. It does not support down grading. Down grades are not recommended.

As part of the MySQL upgrade, the version of PHPMyAdmin installed may change. This happens when upgrading from MySQL 4.0 or 4.1 to MySQL 5.0 and higher. We now provide PHPMyAdmin versions 2 and 3.

PHP Version Incompatibility
PHPMyAdmin 3 is not compatible with PHP 4. cPanel provides PHP 5.2.6 for the internal PHP binary. This binary, at /usr/local/cpanel/3rdparty/bin, is used to serve the internal PHP applications that ship with the product, such as PHPMyAdmin. If this binary has been modified, or overwritten to be PHP 4, then complications will arise with PHPMyAdmin upon upgrading MySQL to 5.0 or higher.

Further information about the MySQL Upgrade interface and process will be
available in the cPanel 11.25 documentation.

We look forward to any feedback you may have regarding this new feature.

[DjiXas]

Mega awesome!

Since cPanel now allows upgrading to 5.1, I was wondering, what's the best
way to migrate accounts?

I am moving accounts now from 4.1 server to 5.0.

Shall I just upgrade to 5.1 from 5.0 and continue moving them (will cp convert
dbs from 4.1 > 5.0 > 5.1?) or it's better to finish account move so
all accounts would be 5.0 and then start 5.1 conversion process?

[cpanelkenneth]

Originally Posted by DjiXas

Mega awesome!

Since cPanel now allows upgrading to 5.1, I was wondering, what's the best
way to migrate accounts?

I am moving accounts now from 4.1 server to 5.0.

Shall I just upgrade to 5.1 from 5.0 and continue moving them (will cp convert
dbs from 4.1 > 5.0 > 5.1?) or it's better to finish account move so
all accounts would be 5.0 and then start 5.1 conversion process?

cPanel makes no effort to "convert" or preserve the integrity of databases or their data during the upgrade cycle. That is wholly dependent upon the Server owner/sysadmin. The MySQL RPMs provided by cPanel will perform some necessary tasks as part of the upgrade cycle, but these are usually limited to running mysql_upgrade and similar utilities provided by MySQL.

It is strongly recommended that Server owners/sysadmins read the relevant release notes provided by MySQL. Those documents are very detailed and provide information that will help the Server owner/sysadmin to have a smooth upgrade and prevent data loss.


Please note that we only support MySQL upgrades to MYSQl 5.1 using the new tools in cPanel 11.25.0. These tools will upgrade in steps recommended by MySQL. For example a server with MySQL 4.1 that is upgraded to MySQL 5.1 will first be upgraded to MySQL 5.0 then MySQL 5.1.

[jestep]

FINALLY!

Awesome news, have been waiting for this for about a year now.

[DjiXas]

Hi,

Do you mean that when moving accounts from 4.1 to 5.0 (using cpanel copy from another server), I still need to convert those DBs to 5.0?

[cpanelkenneth]

Originally Posted by DjiXas

Hi,

Do you mean that when moving accounts from 4.1 to 5.0 (using cpanel copy from another server), I still need to convert those DBs to 5.0?

Account transfers do not move the physical database files, rather the data and table schemas are dumped on the source server, then imported on the destination server.

[DjiXas]

Sorry, I don't understand.

If I move account from 4.1 server to 5.0, do I need to do anything else apart move, or cPanel/MySQL will automatically finish the job (converting db's maybe, I don't know).

[cPanelDon]

Originally Posted by DjiXas

Sorry, I don't understand.

If I move account from 4.1 server to 5.0, do I need to do anything else apart move, or cPanel/MySQL will automatically finish the job (converting db's maybe, I don't know).

There should not be any other steps required other than performing a normal account transfer via WHM or restoring from a full account backup (e.g., "cpmove" archive).

[oulzac]

I can't upgrade, I get:

ISAM tables are still in use on this system. These tables must be manually upgraded to MyISAM before an upgrade of the MySQL server is possible.


Does this mean I have to go through all 2K+ databases on my server to check and see which DB's are using ISAM tables?

This upgrade broke phpmyadmin today, and now I have to upgrade MySQL to fix it, and I just keep getting road blocked

[cPanelDon]

Originally Posted by oulzac

I can't upgrade, I get:
ISAM tables are still in use on this system. These tables must be manually upgraded to MyISAM before an upgrade of the MySQL server is possible.


Does this mean I have to go through all 2K+ databases on my server to check and see which DB's are using ISAM tables?

Starting in MySQL 5.0 support for the ISAM storage engine was removed in favor of using MyISAM. Please see the following MySQL documentation resource for conversion information: MySQL :: MySQL 5.0 Reference Manual :: 2.18.1.2 Upgrading from MySQL 4.1 to 5.0

Incompatible change: Support for the ISAM storage engine has been removed in MySQL 5.0. If you have any ISAM tables, you should convert them before upgrading. For example, to convert an ISAM table to use the MyISAM storage engine, use this statement:

ALTER TABLE tbl_name ENGINE = MyISAM;

Use a similar statement for every ISAM table in each of your databases.

Additional reference: MySQL :: MySQL 3.23, 4.0, 4.1 Reference Manual :: 13.10 The ISAM Storage Engine

Due to the deprecated status of ISAM, and because MyISAM is an improvement over ISAM, you are advised to convert any remaining ISAM tables to MyISAM as soon as possible.

Originally Posted by oulzac

This upgrade broke phpmyadmin today, and now I have to upgrade MySQL to fix it, and I just keep getting road blocked

For re-installing phpMyAdmin (via root SSH access) please refer to the following thread: phpMyAdmin broke with 11.25 upgrade - cPanel Forums

[radeonpower]

Are there any major changes between 5.0 and 5.1? Can I safely upgrade without worrying about failure of websites?

[cpanelkenneth]

Originally Posted by radeonpower

Are there any major changes between 5.0 and 5.1? Can I safely upgrade without worrying about failure of websites?

The answer to that will depend upon your own analysis after:

1. Exploring what your customers are using; and
2. Reading the MySQL 5.1 Release Notes provided by MySQL

[radeonpower]

Thanks, how can I update MySQL and phpMyAdmin?

[cPanelDon]

Originally Posted by radeonpower

Thanks, how can I update MySQL and phpMyAdmin?

Please refer to the following post for details including the WHM menu path, documentation, and applicable release notes: cPanel Forums - View Single Post - Inquiry about MySQL 5.0 FINAL

[smoge]

you may want to rename your my.cnf to something else before doing this upgrade - as it seems that an older my.cnf can cause problems with the WHM upgrade script / mysql upgrade.

Any comments from cpanel techs on this?