System Design Mock Interview: Design TikTok ft. Google TPM

  Рет қаралды 512,426

Exponent

Exponent

Күн бұрын

Пікірлер: 450
@jasper5016
@jasper5016 2 жыл бұрын
Interviewer - Design TikTok Candidate - I never used TikTok Interviewer - Great. Go ahead.
@praveensg
@praveensg 3 жыл бұрын
As a hiring manager, here is one tweak I'd add to this interview. When asked if you'd like to improve your design, always say yes. Have a few simple concepts in your backpocket. E.g redis clustering, queueing, analytics using nosql etc.
@cool_scatter
@cool_scatter 3 жыл бұрын
I mean, he basically said "yes, and here's what I would add if I had time."
@jamesevans2507
@jamesevans2507 2 жыл бұрын
How about I give an honest and full answer and you don't judge me when I have nothing to add because I already gave everything? God I hate you corporate scumbags and your stupid games.
@SHEEPeros
@SHEEPeros 2 жыл бұрын
Seems kinda obvious to say yes but can expand what specifically are you looking for? Your suggestion implies to me you’re looking for knowledge of optimising and monitoring production applications.
@ruyvieira104
@ruyvieira104 Жыл бұрын
"just toss in redis"
@iamworstgamer
@iamworstgamer Жыл бұрын
thats a very vague question in system design, you need to specify the area where it needs to optmize. learn to ask question first. so called hiring manager
@SchoolScience
@SchoolScience Жыл бұрын
This is how it should be. System design interviews are supposed to be interactive and interviewee should feel welcoming and that he is discussing with his future team mate. But in majority of the cases atleast from where I come, interviewers feel like they are the supreme architects who designed all the great apps on the internet and interviewee is a kid.
@elmirbrdar1045
@elmirbrdar1045 Жыл бұрын
I love how all the google employees reference S3 and EC2 rather than GCP itself 😂
@awaisqarni9428
@awaisqarni9428 Жыл бұрын
This is amazing and funny at the same time
@alHailHale
@alHailHale 8 ай бұрын
He isn't yet working for Google. He said he was about to move there from oracle.
@Rasmanit
@Rasmanit 6 ай бұрын
​@@alHailHalePoint still stands, Oracle has their Cloud services.
@MJ-cf9nl
@MJ-cf9nl 2 ай бұрын
Yeap, similar to how all of Microsoft employees use Linux and Mac computers
@haihuynh8337
@haihuynh8337 Ай бұрын
Using other providers' product is a way to learn what others provide and remain updated. Using in-house product means you close yourself from the world.
@oliviatierney6724
@oliviatierney6724 3 жыл бұрын
This is a great example of a system design interview. I have been interviewing for mid level developer roles and those questions tend to focus more on the API design rather than the distributed system design. I would like to see more videos that focus on designing the API rather than the distributed system. Thank you for all these videos. They are very helpful
@MaxCoplan
@MaxCoplan 3 жыл бұрын
That milkshake someone is drinking in the background sounds delicious!
@DeepakVishwakarma-ts3lc
@DeepakVishwakarma-ts3lc 3 жыл бұрын
Z
@devakash2
@devakash2 3 жыл бұрын
His mic is constantly brushing his clothes causing that annoying noise :(
@rajbiswas776
@rajbiswas776 3 жыл бұрын
@@devakash2 r/woosh
@LoganGabriel
@LoganGabriel 3 жыл бұрын
Surely the Googler can afford a better mic; frankly it amazes me how people just ignore terrible audio quality when a substantial improvement is easy and would cost ~$30!
@Vamshk
@Vamshk 3 жыл бұрын
@@LoganGabriel He wasn't onboarded to Google by that time. He just left Oracle. Probably Oracle didn't pay him well 🤷‍♂️
@dewy1503
@dewy1503 3 жыл бұрын
13:30 I don't feel as though there was enough thought put into the SQL vs NoSQL discussion. In my opinion based on the non functional requirements presented to us for a highly available system and 1 million active users per day, I think the data scalability should be a huge consideration in that decisions but wasn't even mentioned. Horizontally scaling a SQL database is possible with sharding etc. but can be complicated to do. NoSQL can pretty trivially and cost effectively scale horizontally especially in cloud environments. And the data we are storing related to the videos is just small chunks, we aren't really leveraging a lot of structured data schemas or anything like that. I don't know, I just think I challenge that decision a little bit.
@Jiten2141
@Jiten2141 3 жыл бұрын
Totally agree with you. I had the exact same thought. I didn’t see any relational operation requirements that would require SQL database.
@jack110311
@jack110311 3 жыл бұрын
Jokes aside, it can be good to start with a simpler solution and then later on adjust it as you work through bottlenecks.
@123vat69
@123vat69 3 жыл бұрын
How to pull the videos of users you follow ,I guess that needs a join.Otherwise we have to denormallize and keep all the user and follower information in single table which I assume is bit complex and might have lot of data redundancy
@TechVlogger00
@TechVlogger00 3 жыл бұрын
He has outsourced the pull videos from ppl one follows to a prefetch service lol
@osta6212
@osta6212 3 жыл бұрын
@@123vat69 that makes sense.
@deathbombs
@deathbombs 2 жыл бұрын
9:40 very concise way to check if you're on track and move to next stage 11:22 I like how you skip the uninteresting stuff that aren't a problem
@B-Billy
@B-Billy 3 жыл бұрын
I'm really impressed by the questions he asked as part of the Functional Requirement. Those were serious questions ❤️
@Enjoyablewalks
@Enjoyablewalks 2 жыл бұрын
True
@SafetyLast-_-
@SafetyLast-_- 2 жыл бұрын
The sound quality is a bit disappointing: all these noises and crackles. But the interview itself was pretty interesting and useful. Thanks for sharing 👍
@DoctorLai
@DoctorLai Жыл бұрын
Something to add: 1. how do you handle creation of unique video ids? 2. how do you authenticate users? 3. how do you handle the thumbnails and different solutions of the videos? 4. how do you handle the video duplications? for example, if a user uploads a video twice? how about different users upload same video? 5. how do you handle hot videos or users? 6. I would add some message queues to decouple the components
@chendavid9582
@chendavid9582 2 жыл бұрын
This perons is so pro. Technical background is solid, talking is so good. I wouldn't be surprised he can become director soon! All in all talking and expressing your thoughts is the most important.
@andrewkicha1628
@andrewkicha1628 Жыл бұрын
Great job mediating the interview, I really like how you asked Adam to dive into the discussion about relational vs non-relations DBs, we would miss good chunk of information without it.
@kkud01
@kkud01 3 жыл бұрын
How to create view feed is perhaps the most important and complex question, for some reason not touched, the only mentioning that it will be prebuilt
@ElanHasson
@ElanHasson 3 жыл бұрын
Yep too high level. If this is the interview bar I'm doing really great. Totally a SDE9
@tryexponent
@tryexponent 3 жыл бұрын
Don't leave your career to chance. Sign up for Exponent's system design interview course today: bit.ly/3PhhbMY Liked this video and want to see more? Let us know by clicking "Subscribe"
@BhushiBalboa
@BhushiBalboa 3 жыл бұрын
A bit disappointed, in my opinion below aspects should have been focused on - 1. How will your architecture support a million users. 2. What makes your architecture scalable 3. What mechanism will you use to search content across millions of video metadata 4. How will your data storage be available across geographies 5. How will you enable a stream of videos of users that you follow These are the core questions, what he designed can be a good starting point, but unfortunately the challenging part wasn't tackled
@count3ears
@count3ears 3 жыл бұрын
Nearly impossible to cover this in the time available for a systems design interview
@PC-to3rg
@PC-to3rg 2 жыл бұрын
pre-cache needs more explanation. when will it invalidate for billions of users. W/o users on the system it will still keep running. Is it optimal?
@ignashi7plays401
@ignashi7plays401 Жыл бұрын
@@count3ears Bruh they spent only 32 mintues. System design interviews are generaly 1 hr. It would look bad if you end the interview in just 30 mins.
@shashankshekhar8970
@shashankshekhar8970 3 жыл бұрын
I feel the interview could have been a bit more engaging, Few areas would have covered: 1. SQL vs NoSQL, given that its High Avalaibility, Read heavy, huge data volume and the only relation we have is user-video, why would you use SQL 2. Elaborate more on Video upload API. How would the upload happen? Multipart form data? 3. Talk more about the pre cache service but you mentioned you would have done that with more time
@shairuno
@shairuno 3 жыл бұрын
I wish I can be calm, smooth, and slowly add the complexity to my design like this man. This man is so smooth , just like the milkshake in the background. Great mock interview.
@doorveshsantbakshsing9607
@doorveshsantbakshsing9607 2 жыл бұрын
lmfao the milkshake.
@MrB711
@MrB711 2 жыл бұрын
LOL
@bakkks
@bakkks 3 жыл бұрын
There is an entire industry built around passing the SE interview :) Looks similar to the 'how to become rich in the stock market' courses, the authors are making way more money apparently teaching you how to go and pass the interview then going themselves and pass it :)
@Zero-ui4ep
@Zero-ui4ep 2 жыл бұрын
facts
@sefer-nv6cn
@sefer-nv6cn 2 жыл бұрын
But they probably can actually pass them if they want to lol
@voodoochile80
@voodoochile80 2 жыл бұрын
Agree. It also makes me think that here we're learning how to pass a system design interview, whereas one should really be studying "how to design systems". It might sound like a subtle difference but it is quite a sad realisation if you think about it
@godwinyoh3700
@godwinyoh3700 2 жыл бұрын
some have a passion for teaching. Imagine all your coding mentors focused on writing code instead of writing books and going for talks.
@sonicjetson6253
@sonicjetson6253 2 жыл бұрын
Yea too many fucking ppl entering this industry. Its getting nauseating.
@Alikhan1993
@Alikhan1993 3 жыл бұрын
Nice effort but You totally missed some important functionality like how videos will be streamed to user? Also how you will meet low latency high throughput etc.. Considering estimates you didn't used them to calculate your size of database and how you will optimise DB OPS (using indexes etc)
@radszymula4625
@radszymula4625 17 күн бұрын
HLS streaming for Videos?
@henryzhang5793
@henryzhang5793 3 жыл бұрын
Nice video. One thing I think ‘likes’ should not be one column of video table. Its access pattern is different from other columns, like video description, blob link. ‘likes’ could be changed very frequently. I feel it should be a separate service and may be like a even driven thing (e.g. a msg queue followed by nosql db)
@mickeyp1291
@mickeyp1291 2 жыл бұрын
likes should be in a graphdb which bis faster. they should also appear in nosql document
@thenextguy4570
@thenextguy4570 Жыл бұрын
also, isn't all likes needs to be stored with userid. Because we are certainly allowed to unlike a video. So, if they don't store like count. and which user likes the video there are no option for unlike.
@radszymula4625
@radszymula4625 17 күн бұрын
@@thenextguy4570 you are right, what is this guy talking about
@radszymula4625
@radszymula4625 17 күн бұрын
need to store info on which user liked it so they can unlike, and so you can create custom feeds based on videos that a User likes
@__nitinkumar__
@__nitinkumar__ 3 жыл бұрын
In my experience in India, usually interviewers aren't that patient. I remembered asking do you want me to explain as I go. The guy said "no no, you implement take your time we will discuss it later" 😀
@marcosabreu4684
@marcosabreu4684 3 жыл бұрын
That should tell you something about the company. :(
@praneethkumar7884
@praneethkumar7884 Жыл бұрын
@@marcosabreu4684 That tells a lot about your mom
@tryexponent
@tryexponent 3 жыл бұрын
👋 Have a question or suggestion? Let us know in the comments here! And don't forget to check out the full course System Design Interview course here: bit.ly/2XduSkJ
@smp1843
@smp1843 3 жыл бұрын
I agreed on the choice of RDB for read/write to start, but was a bit confused by his assuming the possibility to shard on an RDB rather than switching over to a NoSQL so it's known to be sharding friendly?
@edwindh2007
@edwindh2007 2 жыл бұрын
Choose a SQL database has a big problem with big data and doesn't scale cheaply, it could cost a lot of money. A better solution is to use a NoSQL database that is designed for big data, scales and needs low investment in comparison with SQL database products. It's a good subject for an open discussion and to learn more. Anyway the System Design Mock Interview was great!
@occo5877
@occo5877 3 жыл бұрын
I feel the answers were a bit weak overall.a few times actually I felt the answer wasn’t given at all to the question, rather avoided
@jashnakapadia252
@jashnakapadia252 3 жыл бұрын
that's what i do in my interviews.
@sivakiranchekka8762
@sivakiranchekka8762 2 жыл бұрын
I really liked how he carried the conversation....interactive
@official_roboGOD
@official_roboGOD 2 жыл бұрын
The guy on the left is perfect Clark Kent. Take the specs off and we have Superman!
@bostonlights2749
@bostonlights2749 3 жыл бұрын
This is a good and bad interview. Experiences : 2-4 Years --> Good. As he was able to build the structure around the problem. Experience : 4 Years + --> Bad . Did not go into any details. Just generic statements. PS: I wanted the interviewer to ask more questions and make him struggle.
@maroonluph
@maroonluph 3 жыл бұрын
collection of experiences
@sedat4842
@sedat4842 3 жыл бұрын
I once asked to design a video platform like Netflix. They were going so into detail at everything I said. I believe I did better than this video with similar components like cache, CDN, pre population for the feed etc. Talked about NoSQL, scaling, security, etc... but guess what, I failed :D experience was 5 years
@dijoxx
@dijoxx 3 жыл бұрын
The interviewer himself is not very good to be honest. I've seen some of his other videos and he appears to be a rather mediocre engineer.
@cakec9
@cakec9 3 жыл бұрын
@@sedat4842 Very interesting. Did you fail becoz of the system design interview? Or were there other rounds that led to the consequence?
@ArunKumar-jk5pq
@ArunKumar-jk5pq 3 жыл бұрын
CDN should sit in front of static content only. Not sure you need to put that it in front of all APIs.
@HardwareAddiction
@HardwareAddiction 3 жыл бұрын
Yea, it didn't make sense to me at all. You have databases, how can you access a DB across CDNs? lol, it only makes sense for static stuff, as you said. In the case of Tiktok, that would be grabbing videos blobs/files.
@chchristomanos
@chchristomanos 3 жыл бұрын
@@HardwareAddiction If he used a document-based database he could store the responses as JSON on the CDN
@guhkunpatata3150
@guhkunpatata3150 3 жыл бұрын
imagine how many years it needed to understand and practice all those techs. i can catch up to DB design, but beyond that; CDN, LB, caching ... im lost XD (never done that before) so yeah, this is very aspiring interview.
@BassByTheBay
@BassByTheBay 3 жыл бұрын
They all work together to improve performance and hence UX, so you'll probably come across all of them soon enough. And you don't need to dive deep to understand what they do and how they're beneficial.
@smkhan007
@smkhan007 Ай бұрын
I wish everyone gets such a decent interviewer
@deathbombs
@deathbombs 3 жыл бұрын
His high level design is his highlight, clearly done some practice on designing KZbin. He broke up the DB and precache smooth AF Also like how he backfill the db model at 24:10
@nar51
@nar51 Ай бұрын
Congratulations 👏😊 Brilliant interview Started and stayed humble throughout
@traviss7740
@traviss7740 2 жыл бұрын
The ASMR in the background was a really nice touch... although the tingling were overwhelming from time to time. Jokes aside, very helpful video though. Thanks for this.
@mickeyp1291
@mickeyp1291 2 жыл бұрын
i feel youve developed a great system in 2005 architecture. i expected choreography with events, kafka and streaming . very disappointed in this design that would not scale well, requires huge joins and is very inneficient in eventual consistentancy
@michaelzappa
@michaelzappa Жыл бұрын
I like how he drove the direction of the interview
@yanciliang7735
@yanciliang7735 22 күн бұрын
Thanks for sharing video! I was impressed by a concept he mentioned while organizing the requirements ---- how budget affects the reliability of a service? This wasn't something I had heard in previous system design interviews or discussions. Although I'm not sure how this would play out in an actual interview, I personally find it very practical. It made me immediately consider how much cloud storage or other resources I might need to calculate. On the other hand, I definetly read through the comparisons and debate on sql vs nosql above. It helped me a lot.
@arnabpersonal6729
@arnabpersonal6729 3 жыл бұрын
29:45 shows how huge scaling exponentially increases components complexity. Nice video
@bridgethuang581
@bridgethuang581 3 жыл бұрын
Great instruction! - a side question: what's the tool you use to draw your flow chart? Thx!
@tryexponent
@tryexponent 3 жыл бұрын
He's using Whimsical!
@SafetyLast-_-
@SafetyLast-_- 2 жыл бұрын
@@tryexponent Thanks!
@Nkdeveloper
@Nkdeveloper 2 жыл бұрын
@@tryexponent Was gonna ask the same thing, thanks
@cfbredraider
@cfbredraider 2 жыл бұрын
Interviewee needed to talk a bit more about fault tolerance. You might introduce a queue to handle processing the videos after they are uploaded.
@kimngochoangkhoi3631
@kimngochoangkhoi3631 Жыл бұрын
This is what true artistry looks like, just amazing
@fattailinvestor3660
@fattailinvestor3660 2 жыл бұрын
For the DB discussion around minute 21:00, would it make sense to have a scheduled ML job that reads from the RDB or the replicated read only version and creates the user curated list, and then drop the results into a NoSQL db (like Apache Cassandra, with primary key of user Id plus clustering on say uri of video). This would scale horizontally very easily and it’s purpose built for quick reads and supports the non functional requirement of high availability.
@iminsane7777
@iminsane7777 3 жыл бұрын
More than Exponent you have been promoting Whimsical! :D
@MohitGupta-ln2js
@MohitGupta-ln2js 3 жыл бұрын
Finally, someone spoke about it.
@cberigan1
@cberigan1 3 жыл бұрын
Likes requires a many to many table users videos. Follows can be a many to many users users.
@avikchowdhury6933
@avikchowdhury6933 2 жыл бұрын
Great video, nicely explained everything. However about database sharding; I think sharding should not be done based on region, right? Because for a particular region with lots of users database sharding could be done based on user_id. Moreover, we also need to keep in mind about popular users. If too many popular users are in one DB, this will create too much load on a single database. So there should be some strategies to evenly distribute the ids of those users among the available servers.
@aniketshukla9568
@aniketshukla9568 2 жыл бұрын
Yes, I agree that database sharding should not be based on region. Coming on your suggestion, when we do database sharding based on user_id, this might create huge traffic for a celebrity user. So, what if we do sharding based on video_id(post_id) ? In this way, yes one shard will have multiple instances but we can get away with traffic on a particular shard.
@chrise202
@chrise202 2 жыл бұрын
1. Hot, Warm, Cold videos. The hotter, the more copies. 2. "Viral Regional video" is probably more realistic than "Global Viral". Hence bring data closer to the consumers. 3. Data is not relational, as videos are not tied together - NoSQL? 4. Data does not change much, but there are lots of reads - Immutability? 5. 4k Videos are heavy - CPU/GPU optimized service compression? 6. Composable UI - so that features like comments, likes etc work independently and in case of partial failure, system continues to offer a best-effort set of features. 7. Likes feature - mention about Top K problem and hashmaps 8. Client side caching - once video is already watched allocate a reasonable buffer for storing them. 9. Protocol focused on delivering video/audio content ? At least these are immediate things I could think of...
@prashantsalgaocar
@prashantsalgaocar 4 ай бұрын
For the question about scaling during the question of Sharding, there was a mention of a sharding service. so are we talking about algorithmic sharding or dynamic sharding? Seems like an external module to do the sharding. I believe tik Tok would do algorithmic sharding based on region. I would shard on user_id (horizontal) as recommendation feed was a part of the design. This would make querying much faster than have based on region. Also the API gateway was missed and may be we need to talk about rate limiting as well as such systems open to public could be possible DDos vulnerable. Also security/monitoring/logging not much focus on those aspects..
@the_sweet_heaven
@the_sweet_heaven 3 жыл бұрын
Interviewer asked very realistic questions. There could be more descriptive explanations though. Adam do have clear understanding of each component but could have been much more informative if he could have shared from his experience more in depth explanations of each component.
@Personwithopinion
@Personwithopinion 5 ай бұрын
this gives me hope cuz he says things in the most obvious way "It can run on a schedule... or like on demand, or something like that" Google here I come
@manosec
@manosec 2 ай бұрын
Really Nice Interview, Thanks Adam
@kartikkesarwani1320
@kartikkesarwani1320 3 жыл бұрын
be very careful before writing down non functional requirements. high availability is almost always enough but, if you wanna say 99.999% which is dream come true scenario, then don't really address the requirement it's a negative imo.
@TrueMetalGaming
@TrueMetalGaming 3 жыл бұрын
S3 being 99.99% availability, that could play against him to not achieve the 99.999%
@sergeymanetskiy8201
@sergeymanetskiy8201 2 жыл бұрын
What about counting read:write ratio? counting RPS for reads and writes? (to understand what kind of system in should be) Initial DB storage and storage scaling calculations? How much data you will store in a month? Throughputs? Why cache and not NoSQL in case of GET user feed? What to do with stale cache data? What if you lose all cache data?
@sohaibkhan114
@sohaibkhan114 2 жыл бұрын
If a person is following another person and eac reside in separate shards, how you're gonna tackle that ? I think if you give this solution in an actual google interview, you will be rejected. It lacks a lot of details. The pre-cache service will only populate initial feed objects, what about later ones ? There's no mention of that.
@shrimpo6416
@shrimpo6416 2 жыл бұрын
I just looooove watching mock interview videos
@rafaeashraf605
@rafaeashraf605 2 жыл бұрын
yea wait until you gotta do em. they aint fun
@shrimpo6416
@shrimpo6416 2 жыл бұрын
@@rafaeashraf605 I'm still very new to it XD
@pratikrudra6508
@pratikrudra6508 3 жыл бұрын
Respect when he mentioned he never used tiktok
@valerieehimhen2672
@valerieehimhen2672 2 жыл бұрын
Great video! Would an interviewer expect a TPM to be this detailed? I'd love to hear some feedback.
@swahareddy8822
@swahareddy8822 2 жыл бұрын
And would this interview be a fair expectation for post MBA TPM interviews. Or would they be less technical
@denise9720
@denise9720 2 жыл бұрын
More of a software developer interview.
@0DWalker0
@0DWalker0 2 жыл бұрын
Yes for Senior TPM or software engineering TPM
@gnut1010
@gnut1010 3 жыл бұрын
Hello, I'm an iOS Engineer and I'm very curious about the mobile app partial but you skipped it in the video. Could you please make videos about system design interview for mobile area ?
@prasenjitghoshpg
@prasenjitghoshpg 3 жыл бұрын
“It’s always interesting trying to design something that you’ve never used”…that’s pretty much the purpose of System Design! 🙄
@KF_YK
@KF_YK 3 жыл бұрын
I really benefited from this video! thanks guys for your time and effort
@Gp-om3vt
@Gp-om3vt 2 жыл бұрын
Good video. The audio quality needs improvement. Crackling noises are heard throughout the video, making it difficult to focus on the content.
@lbb2rfarangkiinok
@lbb2rfarangkiinok 2 жыл бұрын
Watched this video in three settings. By the third time, my 2 year old daughter would hear the interviewer's voice and immediately start imitating the milkshake sounds. "Dad, why does what you are watching go swshh swshhh swshhh"
@JL-qf3hq
@JL-qf3hq Жыл бұрын
Is this a reasonable expectation for a TPM interview or did he just do exceptionally well?
@hellopuneet
@hellopuneet 3 жыл бұрын
This problem should have more focus on big data. All database design is based on RDBMS relationship. Having something like Cassandra and memcache / Redis as solution would have been better. Suggested approach of running the algo before user logs for faster response, is tricky. Considering you have 1M users and you don't know who will login when pre curating list for all 1M user is kind of useless. That should be build from memcache directly with out hitting DB. and once user is active, we can refresh the cache for user's followers.
@ImaskarDono
@ImaskarDono 3 жыл бұрын
I think you pretty much can keep 5 next videos for every user. Not goes along well with trendy videos, so yeah, a debatable choice.
@mrunaldave6781
@mrunaldave6781 3 жыл бұрын
Great video but the microphone disturbance makes it unbearable to watch it!
@adithyaks8584
@adithyaks8584 3 жыл бұрын
One question - after we have consumed the precomputed feed how do you recompute, is it based on timestamp / relevance etc and how will it get served ? Whether this new feed will be stored in cache and how ordering will be maintained ? Whether we will have to persist this ?
@alexgrissom7251
@alexgrissom7251 Жыл бұрын
I actually came very close to this design while I was designing TikTok on my own. I'm very proud of myself:) Thanks for the video!
@m1nkeh
@m1nkeh 2 жыл бұрын
i would have saved chat about redis cache for the "further optimisation" sections... gotta leave something in your pocket!
@richarddetsch7912
@richarddetsch7912 3 жыл бұрын
like the cdn for the video may want to also go into the audio/video encoding of video before storage or if live streaming how to encode and deliver content before a full store, they talked about scale but may also want to discuss adapting to a change in network bandwidth
@AmeerHamza-cy6km
@AmeerHamza-cy6km 3 жыл бұрын
Always start with ERD 🙂
@hakanaki
@hakanaki 2 жыл бұрын
Love you contents, I've learnt alot in just few minutes, my head wants to explode 🤣🤣.
@actondon6573
@actondon6573 2 жыл бұрын
I would expect interviewer to be more actively challenging and ask for deep diving into areas of interest.
@vikram5970
@vikram5970 2 жыл бұрын
What was the online designing tool you used for the design? that was pretty cool
@devegram
@devegram Жыл бұрын
He's using Whimsical
@tobiahrex
@tobiahrex 2 жыл бұрын
The scratchy background noise due to headphones is SO annoying. otherwise, pretty good, and helpful. thanks.
@adeeliqbal833
@adeeliqbal833 2 жыл бұрын
Great system design but there is a lot of background noise.
@smp1843
@smp1843 3 жыл бұрын
I agreed on the choice of RDB for read/write to start, but was a bit confused by his assuming the possibility to shard on an RDB rather than switching over to a NoSQL since NoSQL are known to be sharding friendly?
@tchangity
@tchangity 3 жыл бұрын
Depends on the skill set of the team. Some NoSQL databases can be harder to shard than some relationship databases now (such as postgres with built in partitioning)
@pingoklooi
@pingoklooi 2 жыл бұрын
What are some good resources one can peruse to further understanding of this field/study please?
@apidas
@apidas 3 жыл бұрын
this is great. it'd be great with more video like these
@zios21
@zios21 2 жыл бұрын
I wonder if anyone ever starts with the domain model of the problem at hand? I felt we jumped into tables and stuff pretty quickly. PS - I am preparing for such interviews and looking for recommendations.
@SwapperTheFirst
@SwapperTheFirst Жыл бұрын
depends on your previous experience/background. Some start with APIs, some start with data models first (tables and relations is just one example of data modeling). Typical framework to start is - Functional, Non-Functional, Constraints. Then discuss major actors, their use cases and typical user stories. Unfortunately, the exact answer to many software architecture questions is always - it depends on many factors (your background, type of interview, time constraints, role you're interviewing for, ...)
@hakanaki
@hakanaki 2 жыл бұрын
Sorry, quick question. What are you guys using to draw this diagram?
@illyaxo
@illyaxo Жыл бұрын
This guy is built different
@nikolayfx
@nikolayfx 2 жыл бұрын
Congrats, thanks for sharing the interview
@tryexponent
@tryexponent 2 жыл бұрын
Our pleasure!
@enamulhaqueshamim4439
@enamulhaqueshamim4439 Жыл бұрын
Nice one. What was the online tools showing this video for designing. Thanks in advance.
@tryexponent
@tryexponent Жыл бұрын
The tool is Whimsical!
@RealShanShan
@RealShanShan 3 жыл бұрын
This didn't feel like an interview, but rather just some quick-and-dirty drafting. You should have questions and considerations prepared for potential design proposals to help give a bit of depth and better pick the brain of the "interviewee". For instance: "Wouldn't running jobs to pre-load per-user caches of queries poorly scale with user count?", and listen to how this might or not be a problem, and if so, how would we proceed in order to reduce potential bottlenecks. Just my 2 cents :-)
@omerocak4710
@omerocak4710 3 жыл бұрын
it is a typical TPM interview and believe me, he did great for a TPM
@RealShanShan
@RealShanShan 3 жыл бұрын
@@omerocak4710 I guess that’s possible, I just think that for educational purpose and for the sake of preparation going a little bit deeper into the details would have been great
@wojciechwodek4196
@wojciechwodek4196 2 жыл бұрын
I will use additional technologies - maybe even I see mistakes, where is autoscaling environment for microservices? Where is nosql database? No all trafic should go through CDN Where is authentification service? Monitoring? Real time analysics? etc..
@jay-rathod-01
@jay-rathod-01 3 жыл бұрын
Hello sir make the whole sys design course if possible.
@tryexponent
@tryexponent 3 жыл бұрын
We did! Check it out here: tryexponent.com/courses/system-design-interview
@abhirb12
@abhirb12 3 жыл бұрын
@@tryexponent : more video interviews would be great
@ihopethiscommentisntabusiv4670
@ihopethiscommentisntabusiv4670 3 жыл бұрын
Thanks for the video, but the constant mic rustling and cutting away from the workspace to show your face really made it hard to follow...
@kabooby0
@kabooby0 3 жыл бұрын
How reasonable is it for someone with no system design experience (but platform software design experience) to do reasonably well in a question like this? Is it necessary to have experience to interview well for roles that will require system design, or is it sufficient to have at least studied it?
@StevenDoesStuff
@StevenDoesStuff 3 жыл бұрын
Curious as well
@instantshinramen
@instantshinramen 3 жыл бұрын
Studying will help you get the structure of the system design interview down. But ultimately experience is the best way to develop intuition for how to approach the functional (ie. product) and non-functional requirements for any given problem. That’s why system design interviews are how companies identify senior/staff SWE from junior SWE. Don’t let that stop you though from studying, practicing and going for interviews.
@idvishal
@idvishal 3 жыл бұрын
@Exponent What editor your interviewee's use to draw the system diagrams?
@taylorbarthel3513
@taylorbarthel3513 2 жыл бұрын
Whimsical
@gsdfgsdfgsdfg4188
@gsdfgsdfgsdfg4188 Жыл бұрын
What editor is being used in this demo? Thank you for this session! Very helpful.
@tryexponent
@tryexponent Жыл бұрын
Hi gsdfgsdfgsdfg! I'm assuming that by editor you mean the whiteboard tool used?If so, the whiteboard being used here is “Whimsical”. They have a free and paid version so do check them out if you are interested! Thanks for watching and for the kind words!
@chrisstephens6957
@chrisstephens6957 Жыл бұрын
What platform was used for the whiteboarding during this session?
@tryexponent
@tryexponent Жыл бұрын
Hi Chris! The whiteboard being used here is “Whimsical”. They have a free and paid version so do check them out if you are interested!
@mingxinlu3473
@mingxinlu3473 3 жыл бұрын
I totally couldn't understand why using UserId as the PK for the actual "Video table". First, it out of intuitive, userId should not be the PK for the video considering that user to video is 1 : N. Another reason is, if we did sharding by UserId, the system will be out of balance....
@maynardewm
@maynardewm 2 жыл бұрын
Yeah I think that was not meant to be called the PK obviously that wouldn’t make any sense here. But you do need to store the user id on that table.
@HakunaMatata225
@HakunaMatata225 Жыл бұрын
It would be nice if he explained how he would populate the read only DB
@nathanfife2394
@nathanfife2394 Жыл бұрын
That's a feature you can get from AWS for "free" so that's probably why
@frefai
@frefai 2 ай бұрын
I found this helpful, however a piece of feedback: Moving back and forth between the people and whiteboard constantly was distracting. Most folks watching this are interested in the design, so I suggest keeping the whiteboard up the entire time and keeping the interviewer and candidate small windows
@tryexponent
@tryexponent 2 ай бұрын
Hey frefai, thanks for your feedback! We'll consider it for our future videos 🙏
@KingKingSofa
@KingKingSofa Жыл бұрын
I feel like an interviewee can get away with simply stating that the system will be highly available and nodes going down will not cause undue service outages. The reason for that is if I state 5 9's of availability and my interviewer asks why not 6 9's then I have to justify that and strictly speaking how much does your design change if at all? Maybe for a solutions architect or a staff role i'd be a little more OK with dropping solid numbers like that but i'd then grill the person on what changes and how it would be different at different levels of 9s.
@mehulsolanki9435
@mehulsolanki9435 2 жыл бұрын
Thanks for these videos. They are really helpful. 😄
@17teacmrocks
@17teacmrocks 3 жыл бұрын
when sharding became a thing, i was like this is just raid for server data
@abcauditor123
@abcauditor123 2 жыл бұрын
26:11 "basically all of these APIs are going to want to behind a CDN"? Are you saying that you are replicating the LB, microservices, and Databases for each CDN you have, in every region? I was under the understanding that CDNs were used to cache large content (videos, pictures), not to completely replicate your primary environment and that the CDN would get content from the 'blob' storage and the read-only DBs. Any clarification would be appreciated. Thanks!
@TheNoorzain
@TheNoorzain 3 ай бұрын
this guy designs systems!
@mgdibtygd
@mgdibtygd 2 жыл бұрын
I'm curious about what Adam S. is using to illustrate his design? Is it just Powerpoint (or equivalent) or something else?
@doanthanh7025
@doanthanh7025 2 жыл бұрын
Thank you for great example of system design question.
System Design Mock Interview: Design Instagram
31:12
Exponent
Рет қаралды 504 М.
They Chose Kindness Over Abuse in Their Team #shorts
00:20
I migliori trucchetti di Fabiosa
Рет қаралды 11 МЛН
Smart Sigma Kid #funny #sigma
00:14
CRAZY GREAPA
Рет қаралды 106 МЛН
Will A Basketball Boat Hold My Weight?
00:30
MrBeast
Рет қаралды 152 МЛН
Amazon System Design Interview: Design Parking Garage
29:59
Exponent
Рет қаралды 1,4 МЛН
Google system design interview: Design TikTok (with ex-Google EM)
1:09:18
IGotAnOffer: Engineering
Рет қаралды 193 М.
System Design Interview: Design Amazon Prime Video
26:53
Exponent
Рет қаралды 105 М.
System Design Interview: Design Netflix
27:50
Exponent
Рет қаралды 261 М.
System Design (TPM) Mock Interview: Twitter API
19:00
Exponent
Рет қаралды 124 М.
System Design Interview: Design Dropbox or Google Drive w/ a Ex-Meta Staff Engineer
58:08
Hello Interview - SWE Interview Preparation
Рет қаралды 67 М.
Google system design interview: Design Spotify (with ex-Google EM)
42:13
IGotAnOffer: Engineering
Рет қаралды 1,1 МЛН
System Design Interview: TikTok architecture with @sudocode
45:35
System Design Interview: Design Ticketmaster w/ a Ex-Meta Staff Engineer
58:39
Hello Interview - SWE Interview Preparation
Рет қаралды 129 М.