Conflicting DOC
The content of conflicing doc is:
--replicate-ignore-db=db_name
"Tells the slave to not replicate any statement where the default database (that is, the one selected by USE) is db_name. To specify more than one database to ignore, use this option multiple times, once for each database. You should not use this option if you are using cross-database updates and you don't want these updates to be replicated. Please read the notes that follow this option list.
An example of what does not work as you might expect: If the slave is started with --replicate-ignore-db=sales and you issue the following statements on the master, the UPDATE statement is not replicated:
USE prices;
UPDATE sales.january SET amount=amount+1000;
If you need cross-database updates to work, use --replicate-wild-ignore-table=db_name.% instead. "
_________________________________________________________
I don't know what is true.
for example:
"You should not use this option if you are using cross-database updates and you don't want these updates to be replicated. Please read the notes that follow this option list."
"An example of what does not work as you might expect: If the slave is started with --replicate-ignore-db=sales and you issue the following statements on the master, the UPDATE statement is not replicated: "
"If you need cross-database updates to work, use --replicate-wild-ignore-table=db_name.% instead. "
The above three statments is conflicting.
Subject
Views
Written By
Posted
Conflicting DOC
3605
December 30, 2005 12:08AM
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.