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!