Re: Replication multiple database
Posted by:
Rick James
Date: April 04, 2009 10:27PM
If you don't have any of the replicate-* and binlog-* lines, then all databases are replicated.
binlog-do/ignore (in the master's my.cnf) filters what leaves the master.
replicate-do/ignore (in the slave's my.cnf) filters what is acted upon in the slave.
You normally don't need both. Various combinations achieve various things.
If you mix *do* and *ignore* in one my.cnf, read the precise details of the interactions. Better yet, don't mix them.
If you change the statements to filter out more databases (by any of the above stuff), the database/table on the slave will stop being updated. Any data in it will still be there. You will not be able to turn it back on -- any updates that occurred meanwhile will be lost.
Subject
Views
Written By
Posted
7595
April 02, 2009 10:43PM
2771
April 03, 2009 03:53AM
Re: Replication multiple database
2838
April 04, 2009 10:27PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.