strict_sp_calls

Overview

Routes CALL statements to the Primary Server.

See also: Module Parameters for MariaDB MaxScale 22.08, in 6, in 2.5, and in 2.4

DETAILS

In CALL statements, the Server executes a stored procedures or functions. Routers typically route these statements to Replica Servers, which can result in an inconsistent state given that these operations can include writes.

This module parameter causes CALL statements always route to the Primary Server. Use it in cases where you may stored procedures and functions that modify the database state.

CHANGE HISTORY

Release Series

History

22.08

  • Present starting in MariaDB MaxScale 22.08.0.

6

  • Present starting in MariaDB MaxScale 6.0.0.

2.5

  • Present starting in MariaDB MaxScale 2.5.0.

2.4

  • Added in MariaDB MaxScale 2.4.1.

EXTERNAL REFERENCES