Mysql - copy only a few tables from a database

Using mysql replication with mysqlbinlogs between base and slave databases, is it possible to replicate only a few key tables instead of the entire database?

  • I would ideally like to even generate mysqlbinlogs for unneeded tables

  • If that wasn't possible, could I then use a table-limited slave and set up another master-slave that would cause mysqlbinlogs to be limited?


source to share

1 answer

Binlog will be created for all tables. Use blackhole filter on another mysql instance to filter binlog. Here is the guide:



All Articles