Friday, November 19, 2010

Drupal tables to be ignored in mysql master master (multi master) replication setup configuration

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

No comments: