Scaling Databases - Web Development

[@amansaini-oq8td]

Handful knowledge in just 6 minutes, Great explanation.

[@user1200006354654]

Too much quality content in 7 minutes, thanks pal.

[@SergiuMunteanu]

One of the best videos I could find about this topic

[@undercrackers56]

The Managing Director's answer to that question is: Any option that does not cost money and could be completed before lunch.

[@govindrai93]

Great video on high level overviews of scaling your db through replication vs sharding or using a combination. Short, helpful, and easy to understand. Thanks!

[@troooooper100]

udacity is deleting this course, because it's "old"

[@MrJorgeceja123]

I wasn't able to find the course on their site. Do you know where it is now? Thanks!

[@MrJorgeceja123]

Oh, ok. I found most of them but what I'm struggling now is how to piece the puzzle. I have them but i don't know in which order most of them are lol If you got any info on how they are ordered, I'll appreciate if you sahre it.

[@wastabirrajvee8867]

ThunderousGlare Could you please provide the link of the playlist? Thanks

[@NeilTejada-c5g]

🎯 Key Takeaways for quick navigation: 00:00 ** 02:46 ** 04:09 ** 05:34 ** Made with HARPA AI

[@jackgunn1480]

Thanks! It's like having a teacher in my living room with me.

[@c.4469]

The answers I thought * (O) get a faster machine -> Vertical scaling. We can improve the read "speed" by buying a bigger machine. * (X) replicate the database -> Horizontal scaling. However, we cannot improve the "speed" because the computing power has not changed. It can only perform more reads at the same time. * (?) store less data -> It also improves the read speed, but is it allowed to store less data? * (O) press the turbo button -> If the turbo means the turboboost of the intel chip processor, this can be an answer too.

[@abinashpanda393]

4. Press the turbo button 🔥

[@abrarisme]

Definitely press the turbo button. That's the only correct answer here.

[@Max-tj4nt]

Press the turbo button

[@ukaszsmigielski8648]

Where can I get this button sir?

[@typicallucas4164]

check 6:45 of the video for more info

[@maktaf]

what is a turbo button?

[@floopy312]

@@ukaszsmigielski8648 You have to upgrade your plan and pay $50 more for the turbo button sir.

[@IC-kf4mz]

Donate to get the answer.

[@pas0003]

What a fantastic video!

[@sonoftroy8572]

But isn’t this something the hosting company will take care of for you... when it come to dealing with database servers? I’m looking for actual code examples with best practice structure. Using programs like PHP & MySQL to store and pull data from multiple tables in a database. Using either a class based structure or a OOP structure witch is very similar to class based structure or a procedural based structure witch uses function as. It’s structure. This type of high level database scalable code example is what I’m looking for... do you have anything like this?

[@MrKokomaniaco]

Nope, unless the hosting company provides Managed Cloud Database service

[@justinkim7202]

You always press the turbo button

[@loke9271]

awesome content!!

[@umermib3058]

Mind blowing bro

[@deepusasidharan2012]

super video

[@pankajsinghv]

Excellent post on db scaling

[@AndreiIR000]

286, 386 and some 486 users will push the TURBO BUTTON!!!

[@princesspranaya7123]

In theory this is all good? Pretty basic. would be good to cover how this is all works? what are links mean here? and how that happens. A DB can end with up 50 -100 tables at min. From web app when i fire a crud operation where the distinction happens which server it should go (slave vs master). Similarly when you have shards, how does that translate. On table y i am querying a select query with where clause or group by? In this how this link is determined. Who does that job?

[@KrishnaDasPC]

Any code examples?

[@thuctranvan4630]

Great video, It's very useful !

[@alptekintalan3125]

D ) press the turbo button

[@idiot7leon]

Thanks

[@mrmuranga]

nicely explained

[@Vladerrama21]

press the TURBO!!!!

[@ru2979]

is this called db sharding ?

[@wpelfeta]

how do you structure data so that you don't need joins?

[@guitarockdude]

One way to do this with relational databases might be to store data independently on different systems. For example you could do a lookup for "users" and then you could use that data to look for "telephones" in a separately stored table/db. The disadvantage being that you might need to do many queries for large results. A better solution might be to use NoSQL or Hadoop databases for your data. These systems scale much better for this reason.

[@alehunter15]

excellent vid cheers

[@RomanticPopPunk]

I think Store less data. The less you have, the less time you need to looking up for something.

[@mosirag85]

hi every one which framework that can use in large scale of developing web systems and which database can use in this web development tips for infrastructure please thanks

[@ik7122012]

Golang fiber + postgresql

[@ALZlper]

Turbo!

[@TheAmeer3881]

Lol

[@IbrahimRasheedDhanbidhoo]

Press the turbo button XD lol

[@xtremegamings]

replicate