How to sync selected tables between two mysql instances in one server

1 minute read

There is detail about how to set up replication in MySQL for db with two different servers:, 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.


Tags: ,