In-Memory MySQL script

You may decide that you want to run mysql in memory for accelerated testing etc. This python script (originally found here) will take care of the specifics for you.

Script Options

Description	Shorthand Option	Longhand Option	Default
Kill the ramdisk	-k	--kill-ramdisk	none
Path to the ramdisk	-p	--path-to-ramdisk	/dev/disk3 on OSX or /mnt/ramdisk on Linux
Create the ramdisk	-c	--create-ramdisk	none
Ramdisk size	-s	--ramdisk-size	128 MB
Disable Linux App Armor	-a	--disable-apparmor	none
Install MySQL in memory and start it	-m	--with-mysql	none

Create an in-memory MySQL DB

./mysql-ramdisk.py --create-ramdisk --with-mysql

Connect to that DB

mysql --socket=/tmp/mysql.sock

Destroy the DB

./mysql-ramdisk.py --kill-ramdisk