Filters for MariaDB MaxScale 2.5

This page is part of MariaDB's Documentation.

The parent of this page is: Reference for MariaDB MaxScale 2.5

Topics on this page:

Overview
MariaDB MaxScale 2.5 Filters

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 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 INSERT statements into CSV data that is streamed to the backend server and loaded using the LOAD DATA INFILE 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 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)

To see Filters supported in other versions, see "Filters by MariaDB MaxScale Version".