Skip to content

Instantly share code, notes, and snippets.

@jkimbo

jkimbo/make_mysql_ramdisk

Forked from junkafarian/make_mysql_ramdisk
Created August 12, 2013 10:14
Show Gist options
  • Save jkimbo/6209707 to your computer and use it in GitHub Desktop.
Save jkimbo/6209707 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Then run the 2 mysql servers with:
/usr/local/bin/mysqld_multi start --tcp-ip 1,2
Raw
make_mysql_ramdisk
#!/bin/bash
if [ ! -d /Volumes/mysqlramdisk ]; then
diskutil erasevolume HFS+ "mysqlramdisk" `hdiutil attach -nomount ram://204800`
mysql_install_db --basedir=/usr/local/Cellar/mysql/5.6.12 --datadir=/Volumes/mysqlramdisk
fi
Raw
my.cnf
[mysqld]
lower_case_table_names=1
[mysqld1]
server-id=10001
basedir=/usr/local/Cellar/mysql/5.6.12
datadir=/usr/local/var/mysql
port=3306
socket=/tmp/mysql.sock
[mysqld2]
server-id=10002
basedir=/usr/local/Cellar/mysql/5.6.12
datadir=/Volumes/mysqlramdisk/
log-error=/Volumes/mysqlramdisk/mysql.ramdisk.err
pid-file=/Volumes/mysqlramdisk/mysql.ramdisk.pid
port=33080
socket=/tmp/mysql_ramdisk.sock
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment