slave_selection_criteria

Overview

Criteria the router uses to select Replica Servers in load balancing read operations.

See also: Module Parameters for MariaDB MaxScale 6, in 2.5, and in 2.4

DETAILS

In addition to splitting read and write operations between Primary and Replica Servers, the Read/Write Split router performs load balancing on the available Replica Servers. This module parameter sets the criteria used to select the Servers.

Criterion

Description

LEAST_GLOBAL_CONNECTIONS

Router selects the Replica Server with the least number of connections from MariaDB MaxScale.

LEAST_ROUTER_CONNECTIONS

Router selects the Replica Server with the least number of connections from this router service.

LEAST_BEHIND_MASTER

Router selects the Replica Server with the least replication lag.

LEAST_CURRENT_OPERATIONS

Router selects the Replica Server with the fewest active operations.

ADAPTIVE_ROUTING

Router selects the Replica Server based on average response times.

CHANGE HISTORY

Release Series

History

6

  • Present starting in MariaDB MaxScale 6.0.0.

2.5

  • Present starting in MariaDB MaxScale 2.5.0.

2.4

  • Added in MariaDB MaxScale 2.4.1.

EXTERNAL REFERENCES