Tag: Transactions
Comparing Oracle and PostgreSQL Transaction Systems
Original by Laurenz Albe. Translation and commentary by Feng Ruohang. Transactions sit at the heart of relational databases. They guarantee data integrity for applications. SQL defines some transactional behavior but leaves plenty unspecified, so …
Original by Laurenz Albe. Translation and commentary by Feng Ruohang. Transactions sit at the heart of relational databases. They guarantee data integrity for applications. SQL defines some transactional behavior but leaves plenty unspecified, so …
MySQL's ACID is a real mess
MySQL was once the world’s most popular open-source relational database. However, popularity doesn’t mean advanced, and popular things can have big problems. JEPSEN’s evaluation of MySQL’s isolation levels pierced through this veneer — in …
MySQL was once the world’s most popular open-source relational database. However, popularity doesn’t mean advanced, and popular things can have big problems. JEPSEN’s evaluation of MySQL’s isolation levels pierced through this veneer — in …
Concurrency Anomalies Explained
Concurrent programs are hard to write correctly and even harder to write well. Many programmers haven’t truly figured out these problems - they just dump them all on the database. Concurrency anomalies aren’t just theoretical problems: these …
Concurrent programs are hard to write correctly and even harder to write well. Many programmers haven’t truly figured out these problems - they just dump them all on the database. Concurrency anomalies aren’t just theoretical problems: these …
Consistency: An Overloaded Term
The term consistency is heavily overloaded, representing different things in different contexts and situations: In the context of transactions, such as the C in ACID, it refers to the usual Consistency In the context of distributed systems, such as …
The term consistency is heavily overloaded, representing different things in different contexts and situations: In the context of transactions, such as the C in ACID, it refers to the usual Consistency In the context of distributed systems, such as …