Comment

Comment by elendilm

Usually first principles architectures and systems engineering doesn't require you to be validated by big players. You can always spin up and do your own measurements.

Yet since you asked, assuming good faith, here is what you are looking for.

Following is an excerpt from https://www.uber.com/us/en/blog/schemaless-part-one-mysql-da...

< The indexes are eventually consistent; whenever we write a cell we also update the index entries, but it does not happen in the same transaction. The cells and the index entries typically do not belong to the same shard. So if we were to offer consistent indexes, we would need to introduce 2PC in the writes, which would incur significant overhead. With eventually consistent indexes we avoid the overhead, but Schemaless users may see stale data in the indexes. Most of the time the lag is well below 20ms between cell changes and the corresponding index changes >

parent elendilm 12 days ago

Discussion

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton