Database problems of maritime transport industry on high load platform

摘要

The article says about distributed and high load systems, common problems and common instructions for solving such problems as denormalization, replication and sharding of transport and maritime aspects. The analysis of strengths and weaknesses of technology for the transport field of activity was carried out. A fragment of the code for sampling optimization is given. Conclusions about the global use of industry technology are made. When your current infrastructure starts to show the first signs that it is no longer cope with the load and if you have a 128 MB VPS - for you, it can be 10 requests per second. For corporations, it can be 10,000 requests. There is a need for scaling and optimizing the infrastructure. Maritime office needs a good monitoring system. It will help determine the very moment when it's time to scale. Stable systems for monitoring and tracking server performance trends: Munin, Zabbix, Nagios. What usually happens when the high load point is approached: slow or infinite loading of pages; random errors; broken connections from the Web server; partial loading of content (for example, there is no part of the image), and a decrease in audience activity. This direction is very modern and promising for the transport industry.