Analyse

Analyse Deploys Real-Time Dashboards from SingleStore to Help Minecraft Admins Score with 700,000+ Players Worldwide

Supporting 700,000+ players worldwide
700K+

Rows of data within six months of launch
100M+

200 rows/second data ingestion for real-time dashboards
200/:01

Latency with complex queries with three to five table joins
<100ms

Launched in February 2022, Analyse is the go-to Minecraft analytics solution. The game analytics software-as-a-service (SaaS) solution provides Minecraft server administrators detailed insights into their communities, so they can make the best decisions to grow and thrive. With Analyse you can discover your players, understand your growth, view per-player analytics, fetch any player or PlaceholderAPI statistic, and show them anywhere you like. Analyse is growing rapidly and currently supports hundreds of servers tracking the activity of more than 700,000 unique players worldwide.

London-based programmer and entrepreneur Charlie Joseph [Twitter] [LinkedIn] is CEO and Developer of Analyse. His long history of running Minecraft servers gave him a first-hand understanding of how hard it is to get the data needed to help these player communities thrive. “In the beginning, I had no idea where players came from or how long they played the game. I tried several plugins to get these insights, but each plugin had issues,” said Joseph. 

Charlie Joseph, Chief Executive Officer, Analyse

The plugins available at the time: 

  • Required opening ports, which put servers at risk of potential security breaches 
  • Were resource intensive, leading to laggy servers and a poor player experience 
  • Were hard to use with confusing installation processes 
  • Tracked features that weren’t useful

Since these existing options fell short, Joseph founded Analyse to tackle the challenges that Minecraft server administrators face in understanding and growing their communities. 

challenges-goals

challenges-goalsChallenges/Goals 

Joseph previously used MariaDB, which handled 100 million rows of data but required ongoing maintenance with behind-the-scenes caching to ensure optimal speeds. “The issues with the previous solution I worked with meant we were dealing with partial downtime on a regular basis. I was also working six days a week, and issues couldn’t be resolved until I was home.” The primary revenue source for Analyse was backed by on-site advertising, which meant any downtime resulted in monetary loss.

He also previously used MySQL: “I've had a project involving close to 100 million rows of data using MySQL, and it involved so much stress to maintain with lots of caching involved.”

“Our main goal is for our SaaS solution to be easy to deploy with little to no maintenance, giving server administrators access to actionable data for their players' success within minutes,” he said. His development goals for Analyse included:  

  • A lightweight design
  • An easy-to-use solution with simple installation
  • A solution that provides tried and tested analytics
  • No requirement for server administrators to open up ports

As he started working on the SaaS solution, Joseph knew he needed a robust database that would get Analyse started on the right foundation and be able to rapidly scale.

technology-requirements

technology-requirementsTechnology Requirements 

“For Analyse, I knew we needed a solution that wouldn’t require weekly maintenance or server-side caching,” said Joseph. “The goal was to spend all available time on building the core functionality of the product without dealing with the headache of data migrations later on.” The technology requirements for a database to support Analyse included: 

  • Affordability for a new startup
  • Ultra-fast data ingest to support real-time analytic dashboards 
  • The use of a familiar query language, such as MySQL, rather than a product-specific language
  • Support for rapid scalability and high user concurrency

why-single-store

why-single-storeWhy SingleStore

“I chose SingleStore Self-Managed because I knew I'd be dealing with a high volume of data from launch, and didn't want the headache of migrating this data in the future,” said Joseph. “I wanted to choose something solid from launch, so I could focus more time on my core application instead.”

SingleStore stood out to him, as the technology is used by large, enterprise companies, and offered a self-managed solution that was well suited for the needs of his day-one startup. 

“My favorite thing about SingleStore is the self-managed option,” he said. “Without it, I wouldn't have been able to afford cloud hosting, as Analyse is a startup where saving every dollar is crucial. Once our SaaS solution generates enough revenue, we’ll have the opportunity to move to SingleStore Helios.”

solution

solutionSolution 

Analyse is running the world’s go-to Minecraft analytics solution on SingleStore. “SingleStore has been hands-down the easiest database solution I have tried. The documentation was straight forward and it was effortless to install,” said Joseph.

Analyse deployed SingleStore Self-Managed because the product’s cost efficiency fit its needs. Even the self-managed SingleStore solution required little to no maintenance from day one, and brought the fast analytics dashboard performance Analyse needed.

Analyse runs on two SingleStore clusters with Debian on bare metal, and visualizes the Minecraft server data using the Laravel framework with Vue.js. By using Laravel and Vue.js together, the team can be extremely efficient in delivering new features on the platform.

Analyse is the world’s go-to Minecraft analytics solution

“I'm a huge fan of the Laravel framework as it lets me focus on my core application, rather than authentication, email notifications, etc. In addition to this, I am a huge fan of Vue.js as it is straightforward to learn, but provides a lot of flexibility with components,” added Joseph.

While Analyse isn’t currently using SingleStore platform features, the CEO plans to switch to the Data API for INSERTs soon.

outcomesOutcomes 

Analyse has scaled its technology and its business with SingleStore, and Joseph attributes this as much to people as technology. “SingleStore is a company fueled by an unmatched level of drive and passion that couldn’t be found anywhere else in the database field,” he said. “I’ve gotten to see firsthand how amazing the SingleStore community is and how helpful the entire staff is. The staff was willing to put their own time and effort into answering my questions and guiding me — without expecting any form of financial gain or incentive.”

scaled-to-100-million-rows-of-data-supporting-700-000-minecraft-players-in-six-months

Scaled to 100+ Million Rows of Data Supporting 700,000+ Minecraft Players in Six Months

Analyse launched in February 2022 — and within six months scaled to 100+ million rows and 2GB of data supporting more than 700,000 Minecraft players. The typical data ingestion rate is 200 rows/second. SingleStore Self-Managed scales alongside Analyse’s rapid growth, supporting the platform’s requirements from day one and far into the future.

“We only ever need to worry about expanding our node volume with SingleStore, rather than being concerned with moving to a completely different solution,” said Joseph.

Supports Hundreds of Concurrent Users with Real-Time Dashboards

“Analyse users now have really fast and snappy dashboards, which has made them very happy and satisfied with our solution,” he added. “SingleStore has been hugely beneficial to my application and our goals.”

Analyse delivers real-time insights on community performance metrics to Minecraft server administrators, with SingleStore returning query responses in sub-200 milliseconds (ms) on complex queries featuring three to five table joins.

SingleStore Enables Analyse to Focus on Its Core Application — and Business

“SingleStore is hands down the go-to choice if you want an out-the-box solution without fearing maintainability. I no longer have to cache results with Analyse, so my customers get a live dashboard and I get to focus on building features, not infrastructure,” said Joseph.

“Currently, we only provide community performance metrics. We would love to expand into monetary metrics,” he continued. “That would allow us to provide better insights to the server administrators so they can fine tune gameplay to better convert their player-base who aren't yet subscribed.”

update-tebex-acquired-analyseUPDATE: TEBEX Acquired Analyse 

As this story went live, Analyse was acquired by TEBEX, the industry leader in game server monetization. TEBEX has helped creators earn more than one-half billion dollars using its monetization platform.


Hear how Charlie Joseph got his start in tech, advice to developers navigating a crowded market, and more in this Guest Engineer Showcase!

Joseph wrote the first Laravel driver for SingleStore; you can find the official SingleStore Laravel Driver on GitHub

Check out this post by Joseph on Laravel News: Running SingleStore on Apple Silicon

Watch Joseph speak on this SingleStore Community Call

Read the news release about TEBEX's acquisition of Analyse 

Learn more about the SingleStore Free Tier

SingleStore is helping companies compete and win across every vertical. Learn more →