NYCPHP Meetup

[Tim Gales]

> Not a PHP specific question (sorry):
> 
> Is it possible to replicate only select databases between master and 
> server MySQL server?
> Ive read through the replication docs and it appears to be an all or 
> nothing setup.


> Not a PHP specific question (sorry):
> 
> Is it possible to replicate only select databases between master and 
> server MySQL server?
> Ive read through the replication docs and it appears to be an all or 
> nothing setup.
> 

There are some filtering options which 
you can set for the master (binary) log:

binlog-do-db and binlog-ignore-db 

On the slave side there are: 

replicate-wild-ignore-table
replicate-wild-do-table
replicate-do-table
replicate-ingnore-table
and 
replicate-ignore-db
replicate-do-db

replicate-rewrite-db

T. Gales & Associates
'Helping People Connect with Technology'

http://www.tgaconnect.com