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?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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/
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.