0

I have a mariadb slave that cannot have the same permissions and users as the the mysql master. Is there a way to configure the slave so that it does not replicate changes to the mysql system tables and does not try to run GRANT statements?

I am currently using replicate_wild_do_table=mydb.%, and I tried using replicate_wild_ignore_table=mysql.% but that did not seem to ignore the GRANT statements.

I noticed replicate_wild_do_table=mydb.% seems to be sufficient on a mysql slave to not replicate changes to the mysql system table, but it is not sufficient on a mariadb slave.

1 Answer 1

0

Use binlog-ignore-db instead. This post explains the behaviour and answers your question. If not, comment.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.