How to make replication of two specific mysql tables?

Question

MySQL

Tell me how to make synchronization in one direction from the master server, to the slave only two tables I need?
So that it only makes changes, and does not overwrite the entire table, since the tables are huge.
And how does replication work, does it work in real time or can it be run by cron at a certain time?

Answer 1

1. To "synchronize" several tables in different databases, you can use the FEDERATED Storage Engine
2. In fact, only a binary log is transferred, not the whole database / table.
3. You can pause replication on the slave and start it on demand.
dev.mysql.com/doc/#manual