Join Log in
Score:0
Ror avatar Server

Mariadb replication - Ignore users changes

om flag
Ror

I need to set up multi-source replication (3 masters and 1 slave). Since all masters have users with the same name but not the same rights, I'd like to avoid replicating users' changes on the slave because it breaks replication.

I've followed this : MySQL Replication failing on `mysql`.`user` changes but it didn't seem to work.

I've tried different configurations but none works.

  • Ignore table mysql on the slave :
replicate_ignore_db=mysql
  • Ignore table mysql for each connection on the slave:
master1.replicate_ignore_db=mysql
master2.replicate_ignore_db=mysql
master3.replicate_ignore_db=mysql
  • Ignore the mysql table in the master's binlog :
binlog-ignore-db=mysql

I'm working with Mariadb 10.6 on Debian 9. The master's binlog format is ROW.

I'm still getting errors in the replication regarding users changes. How can I make the replication ignore the users' changes ?

20
0 + 0
cn flag
Bob
You might want to ask on https://dba.stackexchange.com/ instead. - *"all masters have users with the same name but not the same rights"* that sounds like a recipe for disaster to me. - I also wouldn't be surprised if there may be a difference in looking at the replication of the underlying `mysql.*` tables compared to how specific user manipulation statements such as `CREATE USER` and `GRANT` get replicated.
1
Reply
ธงชาติไทย
Elon Musk
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.