News for hackers. Stuff that matters.

A comment on Why SQL is beating NoSQL, and what this means for the future of data. Parent comment

Re:Why SQL is beating NoSQL, and what this means for the fut... by jjirsa on Wednesday September 27, 2017 @12:26PM (#15349407)
There exists a LOT of data models that don’t use auto incrementinf primary keys. Rarity or not, it’s a real use case and a real problem for master/master replication

Also, even if you do use auto increment with offsets for each server, you’ll have to know how many servers you’ll eventually have, or waste offsets and eventually risk outrunning your data types

[ Parent | on HN ]
Re:Why SQL is beating NoSQL, and what this means for the fut... by stephenr on Wednesday September 27, 2017 @12:33PM (#15349481)
Non auto keys will already need some way to ensure uniqueness that will involve the application expecting conflicts.

For those that do use auto inc, galera will manage the offset/increment value based on cluster size automatically.

[ Parent | on HN ]