I have Db A and B, both of them are mysql 5.6.
An external application insert new data to multiple tables in db A. Using trigger, I insert new data from A to my table in db B realtime.
How can I give realtime alert if there is new data are inserted to my db B ?
Now I using php cronjob to check it reqularly.
Any idea? Btw, it’s better if its using PHP too.