Mysql Storage in RAM?

Question

MySQL

There is an ubuntu 18.04 server
24 cores
112 gigs of RAM
Will be bitrix24.
Installed mariyadb.
How to set up a database so that all data is first stored on RAM but is immediately written to hdd. Naturally, if there is a reboot, everything will be lost. And therefore it is necessary that on the fly it records to hdd but at the same time gives it from the RAM. How to setup?

Answer 1

one of the options :)
vixdevelop.blogspot.com/2016/09/zraid.html

Answer 2

How to set up a database so that all data is first stored on RAM but is immediately written to hdd. Naturally, if there is a reboot, everything will be lost. And therefore it is necessary that on the fly it records to hdd but at the same time gives it from the RAM. How to setup?

What for? If you need a DBMS to work quickly, then they are created for this, everything is already there. Why invent a DBMS architecture if it has already been done? Especially without knowing anything about how they work.
Don't be under the illusion that you are now coming up with a better architecture than what professionals have been working on for decades. In addition, approximately as you described, MariaDB works.
Do not "tweak" the settings, the default settings are enough, by changing something you can "kill" the DBMS. You need to go into the settings when there is a specific problem, and you understand not only what setting can affect it, but also what other effects it will cause.