Filters for MariaDB MaxScale 6
MariaDB MaxScale 6 supports multiple filters.
Reference material is available for MariaDB MaxScale 6.
MariaDB MaxScale 6 Filters
The following Filters are supported by MariaDB MaxScale 6:
Binary Log Filter can be used with the
Caches the result-sets of SELECT statements to improve query performance.
Consistent Critical Read (CCR) Filter detects when a statement modifies the database, and it attaches routing hints to any subsequent statements, so they get routed to the master.
Database Firewall Filter blocks queries matching specified rules, preventing them from reaching the Servers.
Hint Filter allows services to interpret routing hints, which can be specified in a comment when a query is executed.
Lua Filter processes queries with the specified Lua scripts (experimental).
Masking Filter obfuscates the return values of specified columns.
Max Rows Filter limits the number of rows that SELECT statements, prepared statements, and stored procedures can return.
Named Server Filter compares queries to specified Regular Expressions, and when the query matches, the filter applies the specified routing hint to the query.
Query Log All (QLA) Filter logs matching queries to a CSV file.
Regex Filter rewrites matching queries using Regular Expressions.
Tee Filter copies client requests to other services.
Throttle Filter limits the maximum frequency of queries per second allowed for a database session.
Top Filter logs the top queries by execution time.
Transaction Performance Monitoring (TPM) Filter logs information on committed transactions for performance analysis (experimental).
To see Filters supported in other versions, see "Filters by MariaDB MaxScale Version".