Filters in 2.3

MariaDB MaxScale uses filter services to limit or otherwise adjust the queries sent to routers. The routers can then use this information in determining which specific server modules should receive the query.

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

dbfwfilter

Security

Database Firewall Filter blocks queries matching specified rules, preventing them from reaching the Servers.

hintfilter

Server Selection

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

insertstream

Performance

Insert Stream Filter translates bulk INSERT statements into CSV data that is streamed to the backend server and loaded using the LOAD DATA INFILE statement.

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

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