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
-
MDEV-5095 Executing triggers on slave in row-based replication
- Closed