Mysql

From Atomicorp Wiki
Revision as of 07:48, 29 June 2010 by Scott (Talk | contribs)

Jump to: navigation, search

Contents

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

Step 1) Set up the atomic channel:

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

Step 2) Upgrade to Mysql 5.1

yum upgrade mysql

Step 3) Update /etc/my.cnf, the following token has been deprecated and must be removed

skip-bdb


Step 4) Update your mysql tables

mysql_upgrade -u root -p

or for plesk environments:

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 -uadmin -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

Personal tools