Optimization of relational databases without downtime on the example of the most loaded database in Badoo

 
3r3-31. Optimization of relational databases without downtime on the example of the most loaded database in Badoo 3r33333.  
3r33333.  
Under highload conditions, the complexity of optimizing relational databases increases by an order of magnitude, since buying even more powerful hardware is expensive and it is no longer possible just to turn off the application at night for a long DB alter process and data migration. 3r33333.  
3r33333.  
We recently told how we are optimized the PHP code of our application . Now came the turn of the article about how we completely changed the internal structure of the most loaded and important database in Badoo, without losing a single query. 3r33333.  
...
+ 0 -

The history of a single query

3r33434. The history of a single query
 3r33450. Submit your first day at the new job. The office is located in the area completely unknown to you Kurskaya metro station. Dinner time is coming. You open the search application, write “Eat at the Kursk” 3-3r3420. and get a selection of options where you can dine.
 3r33450.
 3r33450. What is behind the request “Eat at the Kursk” 3-3r3420. and how is it processed to find exactly what you need? In the article I will tell you how the 2GIS Search team is doing everything possible to make life in cities more convenient and comfortable for users.
 3r33450.
3r33338.
 3r33450. It is important ...
+ 0 -

Comfortable working with Android Studio

3r3952. Comfortable working with Android Studio 3r33939.  
Good day to all! 3r3953. 3r33939.  
3r3952. How productive is Android Studio? Do you think it works fast on your PC or Mac? Or, sometimes, encounter lags or a long build? And on large projects? 3r3953. 3r33939.  
3r3952. In any case, we all want to get maximum performance from hardware and software. Therefore, I have prepared a list of points and tips for beginners and experienced developers who will help you to work comfortably with large projects or simply to increase productivity. You will also understand whether your equipment needs an upgrade. 3r3953. 3r33939.  
3r3952. Users of ...
+ 0 -

Theory of Sharding

Theory of Sharding 3r31423. 3r3-31. It seems that we have plunged so deeply into the jungle of highload development that we simply do not think about basic problems. Take sharding, for example. What to understand in it, if you can write conditionally shards = n in the database settings, and everything will be done by itself. So, he is like that, but if, rather, when something goes wrong, the resources really start to be missed, I would like to understand what the reason is and how to fix it.
 3r31423.
 3r31423. In short, if you contribute your alternative implementation of hashing in Cassandra, then there are hardly ...
+ 0 -

The IT giant wants to prove quantum superiority next year - which could go wrong

+ 0 -

Highload ++: How to help the ERP system deal with 50?000 requests per second

We at X5 process a lot of data in the ERP system. There is an opinion that no one processes more than us in SAP ERP and SAP BW in Russia. But there is one more thing - the number of operations and the load on this system is increasing rapidly. 3 years we "fought" for the performance of our ERP-heavyweight, filled a lot of cones, and what methods they were treated, we tell under the cut.
 
 
Highload ++: How to help the ERP system deal with 50?000 requests per second
 
3r311. 3r33333.
 

ERP X5


 
X5 now manages more than 1?000 stores. Most of the business processes of each of them passes through a single ERP-system. Each store can have from ?000 to 3?000 products, this creates ...[/h]
+ 0 -

A tenth-grader from Siberia wants to become a processor designer. Why shouldn't she make a FPGA neuro accelerator?

A tenth-grader from Siberia wants to become a processor designer. Why shouldn't she make a FPGA neuro accelerator?Yesterday I received a letter from a tenth-grader from Siberia, who wants to become a microprocessor developer. She has already received some results in this area - she added a multiplication instruction to the simplest schoolMIPS processor, synthesized it for the Intel FPGA MAX10 FPGA, determined the maximum frequency and increased performance of simple programs. She first did all this in the village of Burmistrovo, Novosibirsk Region, and then at a conference in Tomsk.
 
 
Now Dasha Krivoruchko (that is the name of the tenth grader) has moved to live in a Moscow boarding school and asks me what ...
+ 0 -

The friendship thanks to which Google has grown to enormous size

The friendship thanks to which Google has grown to enormous size 3r3184. By programming together with one computer, Jeff Dean and Sanjay Gemawat changed the company's course - and the entire Internet. In the illustration: the best Google programmers sometimes seem to be the two hemispheres of one brain. Figure by David Plckert [/i] 3r33434.  
3r33434.  
One day in March 200? six top Google engineers gathered in a makeshift conference room. There was a state of emergency: since October 199? the crawlers stopped. Although users are still given search results, but they are out of date for five months. More was at stake than engineers had imagined. At the moment, Larry Page and ...
+ 0 -

Storage Class Memory in the storage system - if you need even faster

 3r3174. 3r3-31. Storage Class Memory in the storage system - if you need even faster As you probably remember, HPE has long invested in the topic of new types of data warehousing (of course, The Machine ) And in optimizing access to the repositories (our membership in Gen-Z consortium ). 3r3143.  3r3174. 3r3143.  3r3174. The goal of this movement is to speed up the work of our customers' applications. And the movement is multilevel: while the completely new architecture of the computer systems The Machine (the so-called memory-centric architecture) is being forged, we understand that we need to accelerate now. Let's see it can be done today, and what will HPE have ...
+ 0 -

Cool the CPU in the data center - laser 3D printing will help

The University of Binghamton (New York) have developed a new technology for cooling processors, which will allow to abandon the thermal paste. Thermally conductive material is applied directly to the surface of the chip using 3D printing. According to experts, their solution can lower the operating temperature of processors in data centers by 10 ° C. 3r? 3175.  
3r? 3175.  
We will talk about technology and talk about other experimental methods of CPU cooling. 3r? 3175.  
3r? 3175.  
Cool the CPU in the data center - laser 3D printing will help 3r3191. 3r? 3175.  
3r3108. ...
+ 0 -