Скачать или смотреть Distributed Transaction بالعربي With Mostafa Mansour & Ahmed Elemam - Tech Podcast بالعربي

Podcast with Mostafa Mansour
Tech Podcast بالعربي

Slides
https://docs.google.com/presentation/...

Agenda
What are distributed transactions and why do we need them?
Query vs Transaction
ACID
Isolation and Definition of serializable and motivation (double booking)
Dirty Reads : Read while rolling back of a commit
Non-repeatable reads: Read while updating
Phantom Reads: Read after inserting.
Lost Updates: Read after deleting
Read Uncommitted, read committed, repeatable read (committed updates at the beginning of transaction), Serializable.
Performance goes down with every Isolation
Serialization Check
Read-Write Conflict, Write-Write Conflict, Phantom read.
Durability
Audit transactions and Gitlab incident and how they rebuilt it
Optimistic and Pessimistic Locking
Exclusive lock vs shared lock & Pros and Cons of each

Concurrency control
(i) enforces isolation among transactions.
(ii) preserve database consistency through consistency preserving execution of transactions.
(iii) resolve read-write and write-read conflicts.

Two Phase Locking and deadlock prevention
(i) Growing Phase
(ii) Shrinking Phase

Time Stamp
System Clock
Logical Counter (Though we’ll have to reset the counter from time to time to avoid overflow)
Multi version locking

Patterns for Distributed Transactions
(i) Two Phase Commit
(ii) Saga
(iii) Orchestrator
(iiii) Choreography


Resources
Lecture 12: Distributed Transactions
https://hazelcast.com/glossary/distri...
https://developers.redhat.com/blog/20...
What are database transactions? (educative.io)
  / the-seven-most-classic-solutions-for-distr...  
https://www.cockroachlabs.com/blog/di...
   • Relational Database ACID Transactions (Exp...  
https://learn.microsoft.com/en-us/sql...
https://www.cockroachlabs.com/docs/st....
   • How to do Distributed Transactions the RIG...  
   • Distributed Transactions are Hard (How Two...  
   • Lec 18 Part 5 Serializability  
https://www.geeksforgeeks.org/concurr...
https://www.tutorialspoint.com/explai...
https://www.geeksforgeeks.org/concurr...
https://www.geeksforgeeks.org/lock-ba...
What is the two-phase commit protocol? (educative.io)
   • Dev Deletes Entire Production Database, Ch...