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.
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?
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.
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
The Managing Director's answer to that question is: Any option that does not cost money and could be completed before lunch.
Handful knowledge in just 6 minutes, Great explanation.
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
Definitely press the turbo button. That's the only correct answer here.
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
🎯 Key Takeaways for quick navigation:
00:00 **
02:46 **
04:09 **
05:34 **
Made with HARPA AI
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?
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.
You always press the turbo button
One of the best videos I could find about this topic
Too much quality content in 7 minutes, thanks pal.
286, 386 and some 486 users will push the TURBO BUTTON!!!
4. Press the turbo button 🔥
super video
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.
Any code examples?
Thanks! It's like having a teacher in my living room with me.
replicate
Press the turbo button XD lol
I think Store less data. The less you have, the less time you need to looking up for something.
is this called db sharding ?
D ) press the turbo button
What a fantastic video!
Turbo!
Lol
press the TURBO!!!!
awesome content!!
Mind blowing bro
Great video, It's very useful !
Excellent post on db scaling
Thanks
nicely explained
excellent vid cheers
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.
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