Managing hundreds of millions of orders with Table Store

Click for: original source

This article discusses how Table Store can help you store and manage massive amounts of data by using a fictional e-commerce platform as an example.

Ordering systems are a type of general-purpose systems that are widely used in various industries, such as e-commerce orders, bank journal entries, and phone bills from communication service providers. Traditional practices for these systems have been established over decades of development. However, the development of Internet and increasing importance attached to data by enterprises lead to an increasing number of orders that need to be stored and persisted. The increasing data importance and data scale bring new challenges.

The article’s content:

  • Scenario and technical considerations
  • Query capability, data volume, service performance
  • Solution evolution, including ordinary
    • MySQL database/table sharding
    • MySQL + HBase
    • MySQL + ElasticSearch
  • Table Store
    • Overview of the order system based on Table Store

… and much more. The SearchIndex solution from Table Store can perfectly support an order system holding 100 million orders. Great overview for architects working with successful e-commerce shop!

[Read More]

Tags mysql database performance how-to cloud