In my site's master/slave setup:
- Replicate_Wild_Ignore_Table = %.cache%, &
- Replicate_Ignore_Table is empty.
What's the difference between the two?
master-master-replicationmaster-slave-replicationMySQL
In my site's master/slave setup:
What's the difference between the two?
Best Answer
The Replicate_Wild_Ignore_Table option allows you to specify table names using wildcard characters. The Replicate_Ignore_Table option does not (only complete table names may be used).
See the MySQL manual for more details.