I recommend to use the 'wild' modifier, if you have a default db and you
specify the schema in the query like update
schemanotreplicated.mytable..... you will miss that.
Claudio
2012/5/2 Rick James <rjames@stripped>
> Yes, doable. In my.cnf on master:
> Binlog-do-database = dbname1
> Binlog-do-database = dbname2
> Would replicate those two dbs only.
> There are many other combinations using
> binlog/replicate-do/ignore-db/table/wild. See the manual on replication,
> and especially the flowchart on how those interact (sometimes in unexpected
> ways).
>
> > -----Original Message-----
> > From: Brown, Charles [mailto:CBrown@stripped]
> > Sent: Wednesday, May 02, 2012 8:44 AM
> > To: Rick James
> > Cc: mysql@stripped
> > Subject: Can the mysql replication limited to one database
> >
> > Hi Gurus,
> >
> > Can the mysql replication limited to selected schema or database? I've
> > been asked to set up mysql for only 1 out 5 databases exist in
> > production. Please advise if this is doable
> >
> > Thanks
> >
> > ********************************************
> > This message is intended only for the use of the Addressee and may
> > contain information that is PRIVILEGED and CONFIDENTIAL.
> >
> > If you are not the intended recipient, you are hereby notified that any
> > dissemination of this communication is strictly prohibited.
> >
> > If you have received this communication in error, please erase all
> > copies of the message and its attachments and notify us immediately.
> >
> > Thank you.
> > ********************************************
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
>
--
Claudio
