Web analytics softwareSourced

Case Study: How Fathom Analytics cut database TCO 60% with SingleStore

Fathom Analytics Case StudySourced & dated by Case Study Desk

Key facts · TL;DR

Company

Fathom Analytics

Industry

Web analytics software

Challenge

MySQL on Amazon RDS hit connection and IOPS limits, timeouts, and rising costs.

Headline result

60% lower database TCO after dropping Redis, DynamoDB and MySQL

Key results

60%

Lower database TCO

12,000x

Faster processing

20+ min to 100ms, largest customers

1,000x

Better query performance

30 sec

Data export time

Down from hours

The challenge

Fathom Analytics, a privacy-first web analytics company, outgrew its MySQL-on-Amazon-RDS backend as data ingestion surged. It ran into cost-prohibitive deployment, poor scalability, dashboard timeouts, connection limits, IOPS constraints, and no support for data drill-downs or filtering.

The solution

Fathom moved to SingleStore Helios, dropping Redis, DynamoDB, and MySQL in favor of a single fully managed platform for its analytics workloads.

“We are now all in on SingleStore Helios, which has allowed us to drop Redis, DynamoDB, and MySQL, saving us an absolute fortune in monthly costs while dramatically improving performance.”
JE
Jack Ellis
Co-Founder and CEO, Fathom Analytics

The results, in context

Fathom reports a 60% reduction in database total cost of ownership and up to a 12,000x improvement in processing time, cutting a query from over 20 minutes to 100ms for its largest customers. Query performance improved up to 1,000x and data export dropped from hours to 30 seconds.

Products used

SingleStore SingleStore Helios