MySQL Forums
Forum List  »  Docs

Conflicting DOC
Posted by: yongzhen fu
Date: December 30, 2005 12:08AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Conflicting DOC
3556
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.