mysql trigger on a federated table
3
votes
1
answer
1635
views
I have two MySQL(5.6) databases
D1
and D2
on two different machines.
There is a table T1
on D1
and there are two tables T2A
and T2B
on D2
.
I want to update T2B
whenever T1
is updated.
T2A
is a federated table and T1
is base table of it.
There is an "After Update
" trigger on D2
which updates T2B
whenever T2A
is updated.
When there is an update on T2A
, T2B
table is updated by trigger.
When there is an update on T1
, T2A
table is updated by federation **but the trigger to update T2B
as well is not triggered**.
So when there is an update on T1
, T2B
table is not updated automatically, only T2A
is.
How to solve this?
Asked by tylerdurden
(131 rep)
Jan 28, 2016, 09:21 AM
Last activity: Jun 25, 2017, 11:25 AM
Last activity: Jun 25, 2017, 11:25 AM