0

I have 2 mysql database test1 and test2 on same machine. In test1 there is a table named employee and is updating regularly, i need to update a table employee on database test2 having same table name with 2 min time delay just like replication between 2 tables with 2 min time delay.

This mysql server is installed on linux operating system, Please help me out.

Ranjeet Sahu
  • 1
  • consider mysql [Create Event](https://dev.mysql.com/doc/refman/5.1/en/create-event.html) functionality. Every task is different, [here](http://stackoverflow.com/a/32508935) was an example of one I wrote up. Yours could run every minute or two, picking up rows where updt_dt (datetime) is in a date_diff range of 120 seconds, and has not been dragged over to the other db. Once replicated to db2, the table in db1 could have a `replicated` column set to 1 or the like. – Drew Oct 08 '15 at 18:26
  • Sorry I didn't get you, Can you please elaborate by an example. It will be help me a lot. – Ranjeet Sahu Oct 09 '15 at 21:52
  • I elaborated in the example link above – Drew Oct 10 '15 at 01:05

0 Answers0