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.
> ********************************************
