Filters for MariaDB MaxScale 23.02

Overview

MariaDB MaxScale 23.02 supports multiple filters.

Reference material is available for MariaDB MaxScale 23.02.

MariaDB MaxScale 23.02 Filters

The following Filters are supported by MariaDB MaxScale 23.02:

Filter

Type

Description

binlogfilter

Special Routing

Binary Log Filter can be used with the binlogrouter to selectively replicate Binary Log events to Replica Servers

cache

Performance

Caches the result-sets of SELECTSELECT statements to improve query performance

ccrfilter

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

hintfilter

Server Selection

Hint Filter allows services to interpret routing hints, which can be specified in a comment when a query is executed

luafilter

Programmatic

Lua Filter processes queries with the specified Lua scripts (experimental)

masking

Security

Masking Filter obfuscates the return values of specified columns

maxrows

Performance

Max Rows Filter limits the number of rows that SELECTSELECT statements, prepared statements, and stored procedures can return

namedserverfilter

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

qlafilter

Security

Query Log All (QLA) Filter logs matching queries to a CSV file

regexfilter

Programmatic

Regex Filter rewrites matching queries using Regular Expressions

rewritefilter

Rewrites queries based on a query template

tee

Special Routing

Tee Filter copies client requests to other services

throttlefilter

Performance

Throttle Filter limits the maximum frequency of queries per second allowed for a database session

topfilter

Performance

Top Filter logs the top queries by execution time

tpmfilter

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".