max_slave_replication_lag

Overview

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

USAGE

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.

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

24.02

  • Present starting in MariaDB MaxScale 24.02.0.

23.08

  • Present starting in MariaDB MaxScale 23.08.1.

23.02

  • Present starting in MariaDB MaxScale 23.02.1.

22.08

  • Present starting in MariaDB MaxScale 22.08.1.

6

  • Present starting in MariaDB MaxScale 6.0.0.

2.5

  • Present starting in MariaDB MaxScale 2.5.0.

2.4

  • Present starting in MariaDB MaxScale 2.4.0.

Release Series

History

24.02

  • Present starting in MariaDB MaxScale 24.02.0.

22.08

  • Present starting in MariaDB MaxScale 22.08.1.

EXTERNAL REFERENCES