Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
hello every one, i have two servers for mySQL, the first is on an local server and the second is online server (Cpanel). i want to when any (CRUD) transaction is happened in local server, it reflect it in the online server. i want to do this when internet is interrupting, after the internet back the data in local server upload to the online server. so what do you suggest for me ? note: i am using Mysql workbench and table plus.
did you have access to mysql configuration files on cpanel server? if so, its just follow any simple mysql replication master-slave tutorial like this: https://www.digitalocean.com/community/tutorials/how-to-set-up-replication-in-mysql
Please or to participate in this conversation.