Re:We Chose a Distributed SQL Database to Complement MySQL
by qaq on Saturday August 29, 2020 @04:26PM
(#24319184)
Thanx for the detailed resp. Just to clarify TiDB uses 2pc too for cross region transactions from what I remember?
[ Parent
| on HN ]
Re:We Chose a Distributed SQL Database to Complement MySQL
by gregwebs on Saturday August 29, 2020 @04:45PM
(#24319300)
Yes, it is a form of 2PC that happens transparently during normal transactions. It is designed to perform well for production workloads whereas Vitess now has 2PC but warns against using it and requires configuration changes to enable it.
Re:We Chose a Distributed SQL Database to Complement MySQL
by mmerlin on Saturday August 29, 2020 @06:06PM
(#24319753)
2PC =
two-phase commit
https://en.m.wikipedia.org/wiki/Two-phase_commit_protocol
For anyone like me whose neural net had a cache miss due to lack of caffeine activation function ;)