Filters for MariaDB MaxScale 6
This page is part of MariaDB's Documentation.
The parent of this page is: Reference for MariaDB MaxScale 6
Topics on this page:
Overview
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:
Filter | Type | Description |
---|---|---|
Special Routing | Binary Log Filter can be used with the | |
Performance | Caches the result-sets of statements to improve query performance | |
Server Selection | 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 | |
Security | Database Firewall Filter blocks queries matching specified rules, preventing them from reaching the Servers | |
Server Selection | Hint Filter allows services to interpret routing hints, which can be specified in a comment when a query is executed | |
Performance | Insert Stream Filter translates bulk statements into CSV data that is streamed to the backend server and loaded using the statement | |
Programmatic | Lua Filter processes queries with the specified Lua scripts (experimental) | |
Security | Masking Filter obfuscates the return values of specified columns | |
Performance | Max Rows Filter limits the number of rows that statements, prepared statements, and stored procedures can return | |
Server Selection | Named Server Filter compares queries to specified Regular Expressions, and when the query matches, the filter applies the specified routing hint to the query | |
Security | Query Log All (QLA) Filter logs matching queries to a CSV file | |
Programmatic | Regex Filter rewrites matching queries using Regular Expressions | |
Special Routing | Tee Filter copies client requests to other services | |
Performance | Throttle Filter limits the maximum frequency of queries per second allowed for a database session | |
Performance | Top Filter logs the top queries by execution time | |
Performance | 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".