Auto Increment problems MariaDB

March 20, 2016 4.1k views
MariaDB MySQL
ZoonixDevs
By:
ZoonixDevs

Recently, I’ve deployed 3 MySQL servers with MariaDB, linked them all together for a fully redundant MySQL Server Cluster. However, I seem to be having a huge problem with auto increment. At the moment, it’s leaving gaps of two each time when it’s putting IDs for new inserts into the database. I’m using MyISAM is that helps any more however this is happening on all table types within the deployment that I have set.

Anyone have any idea on how I can stop this?

Log In to Comment
1 Answer
rufio March 21, 2016

Hmm - not sure if you are using MariaDB’s Galera Cluster - But if so, this might be helpful:

Do not rely on auto-increment values to be sequential. Galera uses a mechanism based on autoincrement increment to produce unique non-conflicting sequences, so on every single node the sequence will have gaps. See http://codership.blogspot.com/2009/02/managing-auto-increments-with-multi.html

Reference: https://mariadb.com/kb/en/mariadb/mariadb-galera-cluster-known-limitations/

Reply
Have another answer? Share your knowledge.

Related Questions