Clever Geek Handbook

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?

+3


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: http://jroller.com/dschneller/entry/mysql_replication_using_blackhole_engine



+1


source






More articles:


All Articles