We have an application (APP-1) written in [url removed, login to view] with MySQL DB (DB-1), hosted on Windows 2008 R2 (Server - 1, IP-1).
There is another application APP-2, in PHP with MySQL DB (DB-2), hosted on Linux machine (Server - 2, IP - 2)
APP-1, gets regular hits from client applications and there is 1 particular field in Table-1 which gets updated/changed over time (Field Name is "IP-Address" - ip of client). Now this particular field is also there in DB-2 (Table - 2) called "IP".
There is code which manages this field in DB-1 and updates accordingly using Stored procedures.
We want that as soon as Field-1 in Table-1 gets updated, simultaneously Field-1 in Table-2 also gets updated.
20 freelanceria on tarjonnut keskimäärin 6215 ₹ tähän työhön
Hi, I have a strong experience in MySQL database. I can get this task done. It can be done by setting up a replication between both databases to make the data in sync.