View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 06:05 AM
Rilawich Ango
 
Posts: n/a
Default 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
Reply With Quote