Sample Header Ad - 728x90

Does MariaDB support server-side query rewriting?

1 vote
0 answers
186 views
MySQL has something called "[The Rewriter Query Rewrite Plugin](https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin.html) ". I've tried to find info about anything similar in MariaDB but so far found nothing. Is there any way in MariaDB to examine and modify SQL statements received by the server before the server executes them? Or is it possible (and safe) to use MySQL plugins in MariaDB 10+? EDIT: I just found out that [work on "Query Rewrite Plugin API" on MariaDB side is "stalled"](https://jira.mariadb.org/browse/MDEV-5561) . BUT in the comments people mention that there are some workarounds by using existing audit plugins. I am looking for any info about that. EDIT 2: I know that third-party software (like MaxScale or ProxySQL) can be used as a proxy with capabilities to rewrite queries but this is not what I am asking about. I ask about query rewrite mechanisms that utilise only MariaDB server engine/package.
Asked by Grzegorz Adam Kowalski (131 rep)
Apr 2, 2023, 04:01 PM
Last activity: Apr 3, 2023, 07:04 PM