TechQA.

MySQL Single Primary Group Replication - auto_increment_increment

127 views Asked by user14934989 At 31 March 2022 at 13:56

I am setting up MySQL Group Replication with the following configuration

1 Virtual IP
2 ProxySQL
3 MySQL Servers with Single Master Group Replication

I understand why MySQL chose to use 7 as the default auto_increment_increment value (link), my question is

Considering only one node will be responsible for the updates at any given point of time, is it safe to set auto_increment_increment value to 1 in my setup?

There are 0 answers