Filters for MariaDB MaxScale 6
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Reference for MariaDB MaxScale 6
Topics on this page:
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 SELECTSELECT 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
Insert Stream Filter translates bulk INSERTINSERT statements into CSV data that is streamed to the backend server and loaded using the LOAD DATA INFILELOAD DATA INFILE statement
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 SELECTSELECT 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".