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!
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.
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.
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?
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?
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.
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
Too much quality content in 7 minutes, thanks pal.
Handful knowledge in just 6 minutes, Great explanation.
One of the best videos I could find about this topic
🎯 Key Takeaways for quick navigation:
00:00 **
02:46 **
04:09 **
05:34 **
Made with HARPA AI
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!
udacity is deleting this course, because it's "old"
I wasn't able to find the course on their site. Do you know where it is now? Thanks!
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.
ThunderousGlare Could you please provide the link of the playlist? Thanks
Thanks! It's like having a teacher in my living room with me.
The Managing Director's answer to that question is: Any option that does not cost money and could be completed before lunch.
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.
4. Press the turbo button 🔥
Definitely press the turbo button. That's the only correct answer here.
What a fantastic video!
Excellent post on db scaling
Press the turbo button
Where can I get this button sir?
check 6:45 of the video for more info
what is a turbo button?
@@ukaszsmigielski8648 You have to upgrade your plan and pay $50 more for the turbo button sir.
Donate to get the answer.
awesome content!!
Great video, It's very useful !
Mind blowing bro
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?
Nope, unless the hosting company provides Managed Cloud Database service
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?
Thanks
super video
is this called db sharding ?
You always press the turbo button
nicely explained
Any code examples?
286, 386 and some 486 users will push the TURBO BUTTON!!!
D ) press the turbo button
excellent vid cheers
press the TURBO!!!!
how do you structure data so that you don't need joins?
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.
Turbo!
Lol
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
Golang fiber + postgresql
I think Store less data. The less you have, the less time you need to looking up for something.
Press the turbo button XD lol
replicate