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

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...