How to sync selected tables between two mysql instances in one server
There is detail about how to set up replication in MySQL for db with two different servers: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql, Read this article first.
For master, we only can use binlog_do_db with database not table, so nothing change.
For slave, we need change binlog_do_db with replicate-do-table, like replicate-do-table = project.auth_user, this will only sync selected table to slave db.
