Difference between revisions of "Mysql"

Revision as of 10:34, 10 July 2010

Features

• Based on Mysql 5.1.x branch
• Uses the design from Fedora, RHEL, and CentOS

Installation

To Upgrade to Mysql 5.1 on CentOS/RHEL/Fedora

Steps 3 and 4 only apply if you are upgrading from MySQL 5.0.x See version differences in following link http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html

Step 1) Set up the atomic channel (See Getting_Started):

wget -q -O - http://www.atomicorp.com/installers/atomic | sh

Step 2) Upgrade to Mysql 5.1

yum upgrade mysql

Step 3) MySQL 5.1 removed the BERKLEY storage engine. Since it was not commonly used, to save resources it was recommended this be turned off. You must comment the following out or remove it from /etc/my.cnf or MySQL 5.1 will not start!

skip-bdb

Step 4) Update your MySQL tables

mysql_upgrade -u root -p

or for Plesk environments (and then the NOTE - this is the exact same login as the Plesk superuser e.g. use "-u admin" and then your admin password):

mysql_upgrade -u admin -p

Step 5) Restart mysql

/etc/init.d/mysqld restart

Support Packages

Mysqltuner, an excellent tool for investigating performance issues with mysql

 yum install mysqltuner

Known Issues

Problems with MySQL databases and PLESK 9 after upgrade

If you get the following error after upgrading when you try to log into PLESK then you need to upgrade your database tables:

ERROR: PleskFatalException
bad column in table: `backup_time` time NOT NULL default '00:00:00',
[...]

Issue the following command from the shell:

mysqlcheck --check-upgrade --all-databases --auto-repair -u admin -pyouradminpassword

followed by:

cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=admin --password=youradminpassword --host=localhost --database=mysql

This script updates all the mysql privilege tables to be usable by the current version of MySQL.

References:

[1] http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html

[2] http://forum.parallels.com/pda/index.php/t-85461.html