drupal increase ID


I have a cluster of 3 nodes. In the drupal database insertions increase the ids of 3 instead of 1.

Is there a specific option to enable the ids to be incremented by 1?

Thanks in advance.

This is a default behaviour of galera based cluster, that it controls auto_increment and sets the offset accordingly to cluster size, in order to avoid conflicts when writes happen to more then one node at a time. So you probably don’t want to change that. See more details: http://www.codership.com/content/controlling-auto-increments


Thanks for your help.