Hello;
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.
Hello;
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: [url]http://www.codership.com/content/controlling-auto-increments[/url]
Przemek;
Thanks for your help.
Unanswered | Unsolved | Solved
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2021 Percona LLC. All rights reserved.