strict_sp_calls

Overview

Routes CALL statements to the Primary Server.

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.1.

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.

Release Series

History

22.08

  • Present starting in MariaDB MaxScale 22.08.1.

6

  • Present starting in MariaDB MaxScale 6.0.0.