====== MySQL Source Installation ======

  * [[MySQL]]

Generic install for MySQL.

Add mysql group and user:

<code>
groupadd mysql
useradd -g mysql mysql
</code>

Target install base:

<code>
/var/run/mysqld/ - mysqld.sock
/usr/bin - binaries
/etc/mysql - configuration
/usr/lib/ - libraries
/usr/lib/mysql/plugin - plugins
/usr/sbin - mysqld binary
/usr/share/doc/percona-server-5.5/ - docs
/usr/share - shares
/usr/share/man - man pages
/usr/share/mysql - charsets
</code>

Unpack tarball and start build for a 5.5 install:

<code>
rm -f CMakeCache.txt
cmake . -DCMAKE_INSTALL_PREFIX=/usr -DMYSQL_DATADIR=/var/lib/mysql -DSYSCONFDIR=/etc/mysql -DINSTALL_BINDIR=bin -DINSTALL_DOCDIR=share/doc/mysql-5.5 -DINSTALL_DOCREADMEDIR=share/doc/mysql-5.5/readme -DINSTALL_INCLUDEDIR=include/mysql -DINSTALL_INFODIR=share/info -DINSTALL_LIBDIR=lib/mysql -DINSTALL_MANDIR=share/man -DINSTALL_MYSQLSHAREDIR=share/mysql -DINSTALL_MYSQLTESTDIR=share/mysql/mysql-test -DINSTALL_PLUGINDIR=lib/mysql/plugin -DINSTALL_SBINDIR=libexec -DINSTALL_SCRIPTDIR=bin -DINSTALL_SQLBENCHDIR=share/mysql -DINSTALL_SUPPORTFILESDIR=/usr/share/mysql -DWITHOUT_UNIT_TESTS=1 -DINSTALL_SUPPORTFILESDIR=share/doc/mysql-5.5/support -DWITH_SSL=system
make
</code>

Install new init script:

<code>
cp /etc/init.d/mysql{,.bak}
cp support-files/mysql.server /etc/init.d/mysql.server
</code>

Get the old value for the ''innodb_log_file_size'' and update it in the new my.cnf:

<code>
mysql information_schema -Bse "select variable_value from session_variables where variable_name = 'innodb_log_file_size';"
</code>

Backups, stop server:

<code>
mysqldump -A > ~/mysqldump-$(date %+F).sql
/etc/init.d/mysql stop
</code>

Setup directories, files and ownership:

<code>
mkdir /var/run/mysqld /var/log/mysql
touch /var/run/mysqld/mysqld.{pid,sock} /var/log/mysql/mysql{,-slow}.log
rm -f /var/lib/mysql/mysql.sock /tmp/mysql.sock /var/lib/mysql/mysqld.pid /var/lib/mysql/mysql.sock 
mkdir -p /var/lib/mysql/data
mkdir -p /var/log/mysql
touch /var/log/mysql/mysql{,-slow}.log
</code>

Actually install binaries, final setup:

<code>
make install
cd /usr
# ./bin/mysql_install_db --datadir=/var/lib/mysql/data
chown -R mysql: /var/lib/mysql/data /var/run/mysqld /var/log/mysql
chmod 2750 /var/log/mysql/*
chmod 0700 /var/lib/mysql/data
cp /etc/my.cnf{,.bak}
</code>

Start the server:

<code>
tail -f /var/log/mysql/mysql.log
mv /etc/init.d/mysql{.server,}
chmod +x /etc/init.d/mysql
/etc/init.d/mysql start
</code>

Create symlinks that would be deleted before now:

<code>
ln -s /var/run/mysqld/mysqld.pid /var/lib/mysql/mysqld.pid
ln -s /var/run/mysqld/mysqld.sock /var/lib/mysql/mysql.sock
ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock
</code>

Bring databases up to speed:

<code>
mysql_upgrade
mysqlcheck -A
</code>

Some possible loose ends:

<code>
cpan install DBD::MySQL
</code>

Add to your php.ini:

<code>
pdo_mysql.default_socket = /var/run/mysqld/mysqld.sock
</code>