What are the effective RAM & SQL solutions?

Question

MySQL

I am used to working with mysql. But in terms of the efficiency of reading data from the hdd disk with each request, it turns out to be rather slow, especially when a large number of simple requests or a couple of complex ones are required to generate a page. I would like to know if there are any hybrid solutions, so that individual tables, for example, can be completely placed in RAM? or in some other way. I tried mysql + caching profiles and user rights in redis, in principle it works well, but I would like one source of truth so that when updating information, do not write an update in the database in the code + update in the cache.