All Types of Database Replication Discussed
HTML-код
- Опубликовано: 29 май 2021
- 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 RUclips
/ @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 Наука
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.
Ohhh great point!! expressions can yield different results ...
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
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.
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 🔥🔥
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.
This is how interesting it could become if Vir Das was an engineer :)
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.
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)
The database sensei we all needed!
This is pure gold, you are literally marking cs fun 😄💖
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.
Very informative...keep posting such insightful videos
Really funny and informative. Thanks!
This guy needs more views!
And I like simplicity 😊. Great video 👍👍👍👏👏👏
Thanks hussein. Amazing content
Greetings from Syria
@Hussein, Have you come across Fauna DB
This is one topic I have no idea about. As a college student never needed anything to do with db replication
Learning while I laugh my ass off is awesome! :)
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?
How do you do your research
Being a data scientist, I feel like a poor schlob XD
Sir can you make a series on Dynamodb
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?
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 ?
If it’s not beautiful I send it back😆 nice reference
Once Report Manager Started, then replication is initialised
Paypal has blocked me from becoming a member of your channel. They've asked that I submit your date of birth................... WTF!?
its an on going problem with Paypal and RUclips :( Paypal shouldn't care about my birthday as a creator they are paying RUclips.. just give them a bogus Birthday because they don't even know my birthday nor they shouldn't
Not everything is made up.