All Types of Database Replication Discussed

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

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

50% 1

In this episode, I will discuss the different types of database replication and the pros and cons of each, streaming binary, logical, synchronous, asynchronous, one-way, and two-way replication. If you enjoy database systems check out my database engineering course head to husseinnasser.com/courses for a discount code.
Support my work on PayPal
bit.ly/33ENps4
Become a Member on RU-vid
/ @hnasr
🧑‍🏫 Courses I Teach
husseinnasser.com/courses
🏭 Backend Engineering Videos in Order
backend.husseinnasser.com
💾 Database Engineering Videos
• Database Engineering
🎙️Listen to the Backend Engineering Podcast
husseinnasser.com/podcast
Gears and tools used on the Channel (affiliates)
🖼️ Slides and Thumbnail Design
Canva
partner.canva.com/c/2766475/6...
🎙️ Mic Gear
Shure SM7B Cardioid Dynamic Microphone
amzn.to/3o1NiBi
Cloudlifter
amzn.to/2RAeyLo
XLR cables
amzn.to/3tvMJRu
Focusrite Audio Interface
amzn.to/3f2vjGY
📷 Camera Gear
Canon M50 Mark II
amzn.to/3o2ed0c
Micro HDMI to HDMI
amzn.to/3uwCxK3
Video capture card
amzn.to/3f34pyD
AC Wall for constant power
amzn.to/3eueoxP
Stay Awesome,
Hussein

Наука

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

29 май 2021

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

You Sir rocks. That was fantastic explanation. One additional problem with statement based-replication is the random() functions in SQL, it will generate different random values on separate machines.

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

Ohhh great point!! expressions can yield different results ...

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

Problem with Statement bases replication is the deterministic values like (Identify column value, GetDate(), Rand()) etc cannot be ensured that these value are same. Thanks for sharing information 👍. Appreciate your efforts.

@2tce Год назад

The consistency context here is Read Consistency. Even with Sync replication, it is possible two for 2 clients to read different values for the same data. Remember, the read replicas are still "serving" reads AFTER the Master server commits.

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

Hey Hussain ... Love your content..👍 Can you make a video on ... 1.>Different Indexes type in Postgresql And explaining them , pros and cons .. With some practical examples.. 2.>How to Optimize the LIKE pattern matching for million rows in postgresql... And there is something called trigrams in postgresql, I think I spelled it right ... Thanks for all the content you have made 🔥🔥

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

I selected logical replication in Postgres as it works between different versions of Postgres. I also found that the primary key does not get replicated which felt wierd but felt safe so primary key conflicts do not occur. It also tolerates table schema differences. One wierd thing I observed was logical replication on the same machine (Yes. I created the slot before creating the subscriber.) caused CPU and disk thrash even though nothing was being replicated. I now switch off logical replication on my test machine but works fine in production between two machines. I like things simple too so only one way or simplex replication.

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

This gentleman literally has almost all this knowledge on top of his head and can explain in a such clear way!! Keep up the good work! (I enjoy watching 1.5x play speed)

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

The database sensei we all needed!

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

This is pure gold, you are literally marking cs fun 😄💖

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

This is how interesting it could become if Vir Das was an engineer :)

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

18:40 I think you might have been talking about the slightly more modern consensus consistency (CAP) protocol: Raft, the older one is called: Paxos.

@aneksingh4496 Год назад

Very informative...keep posting such insightful videos

@andresgutgon Год назад

Really funny and informative. Thanks!

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

This guy needs more views!

@user-uj2dj8gk1p 3 года назад

And I like simplicity 😊. Great video 👍👍👍👏👏👏

@juststudying1019 Год назад

Thanks hussein. Amazing content Greetings from Syria

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

This is one topic I have no idea about. As a college student never needed anything to do with db replication

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

Check out my Introduction to Database Engineering udemy course database.husseinnasser.com Learn the fundamentals of database systems to understand and build performant backend apps

3 года назад

Learning while I laugh my ass off is awesome! :)

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

I’m migrating a DB at work and I’m realizing how much I don’t know. Like how do I know how much CPU and RAM I need?

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

How do you do your research

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

@Hussein, Have you come across Fauna DB

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

Sir can you make a series on Dynamodb

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

I had been stuck on a problem for 3 days. Scratched through every result from Google but couldn't solve the problem. Finally, I watched this video and realised there is this thing called replication methods that the dbms uses. Here's the problem. I am creating a SaaS app in which I was managing each tenant in a different database. And when a new user would come and register. They wouldn't be able to login because their newly created database wasn't found. And the reason for that was my dbms was using asynchronous replication. What should be the workaround to this problem?

@mohamedmoideen2061 9 месяцев назад

Once Report Manager Started, then replication is initialised

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

Being a data scientist, I feel like a poor schlob XD

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

Synchronous replication would also not achieve consistency right, only "eventual consistency" ? So if I have 5 replicas, and I write to master, let's say 4 replicas gets updated but 5 is not successful; at this point the master and the 5th replica has old data right, making it not consistent at the moment ?

@meldinway Год назад

If it’s not beautiful I send it back😆 nice reference

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

Paypal has blocked me from becoming a member of your channel. They've asked that I submit your date of birth................... WTF!?

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

its an on going problem with Paypal and RU-vid :( Paypal shouldn't care about my birthday as a creator they are paying RU-vid.. just give them a bogus Birthday because they don't even know my birthday nor they shouldn't