Skip to content

Instantly share code, notes, and snippets.

@dvdcastro

dvdcastro/rammysql.sh

Last active December 30, 2019 14:45
Show Gist options
  • Save dvdcastro/0e300cf7fa45b99832bc9f11c407c6b6 to your computer and use it in GitHub Desktop.
Save dvdcastro/0e300cf7fa45b99832bc9f11c407c6b6 to your computer and use it in GitHub Desktop.
Download ZIP
Moves mysql to a ram disk on Ubuntu 18.04 - Use at your own risk, information on ram is volatile
Raw
rammysql.sh
#!/bin/bash
service mysql stop
echo "Stopped mysql."
umount /mnt/ramdisk
echo "Unmounted ramdisk /mnt/ramdisk"
mkdir -p /mnt/ramdisk
mount -t tmpfs -o size=2048m tmpfs /mnt/ramdisk
echo "Mounted ramdisk /mnt/ramdisk"
if [ ! -d "/var/lib/mysql.bk" ]
then
mv /var/lib/mysql /var/lib/mysql.bk
echo "Moved mysql library folder to backup folder."
fi
cp -rp /var/lib/mysql.bk /mnt/ramdisk/mysql
echo "Copied mysql backup to ramdisk."
if [ -L /var/lib/mysql ] && [ -e /var/lib/mysql ]
then
rm /var/lib/mysql
echo "Removed symlink /var/lib/mysql."
fi
ln -s /mnt/ramdisk/mysql /var/lib
echo "Recreated symlink /var/lib/mysql."
if ! grep -q "alias /var/lib/mysql/ -> /mnt/ramdisk/mysql," "/etc/apparmor.d/tunables/alias"
then
echo "alias /var/lib/mysql/ -> /mnt/ramdisk/mysql," >> /etc/apparmor.d/tunables/alias
echo "Appended alias to apparmor."
systemctl restart apparmor
echo "Restarted apparmor."
fi
service mysql start
echo "Started mysql."
@dvdcastro
Copy link
Author

dvdcastro commented Dec 30, 2019 •
edited
Loading

To have everything back as it was:

service mysql stop
echo "Stopped mysql."

umount /mnt/ramdisk
echo "Unmounted ramdisk /mnt/ramdisk"

if [ -L /var/lib/mysql ] && [ -e /var/lib/mysql ]
then
    rm /var/lib/mysql
    echo "Removed symlink /var/lib/mysql."
fi

mv /var/lib/mysql.bk /var/lib/mysql
echo "Moved mysql to its original place."

service mysql start
echo "Started mysql."

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment