Is is possible to MySqlServer from the ramdisk partition and make it a user installable option? I think configuration wise, would give the end-user more options on configuration. If it’s not possible, can the config files be symlinked to a location that is editable and will survive a reboot?
I don’t think RamDisk will be a good solution, especially in tasks that lead to sporadic reboots - in the end, this can lead to a complete loss of data.
I think it makes sense to use Zram for swap.