In my site's master/slave setup:
- Replicate_Wild_Ignore_Table = %.cache%, &
- Replicate_Ignore_Table is empty.
What's the difference between the two?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.