Systems design interview with a Google engineer: Distributed databases

Note: Drawing starts at 13:46 and is a reconstruction of what happened during the interview.

[Eggeater]

Maybe Consistent Hashing will simplify it, the interviewer very nicely coached him in the end with the solution. I really liked how the interviewer tried to help and guide the candidate. I will love to hire the interviewer.

[herbst]

I wish everybody will have that kind of interviewers! What a nice and professional person

[yrs]

The interviewee tried so hard to direct the guy to the right track, ....good guy :)

[learnersparadise]

I wish I ever get interviewed by such interviewer, as he is guiding and helping a lot. This interviewee is plain irritating, just giving plain vanilla answer despite so much hints

[arunsp]

For like 3 minutes I kept wondering if my video is working correctly lol

[amulyayeduguri]

I think he came up with genuine ideas short of consistent hashing. I would vote yes for him. He isn’t mumbling, but has accent, which is fine and interviewer got what he’s saying, so 🤷‍♀️

[polyethylene]

So, if this was an actual interview, what would you say about his chances? I would have thought consistent hashing etc. are pretty basic concepts.

[maximilian]

partition by userid(mapping to clearname by seperated table) and stoe all transaction of this user together, and all the users in a single giant table. Split the data(if too hot and big) based on size until range is only spans users data and transactions. maximum scale with minium work upfront.

[yehjames]

if this channel could also provide ML system design that would be perfect

[ismaelp]

The interview was about Horizontal Sharding

[pursuitofcat]

There is a 10000 ft distance between the knowledge of interviewer and interviewee.

[SaifulIslam-fsli]

If the interviewee said at the beginning that he is going to shard the db based on primary key, then how would the interview go from there ?

[Angelslo]

Interviewer is clearing telling him to talk about Sharding and consistent hashing. How clear and helpful he can be?

[mattiavandi]

Hi, could somebody tell me the name of the software used in the mock interview?
Thanks in advance

[learnersparadise]

The interviewee is just beating around bush with theory, while interviewer is giving many hints, for me it would be over in first 10 mins with such answers, you should take historical backup based on access pattern, analyse the accesses and keep pushing old data to appropriate store..and he is not talking about it

[shriduttkothari]

Very good conversation, this will really helpful to me as I am going to have interview soon

[rahuld]

This may not be right video for Goggle interview. Please don't waste time.

[cosmos]

The feedback given was not comprehensive. Also, I felt interviewer gave a sugar coated feedback.

[carlossegura]

My god... I can’t understand what in the f**k is he saying with all that mumbling.