ClickHouse Case Studies Boosting Game Performance: ExitLag's Transition from MySQL to ClickHouse

Edit This Case Study Record

	Boosting Game Performance: ExitLag's Transition from MySQL to ClickHouse ClickHouse

Boosting Game Performance: ExitLag's Transition from MySQL to ClickHouse

ClickHouse

Technology Category	Analytics & Modeling - Machine Learning Cybersecurity & Privacy - Intrusion Detection
Applicable Industries	Equipment & Machinery
Applicable Functions	Procurement
Use Cases	Behavior & Emotion Tracking Livestock Monitoring
Challenge	ExitLag, a tool that optimizes the gaming experience for over 1,700 games on over 900 servers worldwide, was facing performance issues with MySQL. They were encountering bottlenecks and slowdowns with specific analytical queries about user behavior analysis and network route mapping, especially as their data volume increased. In their continuous effort to resolve common connection problems for gamers, ExitLag developed a sophisticated method for sending connection packets from users. These packets are sent simultaneously through different routes, thus increasing the guarantee that the packet will be delivered. However, the increasing data volume was causing performance issues with their existing MySQL system. Read More
About Customer	ExitLag is a tool that optimizes the gaming experience for over 1,700 games on over 900 servers worldwide. It provides a faster, less crowded connection, thus minimizing lag, enhancing game routes, and ending packet loss. ExitLag processes approximately 6 million daily events, using ClickHouse to analyze user behavior on their service and map possible network routes. These valuable insights into user behavior, game preferences, session durations, and network performance have not only provided gamers with optimized routes and an enhanced gaming experience but also improved ExitLag's ability to handle data at scale. Read More
Solution	Datacosmos Consultoria, a leading IT consultancy based in Brazil, helped ExitLag transition from MySQL to ClickHouse. ClickHouse was chosen for its exceptional performance, scalability, and efficient data compression capabilities. It offers a significant advantage over MySQL when it comes to the performance of analytical queries. With ClickHouse, ExitLag could quickly process billions of lines of data in a short time, catering to their need for speed and scale. ClickHouse's materialized views have been another game-changer for ExitLag. By precomputing and storing results of complex queries, materialized views provide faster access to aggregated data, reducing the need for repetitive computations. Visualization tools such as Grafana and Power BI, as well as ad-hoc queries, are used to analyze and present this aggregate data. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Machine Learning

Cybersecurity & Privacy - Intrusion Detection

Applicable Industries

Equipment & Machinery

Applicable Functions

Procurement

Use Cases

Behavior & Emotion Tracking

Livestock Monitoring

Challenge

ExitLag, a tool that optimizes the gaming experience for over 1,700 games on over 900 servers worldwide, was facing performance issues with MySQL. They were encountering bottlenecks and slowdowns with specific analytical queries about user behavior analysis and network route mapping, especially as their data volume increased. In their continuous effort to resolve common connection problems for gamers, ExitLag developed a sophisticated method for sending connection packets from users. These packets are sent simultaneously through different routes, thus increasing the guarantee that the packet will be delivered. However, the increasing data volume was causing performance issues with their existing MySQL system.

About Customer

ExitLag is a tool that optimizes the gaming experience for over 1,700 games on over 900 servers worldwide. It provides a faster, less crowded connection, thus minimizing lag, enhancing game routes, and ending packet loss. ExitLag processes approximately 6 million daily events, using ClickHouse to analyze user behavior on their service and map possible network routes. These valuable insights into user behavior, game preferences, session durations, and network performance have not only provided gamers with optimized routes and an enhanced gaming experience but also improved ExitLag's ability to handle data at scale.

Solution

Datacosmos Consultoria, a leading IT consultancy based in Brazil, helped ExitLag transition from MySQL to ClickHouse. ClickHouse was chosen for its exceptional performance, scalability, and efficient data compression capabilities. It offers a significant advantage over MySQL when it comes to the performance of analytical queries. With ClickHouse, ExitLag could quickly process billions of lines of data in a short time, catering to their need for speed and scale. ClickHouse's materialized views have been another game-changer for ExitLag. By precomputing and storing results of complex queries, materialized views provide faster access to aggregated data, reducing the need for repetitive computations. Visualization tools such as Grafana and Power BI, as well as ad-hoc queries, are used to analyze and present this aggregate data.

Impact #1	The transition to ClickHouse has resulted in significant operational improvements for ExitLag. The efficient data compression of ClickHouse allows for managing vast volumes of data with lower disk consumption, resulting in reduced infrastructure costs. Faster data analysis with ClickHouse has optimized resource utilization, further driving down operational costs. The use of ClickHouse's materialized views and visualization tools such as Grafana and Power BI has enabled ExitLag to efficiently handle an increasing data volume and provide swift responses to analytical queries. The transition has also improved ExitLag's ability to provide a superior gaming experience by providing valuable insights into user behavior, game preferences, session durations, and network performance.

Impact #1

The transition to ClickHouse has resulted in significant operational improvements for ExitLag. The efficient data compression of ClickHouse allows for managing vast volumes of data with lower disk consumption, resulting in reduced infrastructure costs. Faster data analysis with ClickHouse has optimized resource utilization, further driving down operational costs. The use of ClickHouse's materialized views and visualization tools such as Grafana and Power BI has enabled ExitLag to efficiently handle an increasing data volume and provide swift responses to analytical queries. The transition has also improved ExitLag's ability to provide a superior gaming experience by providing valuable insights into user behavior, game preferences, session durations, and network performance.

Benefit #1	ExitLag processes approximately 6 million daily events
Benefit #2	ClickHouse allows ExitLag to quickly process billions of lines of data in a short time
Benefit #3	Significant cost savings due to ClickHouse's efficient data compression and lower disk consumption

Benefit #1

ExitLag processes approximately 6 million daily events

Benefit #2

ClickHouse allows ExitLag to quickly process billions of lines of data in a short time

Benefit #3

Significant cost savings due to ClickHouse's efficient data compression and lower disk consumption

Download PDF Version

Overview

Boosting Game Performance: ExitLag's Transition from MySQL to ClickHouse

Operational Impact

Quantitative Benefit