slave_selection_criteria
This page is part of MariaDB's Documentation.
The parent of this page is: Module Parameters for MariaDB MaxScale
Topics on this page:
Overview
Criteria the router uses to select Replica Servers in load balancing read operations.
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.
Enum values are case-sensitive.
For example, slave_selection_criteria=LEAST_CURRENT_OPERATIONS is correct while slave_selection_criteria=least_current_operations is not correct.
Criterion | Description |
|---|---|
| Router selects the Replica Server with the least number of connections from MariaDB MaxScale. |
| Router selects the Replica Server with the least number of connections from this router service. |
| Router selects the Replica Server with the least replication lag. |
| Router selects the Replica Server with the fewest active operations. |
| Router selects the Replica Server based on average response times. |