Problem with multi master replication and a trigger with mariadb 10.0.10.
I have a problem with multi master replication and a trigger with mariadb 10.0.10.
First. I have installed master db with name DB1 on a Windows system 1 master1 with a table m1, m2, m3, mg Second, I have install “slave” db with name DB1 on a Windows system 2 slave1 with a table s1, s2
Now I setup a row based replication with the table m1 from master1 to slave1. Next I setup a row based replication with the table s1 from slave1 to master1.
Now I have a master with table m1, m2, m3, mg and s1 and a slave with table s1, s2 and m1. All replications work well.
Ad next I create a trigger on master to manipulate and copy the data from table s1 to mg, but it do not work.
I found this information (https://mariadb.atlassian.net/browse/MDEV-5095) but I have not the variable slave_run_triggers_for_rbr or slave_run_triggers.
When I create the same trigger on master with table m1 and mg, it still works. But it not work with the replication table s1.
I think it is a problem with the replication table s1.
Can anyone help me?
Answer Answered by Elena Stepanova in this comment.
Functionality you are looking for (MDEV-5095) is not available in MariaDB 10.0.10, the fix version in JIRA entry is misleading and will be corrected. It should appear in the next major release, 10.1. Sorry for the inconvenience.