use_sql_variables_in

Overview

Where the router sends session variable queries.

USAGE

DETAILS

This module parameter controls where the router sends session variable queries, such as SHOW VARIABLESSHOW VARIABLES or SETSET 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.

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

24.02

  • Present starting in MariaDB MaxScale 24.02.0.

23.08

  • Present starting in MariaDB MaxScale 23.08.1.

23.02

  • Present starting in MariaDB MaxScale 23.02.1.

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

  • Present starting in MariaDB MaxScale 2.4.0.

Release Series

History

24.02

  • Present starting in MariaDB MaxScale 24.02.0.

22.08

  • Present starting in MariaDB MaxScale 22.08.1.

EXTERNAL REFERENCES