database replication question Hi,
As I know, master will replicate all database to the slave in
default. If I want to replicate only specified database, we can use
parameter in master.
binlog-do-db=databasename
I found that we can also use parameters to replicate database even
table in slave.
replicate-do-db=db_name (replicate this database)
replicate-ignore-db=db_name (don't replicate this database)
replicate-do-table=db_name.table_name (replicate this table)
replicate-ignore-table=db_name.table_name (don't replicate this table)
I have tried the second method but nothing to replicate. Anyone can
tell if it works for you.
ango |