Details
-
Task
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
Description
It is not visible from documentation if this variable slave_run_triggers_for_rbr is dynamic or not:
https://mariadb.com/kb/en/replication-and-binary-log-system-variables/#slave_run_triggers_for_rbr
Our experiment says: yes it is:
SQL> show global variables like 'slave_run%';
-----------------------------------+
| Variable_name | Value |
-----------------------------------+
| slave_run_triggers_for_rbr | NO |
-----------------------------------+
SQL> set global slave_run_triggers_for_rbr=LOGGING;
Query OK, 0 rows affected (0.000 sec)
SQL> show global variables like 'slave_run%';
-----------------------------------+
| Variable_name | Value |
-----------------------------------+
| slave_run_triggers_for_rbr | LOGGING |
-----------------------------------+
MDEV-5095 from Oleksandr points to the same direction
https://jira.mariadb.org/browse/MDEV-5095
If it really is changing in practice we will find out later in this PoC.
Attachments
Issue Links
- relates to
-
-
- Closed
-
Activity
OK. My bad. Sorry! RTFM would help:
MariaDB [(none)]> SET GLOBAL slave_run_triggers_for_rbr = yes;
Query OK, 0 rows affected (0.000 sec)
Thanks, this has been added. It is also always possible to get this information from the Information Schema:
SELECT * FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES
|
WHERE VARIABLE_NAME LIKE 'slave_run%'\G
|
*************************** 1. row ***************************
|
VARIABLE_NAME: SLAVE_RUN_TRIGGERS_FOR_RBR
|
...
|
READ_ONLY: NO
|
...
|
It seems not to be so easy or not consistent:
MariaDB [test]> SET GLOBAL slave_run_triggers_for_rbr = ON;
ERROR 1231 (42000): Variable 'slave_run_triggers_for_rbr' can't be set to the value of 'ON'
MariaDB [test]> SET GLOBAL slave_run_triggers_for_rbr = LOGGING;
Query OK, 0 rows affected (0.000 sec)