How to do query caching in Mysql 8?

Question

MySQL

I know the query_cache_size feature is missing in mysql 8. Any options to include or alternatives?

Answer 1

Redis - after executing the request, we write it to Redis in the form:
key - request hash
value - serialized response of the database data
lifetime - data validity time
At each new request, we first check Redisku. Found - we return from the cache, no - we climb into the database and cache the result

Answer 2

query_cache was removed for a reason. This functionality is crookedly written, in particular, there is a lock - instead of speeding up, you will get a slowdown due to locks.

Answer 3

The only alternative is to use MariaDB.

Answer 4

third party utility. which one do you like better. wrapper over the db driver on the client