'MySQL Single Primary Group Replication - auto_increment_increment

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?
mysqlreplicationhigh-availabilitymysql-group-replication


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions