Mysql

From Atomicorp Wiki
Revision as of 07:21, 23 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

Placeholder

Personal tools