Hacker News Reader

They document why auto_increment has issues across shards and the sequence solution that they’ve developed. https://vitess.io/docs/14.0/reference/features/vitess-sequen...

Is there a use case that sequences don’t handle for you?

Yeah, we would need to redesign everything from the ground up. And sequences are only useful on unsharded keyspace.

Sequences actual use is for sharded keyspace. For unsharded you can just continue to use auto_increment.

Maybe your application has some special logic which is complex enough to unwind. I am just clarifying for the second statement.