CAP Theorem | Trade offs to choose a Database | System Design Primer | Tech Primers

Подписаться 134 тыс.

Просмотров 46 тыс.

50% 1

This video covers what is CAP theorem along with the trade offs in choosing a database with real world examples. It also covers concepts beyond CAP theorem
⏱️ Chapter Timestamps
====================
0:00 - Intro
1:06 - Agenda
1:38 - What is CAP Theorem?
2:27 - Partition Tolerance
3:47 - Consistency
4:14 - CAP Availability
5:55 - Consistency & Availability
9:04 - Consistency & Partition Tolerance
12:15 - Availability & Partition Tolerance
14:35 - Beyond CAP Theorem
📌 Related Links
=============
🔗 Please stop calling Databases CP or AP - martin.kleppmann.com/2015/05/...
🔗 A critique of CAP Theorem (Whitepaper) - arxiv.org/abs/1509.05393
💥Join TechPrimers Slack Community: bit.ly/JoinTechPrimers
💥Telegram: t.me/TechPrimers
💥TechPrimer HindSight (Blog): / techprimers
💥Website: techprimers.com
💥Slack Community: techprimers.slack.com
💥Twitter: / techprimers
💥Facebook: TechPrimers
💥GitHub: github.com/TechPrimers or techprimers.github.io/
🎬Video Editing: FCP
🎼Background Music:
Joakim Karud
Dyalla
---------------------------------------------------------------
🔥 Disclaimer/Policy:
The content/views/opinions posted here are solely mine and the code samples created by me are open sourced.
You are free to use the code samples in Github after forking and you can modify it for your own use.
All the videos posted here are copyrighted. You cannot re-distribute videos on this channel in other channels or platforms.
#CAPTheorem #SystemDesignPrimer #TechPrimers

Хобби

Опубликовано:

30 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 81

@TechPrimers 3 года назад

⏱️ Chapter Timestamps ==================== 0:00 - Intro 1:06 - Agenda 1:38 - What is CAP Theorem? 2:27 - Partition Tolerance 3:47 - Consistency 4:14 - CAP Availability 5:55 - Consistency & Availability 9:04 - Consistency & Partition Tolerance 12:15 - Availability & Partition Tolerance 14:35 - Beyond CAP Theorem

@sushil1922 2 года назад

One confusion, When I want to achieve CA , then why there is a partition , i read and write from the master, thus i achieve CA, but we are also achieving the Partition tolerance with it, isn't it ? coz even after partition, our system is able to still serve.

@RipunjayTripathi-CNT 3 года назад

There is slight ambiguity in explaining Partition and Partition Tolerance - Partition Tolerance is the 'ability' of the system to be able to serve writes OR queries even when there is network partition (i.e. when messages get dropped or arbitrarily delayed). If the system is partition-tolerant, it may not remain consistent for that period, however the tolerance property causes it to sync the newer writes when network becomes healthy again.

@gugolplex 2 года назад

Yes!! A CP database is always consistent even in partition scenarios (connection loss between nodes), but you lose availability during this partition. A AP database is always available even in partition scenarios, but you lose consistency during the partition. Finally, a CA database is available and consistent only if no partition occurs. If some network problem occurs between nodes, the database might lose either its consistency or availability. So it isn't partition tolerant.

@living_curious Год назад

Then what about a CP system? will the data store remain unavailable altogether in case of a network partition (network break or loss of connection within the data store)?

@AmandeepSingh-mo4eo Год назад

Yes correct

@saikarthik8953 3 года назад

Telling us the agenda before entire video..hatsoff for that..you are true tech enthusiast rather than a youtuber

@TechPrimers 3 года назад

Thank you Sai. Yes. Time is money. I would like to give back ppl their time if they are not interested. Appreciate your time 👍🏻

@KhoaNguyen-mv2mu 3 года назад

Thank you so much @Tech Primers, your channel is resourceful. I've learnt a lot about Spring and Java. I really appreciate your works!

@TechPrimers 3 года назад

Thanls Khoa

@vaishalibisht518 3 года назад

thanks for such a comprehensive video on cap theorem.

@pguti778 3 года назад

Very good!!! Please continue with this series!!

@jibin7277 3 года назад

so glad I watched this video in my lifetime

@RaghavendraBoralli 3 года назад

Excellent video..keep posting such videos. Thank you

@raveendrareddy8900 3 года назад

Again new and good stuff helpfull. Thanks bro

@vishalpathak8266 3 года назад

a very decent explanation of CAP theorem

@manikantamaddipati1090 3 года назад

Great work man, Thanks :)

@skillfullSwaroop 3 года назад

Thanks for sharing your knowledge

@TheEntium 3 года назад

Next level explanation!

@janvichitroda4689 2 года назад

Wow! Thank you for giving such detailed explanation. I guess I don't need any other video for explanation of CAP Theorem 😀

@sushil1922 2 года назад

@Janvi One confusion, When I want to achieve CA , then why there is a partition , i read and write from the master, thus i achieve CA, but we are also achieving the Partition tolerance with it, isn't it ? coz even after partition, our system is able to still serve.

@java3711 3 года назад

Thanks for such a nice videos.. pls do more videos on system design and microservice design pattern... only understanding is sufficient no coding required

@preetisagarnayak1515 2 года назад

easy explanation , thanks!

@Van_Verder 2 года назад

Very Helpful, thx!

@rakeshranjan6975 5 месяцев назад

Amazingly explained

@shaswatdasgupta3776 3 года назад

Solid information Ajay. Thanks for this!

@TechPrimers 3 года назад

Thanks shaswant. Glad it’s helpful

@puneet739 3 года назад

Good work buddy. u help us in day today activities and understanding the technical aspects

@TechPrimers 3 года назад

Glad its helpful puneet.

@sushil1922 2 года назад

@@TechPrimers One confusion, When I want to achieve CA , then why there is a partition , i read and write from the master, thus i achieve CA, but we are also achieving the Partition tolerance with it, isn't it ? coz even after partition, our system is able to still serve.

@a143r Год назад

excellent explanation

@jibin7277 3 года назад

You are doing a good job :)

@a123a28 3 года назад

Just Awesome

@rjrobinjames 3 года назад

Excellent video :-) You made it damn easy!!! Can you make something on a typical centralized application logging framework?

@TechPrimers 3 года назад

There is a splunk video robin. You can take a look at that

@ChandraShekhar-by3cd 3 года назад

Nice Explanation pls upload more video on system desing.

@sergeykholkhunov1888 3 года назад

Thank you, this video is usefull)

@vipsclassicalboy 2 года назад

awesome ...

@aneksingh4496 3 года назад

Very nicely explained ... Please post some videos like Facebook news feed design

@ana22331. Год назад

Excellent

@JaNaMSoNi 3 года назад

Please make practical video on 2 Database synchronisation like if we have POS System 1 db for particular system it'll sync with main server.

@adirockerenator 2 года назад

thanks for such an amazing breakdown

@TechPrimers 2 года назад

Glad you liked it!

@sushil1922 2 года назад

@biniluwyz4981 2 года назад

ur great bro keep it up

@kunalsharma-zc2ho 3 года назад

Sir, please continue system design challenges.

@suhasmusick 2 года назад

amazing video!

@TechPrimers 2 года назад

Glad you like it!

@kharthigeyan 3 года назад

Thank you :-)

@dkumarrswamy 3 года назад

Good one

@harshith_takkala 3 года назад

Thanksss

@adhipgupta7108 Год назад

The explanation for the Relational DBs supporting CA is bit confusing. The reason why Relational DBs are Consistent is because the Primary node is the one which clients read and writes to. So every time any client reads the response will be consistent. Availability in Relational DBs is from replicating data from the primary to backup nodes, so in case the primary node goes down, the secondary node is available to respond to requests. However, it isn't partition tolerant because if the network breaks between the primary and secondary it wouldn't be able to replicate data.

@rathnakumar731 3 года назад

Mass bro

@vageeshadiga5218 3 года назад

Nice video

@parthibandhanasekaran6399 3 года назад

Very nice video to understand the CAP theory.

@parthibandhanasekaran6399 3 года назад

Do you have any sample code for dynamic rule engine concepts

@TechPrimers 3 года назад

Check my rule engine video

@madanmohanpachouly6135 2 года назад

Thanks

@jibin7277 3 года назад

Is it safe to assume that all DBs in production are currently distributed? Because CAP applies only to distributed DB situation right?

@codegeek8256 3 года назад

Can you please share how you make your youtube videos please, the process, editing, and the graphix and transitions etc. please

@JavaLovers 3 года назад

Nice one I love the slides, hope you must have used Google slides..!!

@arunkrish8399 3 года назад

Guru can you make a tutorial on Kafka connector, streaming data from one database to another.

@jeyaprakash5519 3 года назад

If possible share your thoughts on modelling time Series(ex: Call Details of user) data using Cassandra / any Nosql DB.

@TechPrimers 3 года назад

I did a video on Prometheus i believe. Try checking that, if that doesn't help let me know, i will do one

@sushil1922 2 года назад

@aditigupta6870 3 месяца назад

what do you mean by mysql through the same function? Can you please clarify this ? at 0:18

@vamsikrishna-iv4oj 3 года назад

May I know.. Why to sacrifice one of the feature among three? Why can't possible to cover with 3 features in any dB? Can you explain..

@TechPrimers 3 года назад

You see the video it’s already explained. If there is partition tolerance, you either get consistency or availability. Since data is isolated and there is now way to sync new data. This is similar to how you get disconnected from internet and not able to view any new updates

@techiethoughts5729 3 года назад

@@TechPrimers I understood that we are loosing either Availability or Consistency when there’s a partition tolerance, but what are we sacrificing in case of relational databases (Which are always available and consistent) as per CAP theorem. Can you please elaborate?

@bindupriya1781 Год назад

while explaining SQL database why you don't use same cluster example used for the other DB's.

@Vishwasp13 3 года назад

Good to see we are getting away with the Master Slave terminology and using Primary Secondary instead.

@TechPrimers 3 года назад

Yes in deed... #DiversityAndInclusion

@user-ny8qv9ze4d 2 года назад

You didn't talk about when P happend, the followers will elect a new leader and there are two leaders in the different subset of network provide read and write.

@lakhandeswal2732 3 года назад

You made it too easy to understand.

@TechPrimers 3 года назад

Glad it’s helpful

@namjitharavind 3 года назад

Google cloud firestore following CP however they can provide more availablity because they are using their own private network. Is it right?

@TechPrimers 3 года назад

General availability is different from CAP Availability Namjith. If there is a partition (failure between nodes in the firestore cluster), you have to choose between consistency or availability, you cannot get both. However beyond CAP theorem you can include Latency as one more parameter, you can choose Latency over Consistency

@user-mc1oe4ms6b 4 месяца назад

The CA part is very misleading. If we choose consistency and availability over partition tolerance, then there must NOT have any network partitions happening.

@ngneerin 2 года назад

Best explanation of CAP theorem i have come across

@gyanasahu1006 3 года назад

CAP theorem as per it's original defn, only speaks about distributed db. Here Availability is not "some data" but should be "all data". Some parts were wrongly explained. Please read up google wiki page.

@TechPrimers 3 года назад

Hi Gyana Sagu, Not sure if you have read CAP Availability. I had mentioned availability mentioned here is different from CAP Availability. If you look at the CAP theorem wiki it says "Availability: Every request receives a (non-error) response, without the guarantee that it contains the most recent write" To my understanding, if the most recent write is not synced, that's not all data. Can you justify your comment?