In this blog post, I’ll present the ProxySQL query cache functionality. This is a query caching mechanism on top of ProxySQL. As there are already many how-tos regarding the ProxySQL prerequisites and installation process, we are going to skip these steps. For those who are already familiar with ProxySQL query cache configuration, let’s go directly to the query rules and the performance results.
Before talking about the ProxySQL query cache, let’s take a look at other caching mechanisms available for MySQL environments.
MySQL query cache is a query caching mechanism – deprecated as of MySQL 5.7.20 and removed in MySQL 8.0 – on top of MySQL itself (based on the official MySQL documentation).
The MySQL query cache stores the text of a SELECT statement together with the corresponding result sent to the client. If an identical statement is …[Read more]