4 ms·

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 replic

by jjirsa 9y ago

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

stephenr 9y ago
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.