Moves mysql to a ram disk on Ubuntu 18.04 - Use at your own risk, information on ram is volatile

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."

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."