It looks like a safe method is to make the innodb_buffer_pool_size a lot bigger, and it will in fact store all the db in memory. (Otherwise you need to set up

It looks like a safe method is to make the innodb_buffer_pool_size a lot bigger, and it will in fact store all the db in memory. (Otherwise you need to set up a backup or a replication in case the server goes down) I'll play around with it, thanks!