An improvement in MySQL cluster in e-commerce scenarios

With the rapid development of e-commerce business, a more reliable and extensible database cluster architecture is needed in almost all e-commerce systems. For a distributed-system, Percona XtraDB Cluster provides consistency and availability. MySQL Replication provides availability and partitioning tolerance. In an e-commerce system, we need consistency, availability, partitioning tolerance in different scenarios. The contributions of this paper are a new design of a proper architecture to satisfy CAP in different aspects in an e-commerce business, why this architecture is appropriate. Finally, we implemented a system called MEC based on this architecture.