Sample Header Ad - 728x90

Federated tables and triggers

5 votes
2 answers
3194 views
This is the scenario. Have two MySQL servers (S1, S2) on different machines, with a database on each (DB1, DB2). I have a table (T2) on DB2 that needs to "fetch" rows from another table (T1) on DB1. I have created a temporary table (base on DB1 and federated on DB2), so when I insert a row on T1 which complies with some requirements I copy to my DB1 temporary table. That's OK. With the federated table on DB2 I get the row I need for T2. I presumed that with a trigger on the federated temporary table of DB2 it's possible to insert that row to T2, but the trigger never fires. Any suggestions?
Asked by jila (53 rep)
May 17, 2013, 12:54 PM
Last activity: Jan 28, 2016, 10:13 AM