MemSQL
21 Case Studies
Case Study: Fanatics achieves real-time, scalable analytics and a unified SQL platform with MemSQL
A MemSQL Case Study
How Fanatics Powered Their Way to a Better Future
Fanatics, a global leader in licensed sports merchandise operating Fanatics.com and hundreds of team and league storefronts, needed to scale analytics to meet real-time, high-volume demand (spikes during games, trades, promotions). Its Kafka-based event backbone (Fanflow) produced JSON event streams consumed by a complex mix of Lucene indexers, Flink, Spark, Redis and other tools, creating siloed workflows, schema management headaches, high maintenance overhead and inconsistent SLAs.
Fanatics adopted MemSQL to replace the Lucene layer and convert Spark/Flink jobs to SQL-based processing, leveraging MemSQL’s Kafka/JSON interoperability and in-memory/columnstore performance. The result: a unified SQL platform that ingests all enterprise sources, handles ~2,500 events/sec (4M/day) and ~3 billion rows with fast ad hoc queries, improved SLAs, lower operational complexity, and more developer time for insights, self-service analytics and new use cases like order visibility.
Open case study document...