Where and how can you get experience working with high-load projects?

Question

Programming

Hello. The question is in the title. I understand that there is a lot of general theory: database structure optimization, query optimization, caching, etc., but it seems to me that this knowledge is clearly not enough to claim that "I have the knowledge and experience necessary for optimization."
I would be grateful for links that describe in detail the PRACTICAL experience of optimization, with specific problems, actions and results. Ideally, the blog of a person who engages in such activities on a daily basis.

Answer 1

You can talk about highload for a long time, you can’t get practical experience in theory, you have to do just that to get it. encountered a difficult moment? - think about how to solve it without limiting yourself, because everything is possible in programming. about popular solutions everywhere and so they write, nosql, sharding, task / message queues, asynchronous operations, etc. are also on the hub, why go far.
and sometimes I read:
phphighload
highload

Answer 2

You understand that everything is individual. Those. database optimization, caching, etc., this is common. Everything else depends on the project, for example, Facebook has some problems, twitter has other problems. And their decisions do not apply to each other.

Answer 3

I have the knowledge and experience necessary to optimize
"reading blogs" is not experience. Only the solution of combat missions will help. Nothing else. Servers usually lay down codebases of 1k lines. So there is only work in some Yandex or badoo. Usually a server crash looks like this: the server crashed logs in the attachment. Everything. What's next? What blog are you looking for? Which section of stackoverflow are you going to? Go to some data center or social network. In 3-5 years, learn to optimize something.

Answer 4

my.mail.ru/corp/morozova/video/16
YaC recordings
www.highload.ru (for money, May 23 broadcast + recordings).
In general, few people tell anything in Russian on this topic, especially for free. Many books have been written in English, but most of them are nonsense. You can read ru-highload.livejournal.com to understand what to google.
There are many books in English, but most of them are heresy, it is difficult to filter without experience. In general, highload today is more about "quickly write us a horizontally scalable application! And we will put it on 50 servers and let it work. If it's not enough, we'll add more hardware." So cheaper.