Should you go with an Optimistic or Pessimistic Concurrency Control Database?


Manage episode 296445709 series 1954062
By Hussein Nasser. Discovered by Player FM and our community β€” copyright is owned by the publisher, not Player FM, and audio is streamed directly from their servers. Hit the Subscribe button to track updates in Player FM, or paste the feed URL into other podcast apps.

MongoDB, Postgres, Microsoft SQL Server, or MySQL, or any other database manages concurrency control differently. There are two methods, pessimistic and optimistic, both have their pros and cons. Let explore how different databases implement this and what is the effect on performance/scalability.

This is often known as Optimistic vs pessimistic locking. Although I don't really like to use locking with this because it confuses the story.

0:00 Intro

2:20 What is Concurrency Control

6:00 Pessimistic Concurrency Control

14:50 Optimistic Concurrency Control


Become a Member on YouTube

πŸ”₯ Members Only Content

Support my work on PayPal

πŸ§‘β€πŸ« Courses I Teach

--- Support this podcast:

421 episodes