Tidb: How to create unique rowID on multiple node TiDB

Created on 17 Sep 2019 · 2Comments · Source: pingcap/tidb

I read your blog, I have a question: How will the rowID be created on multiple TiDB nodes if the table's primary key is not an int? Because rowID is unique for each table, but we have multiple node TiDB.

typquestion

Source

phamtai97

Most helpful comment

I got the same question and dig into the code a bit, I am not sure it's all correct but here is what I found

AddRecord requires to create new record id(s) if the record does not have a int primary key
allocator allocates ids using a tikv transaction, so you get unique id across entire system instead of a local counter
also rowid may not be a mono id based on Complex hotspot problem

at15 on 3 Feb 2020

👍2

All 2 comments

I got the same question and dig into the code a bit, I am not sure it's all correct but here is what I found

AddRecord requires to create new record id(s) if the record does not have a int primary key
allocator allocates ids using a tikv transaction, so you get unique id across entire system instead of a local counter
also rowid may not be a mono id based on Complex hotspot problem

at15 on 3 Feb 2020

👍2

Close this issue due to no feedback for a long time.
Feel free to reopen it if you need any further help.