I am trying to build a application in which I can be able to flow data to MySQL and vice -versa.
I need to understand that how the update, any changes done in MySQL database will be known or immediately flown to other side?
What is the Change detection mechanism in MySQL?
What I am trying to understood is :
If I add some entry in Database it has immediately flown to other side.
Need to find out the all different changes (add, delete, modify, rename) done on number of tables.
Do we have any MySQL API which accepts some parameter and internally execute the command to return the changes?
Can you please shed some light on this?