Starbucks

Customer Overview

As a global leader in the coffee chain industry, it has more than 38,000 stores worldwide, spanning 85 countries, with an annual sales of nearly tens of billions of dollars, continuously leading the coffee culture trend.

Solution Design

Requirements Analysis

High availability requirement: Starbucks needs to enhance the high availability of its system database to ensure uninterrupted business in the event of a single-point failure.
Data consistency requirement: Ensure data consistency and accuracy in a distributed environment.
Operation and maintenance efficiency improvement: Improve the overall operation and maintenance efficiency of the business and reduce manual intervention.
Development and operation specification: Form standard development and operation specifications to improve team collaboration efficiency.
SQL management requirement: Audit, launch, optimize, and track the quality of SQL statements to avoid the impact of inefficient and non-compliant SQL statements on the production database.
Security requirement: Enhance the security of the database and ensure traceability of platform operations.

Technology Selection

CloudTree® Shard distributed database solution: Provides functions such as high availability, read-write separation, automated operation and maintenance management, and dual-center disaster recovery.
CloudTree® SQLE: Used for the full-process control and management of SQL auditing, launch, optimization, and quality tracking, with security audit functions.

Implementation Plan

Environment preparation: Set up a distributed database environment and configure a dual-center disaster recovery architecture.
System deployment: Deploy the CloudTree® Shard distributed database and CloudTree® SQLE.
Integration and testing: Integrate the new system into the existing business system for comprehensive testing.
Continuous optimization: Continuously optimize the system performance and operation and maintenance processes based on the operating conditions.

Implementation and Execution

Distributed database deployment: Build a distributed database environment for MySQL, Redis, and OceanBase, achieving read-write separation and high availability of data.
SQL auditing and management: Conduct full-process control and management of SQL statements through CloudTree® SQLE to ensure the compliance and efficiency of SQL statements.
Automated operation and maintenance management: Implement automated operation and maintenance of the database to reduce manual intervention.
Dual-center disaster recovery: Establish a dual-center disaster recovery architecture to ensure data security and business continuity.

Achievements and Benefits

Provided the CloudTree® RDS private cloud database as a service platform software, supporting the creation, expansion, backup and recovery, monitoring and alerting functions of multi-tenant Redis database resources, realizing unified database resource management and self-service capabilities, improving the full-life-cycle management capability and security of the database, and reducing the difficulty of operation and maintenance.

System high availability improvement: Through the distributed database solution, the system's high availability was significantly improved, reducing the risk of business interruption.
Data consistency assurance: Ensured data consistency and accuracy in the distributed environment.
Operation and maintenance efficiency improvement: Automated operation and maintenance management reduced manual intervention, improving operation and maintenance efficiency.
SQL management optimization: Through SQL auditing and management, the impact of inefficient and non-compliant SQL statements on the production database was avoided, improving the security and performance of the database.
Standard specification formation: Formed standard development and operation specifications, improving team collaboration efficiency and project quality.

McDonald's

With more than 40,000 stores worldwide and an annual operating income of over 25 billion dollars, to enhance the operational service capability and system stability, it chose the DMP multi-source database management platform and the open-source database MySQL, ensuring the stable operation of the system, reducing operational costs, and ensuring business continuity and data integrity.

China Taiping Insurance

With more than 50 existing MySQL database business systems and more than 1,000 database instances, with a plan to reach 3,000+ in the future, to achieve second-level response for hundreds of millions of users and real-time computing of full-volume data, it chose MySQL and Aikesheng's DMP platform, improving the service response speed, reducing costs, and enhancing competitiveness.

People's Insurance of China

Committed to expanding its insurance policy business through Internet channels, it needed to deploy a highly scalable and superior database integration platform. It chose the enterprise version of MySQL and MySQL Cluster, as well as Aikesheng's database operation and maintenance management platform, improving the business processing capability, reducing costs, and promoting market expansion.