Databases Problems for Maritime Transport Industry on Platform Highload

摘要

The article says about distributed and highload systems, common problems and common instructions to solve in such as denormalization, replication and sharding for transport and maritime aspekts. 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 are made about the global use of industry technology. When your current infrastructure starts showing the first signs that it stops coping with the load and if you have a 128 MB VPS - for you it can be 10 requests per second. For corporations, this can be 10,000 requests. There is a need for scaling and optimizing the infrastructure. For maritime office need 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 highload point approaches: 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 images) and a decrease in audience activity. This direction is very modern for the transport industry and promising.