Few days ago MariaDB announced MaxScale 2.1.0 Beta, and among the
new Query Performance capabilities there is Query Cache Filter.
Query Cache was among the very first features introduced in
ProxySQL, and therefore I was extremely curious to compare
Reading the documentation on MaxScale Query Cache Filter I noticed few interesting things compares to ProxySQL Query Cache:
- MaxScale supports in-memory and on disk storage, while ProxySQL supports only in-memory storage
- MaxScale can have either shared or per-thread cache, while ProxySQL supports only shared cache: in 2014 ProxySQL had per-thread cache, but benchmark showed that a partitioned shared cache is way more efficient
To compare ProxySQL 1.3.4 Query Cache …[Read more]