strict_sp_calls

Overview

Routes CALL statements to the Primary Server.

See also: Module Parameters for MariaDB MaxScale 6

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.

EXTERNAL REFERENCES