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 to pass raw event data;

Use NoSQL for storing raw event data;

Use MySQL for reporting;

Our Analysis

Use RabbitMQ to pass raw event data. Use NoSQL for storing raw event data. Use MySQL for reporting.

  • Current situation:

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

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

    SQL is very suitable for reporting compared to 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