Drupal tables to be ignored in mysql master master (multi master) replication setup configuration
# The reason why use "replicate-wild-do-table" instead of "replicate-do-db"
# is because replicate-do-db does not work on cross-database statements, for example:
#
# UPDATE some_db.some_table SET foo='bar';
# can choose to use either "replicate-wild-do-table" or "replicate-wild-ignore-table"
#replicate-wild-do-table=rep_db1.%
#replicate-wild-do-table=rep_db2.%
#replicate-wild-do-table=rep_db3.%
replicate-wild-ignore-table=drupal_db.cache%
replicate-wild-ignore-table=drupal_db.languages
replicate-wild-ignore-table=drupal_db.search_%
replicate-wild-ignore-table=drupal_db.sessions
#replicate-wild-ignore-table=drupal_db.visitors
replicate-wild-ignore-table=drupal_db.watchdog
replicate-wild-ignore-table=drupal_db.history
Other tables might need to take into account:
[] variable
[] system
Friday, November 19, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment