Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
Auto Increment problems MariaDB
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?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×