max_slave_replication_lag

Number of seconds a Replica Server is allowed to fall behind the Primary Server.

See also: Module Parameters in 6.1, in 2.5, in 2.4, and in 2.3

DETAILS

In asynchronous and semi-synchronous replication, Replica Servers can fall behind the Primary Server, due to limitations of hardware or workload. This is called replication lag. Lagging Replica Servers do not provide current data to clients executing read queries.

This module parameter controls the amount of replication lag the router permits. If a Replica Server falls too far behind, the router stops routing client connections to it. This is to allow the Replica Server to catch up with the Primary Server and to prevent it from serving old data to clients.

EXTERNAL REFERENCES