Replication or your own script?

Question

PHP

Hello! There are 2 similar databases on the same server with one common user. What is the best way to set up synchronization of 2 identical tables from the first database to the second one (not all data needs to be synchronized, but only by certain IDs).
Is replication suitable here or is it better to write your own php script and run it via CRON.

Answer 1

If on the same server, then it is easier with a mysql trigger to immediately synchronize it to the second database when you change the desired record in the first database.
https://dev.mysql.com/doc/refman/5.5/en/trigger-sy...

Answer 2

https://dev.mysql.com/doc/refman/5.7/en/replicatio...