Download PDF
ClickHouse > Case Studies > Boosting Game Performance: ExitLag's Transition from MySQL to ClickHouse
ClickHouse Logo

Boosting Game Performance: ExitLag's Transition from MySQL to 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
The 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 The 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.
The 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.
Operational Impact
  • 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.
Quantitative Benefit
  • ExitLag processes approximately 6 million daily events
  • ClickHouse allows ExitLag to quickly process billions of lines of data in a short time
  • Significant cost savings due to ClickHouse's efficient data compression and lower disk consumption

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.