NYCPHP Meetup

[nycphp-talk] MySQL select replication

Tim Gales tgales at tgaconnect.com
Wed Jan 5 16:14:25 EST 2005



> 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 




More information about the talk mailing list