Filters for MariaDB MaxScale 22.08
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Reference for MariaDB MaxScale 22.08
Topics on this page:
MariaDB MaxScale 22.08 supports multiple filters.
Reference material is available for MariaDB MaxScale 22.08.
MariaDB MaxScale 22.08 Filters
The following Filters are supported by MariaDB MaxScale 22.08:
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
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
Rewrites queries based on a query template
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".