Re: Slave is not updating some tables .....
Replicate_Do_DB: DB,DB_merge
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table: DB.NOTES
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table: DB.STATISTICS%,DB.TRANSACTIONS%,DB.HISTORY%
-- that is a complicated mess. It restricts what is / is not replicated. The details:
http://dev.mysql.com/doc/refman/5.0/en/replication-rules.html
I prefer not to mix DO and IGNORE; it is too confusing to figure out what it will/won't replicate.
Subject
Views
Written By
Posted
3268
June 19, 2009 08:47AM
1970
June 19, 2009 10:30AM
Re: Slave is not updating some tables .....
1876
June 20, 2009 03:40PM
2489
June 22, 2009 12:56AM
1958
June 22, 2009 02:48AM
1908
June 22, 2009 10:41AM
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.