RTB Platform Logging System Optimization

Case Study

The Problem

An RTB platform was initially designed to store user action data in MySQL databases. Since then MySQL has become the bottleneck due to the rising number of ad impressions and clicks.

Solution

Use RabbitMQ for passing raw event data;

Use NoSQL for storing raw event data;

Use MySQL for reporting;

Our Analysis

Use RabbitMQ for passing raw event data. Use NoSQL for storing raw event data. Use MySQL for reporting.

  • Current situation:

    MySQL is used  both  for raw event logging and report generation;

    Relational data structure is not optimal for write-many scenarios;

    SQL is very suitable for reporting  in comparison with NoSQL solutions;

  • Outcome:

    Inefficient technology utilization leads to performance bottlenecks;

Our clients say

Let Us Contact You

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