Case Study: Taobao achieves high-throughput, low-cost favorites processing with Alibaba Cloud ApsaraDB for OceanBase

Taobao handles hundreds of thousands of favorites queries per second with Alibaba Cloud

Taobao, one of the world's largest e-commerce websites, faced a significant challenge in managing its user favorites feature. The system required support for tens of millions of writes per day and needed to handle up to hundreds of thousands of complex join queries per second during peak events like the Double 11 Shopping Festival, placing extremely high demands on database performance and stability.

Alibaba Cloud implemented its ApsaraDB for OceanBase database to address this challenge. The solution distributed data across affordable servers for optimal write performance and utilized a materialized view feature to eliminate join queries, improving query capability by dozens of times. This provided Taobao with a stable, high-throughput, and low-cost solution that successfully handled hundreds of terabytes of data and ensured a seamless user experience during the world's largest shopping festival.

Taobao