Snapshot is good enough. And then do all your related table changes in a single ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		gigatexal on Dec 19, 2023 \| parent \| context \| favorite \| on: Jepsen: MySQL 8.0.34 Snapshot is good enough. And then do all your related table changes in a single atomic txn and you’re good

aphyr on Dec 19, 2023 [–]

That depends! As the article discusses, snapshot allows anomalies--like write skew--which might violate application invariants. Depends on your workload.

gigatexal on Dec 20, 2023 | [–]

Oh right OLTP stuff in that case I’m a bit rusty there. Most everything I do is on the OLAP side.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact