1 year ago

#359415

test-img

user14934989

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?

mysql

replication

high-availability

mysql-group-replication

0 Answers

Your Answer

Accepted video resources