News for hackers. Stuff that matters.

A comment on One million queries per second with MySQL. Parent comment

Re:One million queries per second with MySQL by tyre on Friday September 02, 2022 @12:55AM (#32686753)
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?

[ Parent | on HN ]
Re:One million queries per second with MySQL by petre on Friday September 02, 2022 @01:05AM (#32686799)
Yeah, we would need to redesign everything from the ground up. And sequences are only useful on unsharded keyspace.
[ Parent | on HN ]
Re:One million queries per second with MySQL by harshitgangal on Friday September 02, 2022 @04:43AM (#32688266)
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.

[ Parent | on HN ]