Level 25
Your best bet is Replication. Which can be achived with MySQL Replication have look 👇 https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql
1 like
Nov 28, 2020
2
Level 5
How to link two databases in different domains ? ( PHP Native ).
I wanna connect mydomain with two similar databases and when any change happen in any table in one of them, the same table in the other database should changes.
Is there any way to get this done using PHP & MYSQL
Level 73
Agreed, never use php for something the database can do.
Master slave replication is the way to go here.
1 like
Please or to participate in this conversation.