RTB Platform Logging System Optimization

A solution designed to reconsider the client’s existing system and to improve data storage and processing.

About the Client

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.

Technologies Used

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.

Work Description

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.

Work Stages
  1. Conduct deep analysis
  2. Reveal the bottleneck
  3. Test possible solutions
  4. Provide Quality Assurance
  5. 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.

Case Studies

A system that collected multiple ad and data exchange accounts into one single interface allowing media buyers to transact more efficiently.


An RTB platform with a particular layer for preprocessing data to be used in subsequent OLAP cube preparation.


A system developed for media buyers to manage multiple ad and data exchange accounts through a single interface.


A system to optimize the entire ad serving system that allowed for collecting, processing, and reporting on, billions of transactions every month.


A perfect programmatic video-distribution platform for content owners that maximized monetization and personalization.


Adoppler was a system comprising DSP, SSP, and Ad Exchange that allowed all market parties to transact directly.

Let Us Contact You Group 6 Created with Sketch.

Fill out the form below and we’ll get in touch within 24 hours

Tell us about your project in your own words (only 200 words) *

I agree to  the  Privacy policy