use_sql_variables_in

Where the router sends session variable queries.

See also: Module Parameters in 6.1, in 2.5, in 2.4, and in 2.3

DETAILS

This module parameter controls where the router sends session variable queries, such as SHOW VARIABLES or SET statements.

Option

Description

master

Router sends all session variable queries to the Primary Server.

all

Router sends queries retrieving session variables to the first available Replica Server. It sends queries modifying session variables to all Servers.

EXTERNAL REFERENCES