Update two tables, each on separate MySQL servers, on two different machines in one query?
0
votes
1
answer
426
views
I have two MySQL servers running on two different machines in a local network. I am using PHP and accessing the databases via IP. No problems there. The databases have identical schemas. One of them was an import from the other machine.
I want to run a single (ONE) query that updates the same table on each server simultaneously. I already have existing queries and do not want to update them extensively.
Is there a simple way to achieve this?
I'm looking to keep the databases in sync when an update occurs.
I am also open to any other suggestions regarding other ways to keep the databases in sync.
Asked by drforbin
(1 rep)
Oct 5, 2018, 06:38 PM
Last activity: May 19, 2025, 03:03 PM
Last activity: May 19, 2025, 03:03 PM