CODEWITHSUNDEEP
mysqldatabase-replicationmysqlbinlog
LTME
LTME

Reputation: 1126

Mysql - Replicate only a few tables from a database

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

  1. I would ideally like to not even generate the mysqlbinlogs for the unneeded tables

  2. If that was not possible, could I then use the slave with the limited tables and set up another master-slave that would result in the limited mysqlbinlogs?

Upvotes: 4

Views: 4799

Answers (1)

Erik Ekman
Erik Ekman

Reputation: 2066

Binlog will be generated for all tables. Use the blackhole storage engine on another mysql instance to filter the binlog. Here is a guide: http://jroller.com/dschneller/entry/mysql_replication_using_blackhole_engine

Upvotes: 1

Related Questions