Script to start a second mysql server using ramdisk/tmpfs for unit tests.

start-mysql-in-mem

#!/bin/bash

DATADIR=/dev/shm/mysql
TMPDIR=/dev/shm/mysql_tmp
MYSQL_SOCKET=/dev/shm/mysql.sock

pkill -9 -f mysql.*datadir.*$DATADIR

mkdir -p $DATADIR

mkdir -p $TMPDIR
chown -R mysql.mysql $DATADIR
chown -R mysql.mysql $TMPDIR

rm -f $DATADIR/ib*

echo "=== Installing MySQL DB ==="
mysql_install_db --user=mysql --datadir=$DATADIR

# Note: this only overrides stuff in /etc/my.cnf. Other settings are taken from
# there and are quite important!
echo "=== Starting IN-MEMORY MYSQL SERVER ==="
/usr/sbin/mysqld --port=3307 \
		--datadir=$DATADIR \
		--innodb_data_home_dir=$DATADIR \
		--innodb_log_group_home_dir=$DATADIR \
		--tmpdir=$TMPDIR \
		--socket=$MYSQL_SOCKET \
		--log-error=/dev/shm/mysql.err &


echo "=== Waiting ==="
sleep 10

echo "=== Setting root password ==="
export MYSQL_SOCKET
export MYSQL_PASSWORD=bunnies
mysql --socket=$MYSQL_SOCKET -u root -e "SET PASSWORD =  PASSWORD('bunnies')"