causal_reads

Overview

Configures read causality, reads subsequent to writes issued in manner to reduce replication lag.

USAGE

DETAILS

Read/Write Split router supports read causality operations. When enabled, following write operations, MaxScale adjusts subsequent reads to reduce replication lag.

Option

Description

none

Disables read causality.

local

Writes visible to the connection that issues the write statement, waits for the Replica Server to catch up. Writes performed by other connections are not visible.

global

Writes visible to all connections. When one connection performs a write, all connections to the same service can see it.

fast

Writes visible to the connection that issues the write statement, but does not wait for the Replica Server to catch up. Writes performed by other connections are not visible.

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