Filters for MariaDB MaxScale 2.5

Overview

MariaDB MaxScale 2.5 supports multiple filters.

Reference material is available for MariaDB MaxScale 2.5.

MariaDB MaxScale 2.5 Filters

The following Filters are supported by MariaDB MaxScale 2.5:

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

storage_memcached

storage_redis

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