What is the difference between the two? The protocol on the surface looks different, but I would like to understand what is really different between the two and why they are not equivalent.
Difference between 2PC (2 phase commit) and 2 PL (2 phase locking)
3.1k Views Asked by user855 At
1
There are 1 best solutions below
Related Questions in DATABASE
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- How to not load all database records in my TListbox in Firemonkey Delphi XE8
- microsoft odbc driver manager data source name not found and no default driver specified
- Cloud Connection with Java Window application
- Automatic background scan if user edit column?
- Jmeter JDBC Connection Configuration Parametrization of Database URL for accessing SQL Database
- How to grant privileges to current user
- MySQL: Insert a new row at a specific primary key, or alternately, bump all subsequent rows down?
- Inserting and returning autoidentity in SQLite3
- Architecture: Multiple Mongo databases+connections vs multiple collections with Express
- SQL - Adding a flag based on results within a query - best practice?
- Android database query not returning any results
- Developing a search and tag heavy website
- Oracle stored procedure wrapping compile error with inline comments
- Problems communicating with mysql in php
Related Questions in DISTRIBUTED
- Fill an array with spmd in Matlab
- Hazelcast Distributed Lock with iMap
- is sharding same as distributed database in mongoDB?
- How to start distributed Erlang app without starting dependencies at every node?
- Spark tasks doesn't seem to be well distributed
- OrientDB to automatically create databases on startup
- Unequal distribution of packets in distributed system
- Logical Clocks: Lamport Timestamps
- MPI Random Broadcasting
- Hazelcast (Java) and ETCD (golang) differences/similarities?
- IP addresses in distributed systems
- Usage of RemoteCache with DeltaAware and Delta interface infinispan
- How to achieve similar color distribution with fewer pixels?
- How can I ensure a periodic task will run forever on a linux machine?
- Warning that "unknown addresses are found in partition table"
Related Questions in PAXOS
- several questions about multi-paxos?
- How a distributed storage system like Raft filter duplicate requests even after client session expiration
- Paxos vs two phase commit
- What's the benefit of advanced master election algorithms over bully algorithm?
- Paxos algorithm: Dependency of Accept and Prepare phases
- Doesn't Paxos end up with the same instructions in the exact same order?
- view change algorithm and paxos
- Clarifications regarding Paxos and the paper Paxos Made Simple
- How can I understand "value" in bacis paxos
- paxos algorithm - how does the propose stage work?
- paxos: why do ids have to increase monotonically?
- Can multiple values be accepted in a single run?
- distributed system (RPC + Paxos)
- How paxos work with 2 nodes?
- In "Part-time Parliament" why does using the membership from decree n-3 work to add or remove members?
Related Questions in TWO-PHASE-COMMIT
- How to rollback child transaction if any exception in parent transaction?
- Manipulating order of XA resources
- Canceling a transaction through API
- What is the difference between transaction manager 2 phase commit approach and saga SEC approach?
- Is 2-Phase commit safe or not
- Flink two phase commit for map function to implement exactly-once semantics
- Achieve "all-or-nothing" transaction between Oracle and MongoDB
- concurrent program using simple two phase locking
- Difference between 2PC (2 phase commit) and 2 PL (2 phase locking)
- Two phase commit: what happens if the coordinator dies between sending two confirmations
- Is Two Phase Commit suitable to ensure atomicity when sending an email?
- Using two phase commits on Postgres
- Implementing 2 phase commit in Websphere application server
- JEE-Transaction- vs. JPA Entity Management
- Generic ResourceManager/IEnlistmentNotification for Azure Blob Storage operations to achieve 2 phase commit
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
2 Phase lockingis a mechanism implemented within a single database instance to achieve serializeable isolation level. Serializeable transaction level is the strongest isolation where even with parallely executing transactions, the end result is same as if the transactions where executed serially. It works as follows:Whenever the transaction wants to update an object/row, it must acquire a write/exclusive lock. When transactions wants to read an object/row, it must acquire a read/shared lock. Instead of releasing the lock immediately after each query, the locks must be held till the end of the transaction(commit or abort). So while the transaction is being executed, the number of locks held by the transaction expand/grow. (Read/write lock behavior is similar to any other reader/writer locking mechanisms, so not discussing here)
At the end of the transaction, the locks are released and number of locks held by the transactions shrinks.
Since the locks are acquired in one phase and released in another phase i.e., there are no lock releases in acquire phase and no new lock acquire in release phase, this is called 2 phase locking.
2 phase commitis an algorithm for implementing distributed transaction across multiple database instances to ensure all nodes either commit or abort the transaction.It works by having coordinator(could be a separate service or library within the application initiating the transaction) issue two requests - PREPARE to all nodes in phase 1 and COMMIT(if all nodes returned OK in PREPARE phase) or ABORT(if any node returned NOT OK in PREPARE PHASE) to all nodes in phase 2.
TLDR:
2 phase locking- for serializable isolation within a single database instance2 phase commit- atomic commit across multiple nodes of a distributed database/datastores