MySQL NDB auto_increment backfilling

Question

We had standalone DB with innodb engine, on it `auto_increment was working perfectly giving sequential numbers 1,2,3,4,5

But when we moved to NDB Cluster, it started backfilling available numbers. for example if i have

12,13,14,16,17

if i add new entry it will take place 15 it suppose to add entry in 18

is there any configuration this there? which we missed?

UPDATE

SHOW CREATE TABLE tablename output is following

 in_invoices | CREATE TABLE `in_invoices` (
      `invoice_id` int(11) NOT NULL AUTO_INCREMENT,
      ...
      ...
      ENGINE=ndbcluster AUTO_INCREMENT=2051 DEFAULT CHARSET=utf8 |

It sounds like the behavior you're seeing is that it **is** backfilling. — Barmar, Nov 12 '15 at 21:20
But your question says "When we moved to NDB Cluster it is **not** backfilling numbers". — Barmar, Nov 12 '15 at 21:27
What does it say in the `AUTO_INCREMENT=` field when you do `SHOW CREATE TABLE tablename`? — Barmar, Nov 12 '15 at 21:30
@Barmar sorry it was typo i have remove **not** keyword, thanks correction — Satish, Nov 12 '15 at 21:36
You left out the part I asked for. At the end it should say `ENGINE=NDBCLUSTER AUTO_INCREMENT=something` — Barmar, Nov 12 '15 at 21:42
And when you insert a new row, it doesn't give it `invoice_id = 2051`, it fills in a gap instead? — Barmar, Nov 12 '15 at 21:59

score 0 · Answer 1 · answered Dec 01 '15 at 20:58

0

The definition of AUTO_INCREMENT says that they will be distinct values, it says nothing about backfilling or not, nor when gaps are generated. Do not depend on such.

answered Dec 01 '15 at 20:58

Rick James

135,179
13
127
222

MySQL NDB auto_increment backfilling

UPDATE

1 Answers1