This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Module Parameters for MariaDB MaxScale
Topics on this page:
Routes multi-statement queries to the Primary Server.
See also: Module Parameters for MariaDB MaxScale 23.02, in 22.08, in 6, in 2.5, and in 2.4
See also: Module Parameters for MariaDB MaxScale 23.02, in 22.08, and in 6
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.