MySQL Single Primary Group Replication - auto_increment_increment

145 Views Asked by user14934989 At 19 October 2024 at 23: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 best solutions below