Archives

All posts for the day October 17th, 2011

MySQL under daemontools

Posted by phatdee on October 17, 2011
Posted in: Mysql. Tagged: , . 1 comment

Running mysql in daemontools

Sunday, 21 March 2010 21:14
There are no translations available.

Prerequisite: Debian 5.0 Lenny, Mysql-server-5.0: 5.0.51a-24+lenny3

mkdir -m 1755 /var/service/mysqld
mkdir -p -m 755 /var/service/mysqld/log
cd /var/service/mysqld
vim run

#!/bin/sh
exec 2>&1
exec /usr/sbin/mysqld –basedir=/usr –datadir=/var/lib/mysql \
–user=mysql –pid-file=/var/run/mysqld/mysqld.pid \
–skip-external-locking –port=3306 –socket=/var/run/mysqld/mysqld.sock

chmod 755 run
cd log
wget -O run http://qmail.jms1.net/scripts/service-any-log-run
chmod 755 run

Stop the startup script:

/etc/init.d/mysql stop
sysv-rc-conf

The following commands will create the symbolic links needed to start the mysql service.ln -s /var/service/mysqld /service/
sleep 5
svstat /service/mysqld /service/mysqld/log