Score:0

MySQL replication warning "Automatically adding IPv4 localhost address to the allowlist. It is mandatory that it is added."

cn flag

I have a MySQL 8.0.27 InnoDB cluster running on three Ubuntu 20.04 servers. Everything's working fine, but when MySQL starts I get these warnings in MySQL's error log:

2021-12-07T21:26:47.858979Z 2 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the allowlist. It is mandatory that it is added.'

2021-12-07T21:26:47.859017Z 2 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv6 localhost address to the allowlist. It is mandatory that it is added.'

I believe that this relates to group_replication_ip_allowlist in MySQL. It's definitely getting read (I can break replication by putting the wrong values in) but I can't suppress these warnings. For example, I was hoping that:

group_replication_ip_allowlist = 127.0.0.1,192.168.1.0/24

would stop the IPv4 warning. What am I missing?

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.