Tan Shun's Blog

TL; DR

REPEATED READ is the default isolation level in MySQL. It solves the following:

• Dirty reads: reads uncommitted data (READ COMMITTED has solved this)
• Nonrepeatable reads: reads different data in the same transaction for the same row even UPDATEs are not executed
• Phantom reads: reads additional rows or missing rows in the same transaction, even INSERTs or DELETEs are not executed

This blog post mainly focuses on how nonrepeatable reads and phantom reads are solved by REPEATED READ isolation level and the unsolvable anomalies in REPEATED READ.

TL; DR

Summarize how to generate a unique ID.

TL; DR

Summarize how to do the estimation.

TL; DR

I started to focus on System Design recently. This blog series will record what I learn in a Q&A format. By the way, the material is from Grokking Modern System Design Interview for Engineers & Managers. In this article, I will summarise what I have learned from Chapter 1 to Chapter 4.

TL; DR

这是一篇关于 Raft 知识点总结的博客。总结的不全，尤其是 Snapshot 那块。如果有理解错误或者笔误的地方请联系我！

主要参考：

• 论文：https://github.com/ongardie/dissertation/blob/master/stanford.pdf
• ETCD 的文档：https://github.com/etcd-io/etcd/blob/main/raft/README.md

TL; DR

It’s about Gift Shopping.

TL; DR

It’s about Buying Groceries.

TL; DR

It’s about Going On Diet.

TL; DR

It’s about Something Sweet

TL; DR

It’s about What’s for dinner.