strict_multi_stmt

Overview

Routes multi-statement queries to the Primary Server.

USAGE

DETAILS

In cases where a client attempts to execute a multi-statement query, it can create issues where a write operation among the statements is routed to the Replica Server rather than to the Primary. This module parameter causes multi-statement queries to always route to the Primary Server, ensuring a consistent session state. Enable this module parameter in cases where multi-statement queries will cause an inconsistent session.

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

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

22.08

  • Present starting in MariaDB MaxScale 22.08.1.

EXTERNAL REFERENCES