A solution designed to reconsider the client’s existing system and to improve data storage and processing.
Our client was a technology company that developed one of the top-rated online video ad ecosystems with more than 100 million unique users and over 4 billion ad views. Their product was oriented to both publishers and advertisers.
The client expected the company to grow at least 30%, so they wanted to prepare their system infrastructure for the increased load. The original RTB platform was designed to store user action data in MySQL databases, and it was not a suitable solution due to the technology limitations. As a result, it became the project bottleneck as the number of ad impressions and clicks continued to rise.
Geomotiv initiated in-depth problem analysis to discover that the same MySQL databases were used to store, read, and pass raw event data simultaneously. After that, we started the bottleneck search stage, which helped us to understand why precisely the existing solution failed. We compiled a list of other possible solutions, conducted load testing, and chose the most suitable option according to the client’s requirements. As our last step, we implemented the selected solution, repeated complete testing, and deployed it in production.
- Conduct deep analysis
- Reveal the bottleneck
- Test possible solutions
- Provide Quality Assurance
- Deploy in production
MySQL queries were executed within minutes in the original system. Our solution allowed the client to execute them in split seconds, thus preparing the system for the increased load.
Fill out the form below and we’ll get in touch within 24 hours