Yum China

As a global catering giant, it owns brands such as KFC and Pizza Hut, with more than 50,000 stores worldwide and an annual turnover of over tens of billions of dollars, enjoying a stable market position.

• High availability requirement: Yum! Brands needs to build a highly available system database architecture to cope with potential single-point failures and ensure business continuity.
• Read-write separation requirement: To enhance system performance, it is necessary to implement read-write separation in the database to reduce the pressure on the master database.
• Automated operation and maintenance requirement: It hopes to reduce manual intervention and improve operation and maintenance efficiency through automated operation and maintenance management.
• Data consistency and disaster recovery: Ensure data consistency and security in a distributed environment, and establish a disaster recovery mechanism to prevent data loss.
• SQL management standardization: Audit and optimize SQL statements to avoid the impact of inefficient and non-compliant SQL statements on the production database.
• Development and operation standards: Establish standard development and operation specifications to improve team collaboration efficiency and project quality.

CloudTree® Shard distributed database solution: This solution possesses features such as high availability, read-write separation, automated operation and maintenance management, and dual-center disaster recovery, which can meet the core needs of Yum! Brands.
CloudTree® SQLE: Used for the full-process control and management of SQL auditing, online, optimization, and quality tracking, improving the compliance and efficiency of SQL statements, and possessing security audit functions.

1. Requirements confirmation and planning: Confirm the project requirements with the Yum! Brands team and formulate a detailed technical implementation plan.
2. Environment building and preparation: Configure the distributed database environment and build a dual-center disaster recovery architecture.
3. System deployment and integration: Deploy the CloudTree® Shard distributed database and CloudTree® SQLE and integrate them into the existing business system of Yum! Brands.

1. Distributed database construction: Implement read-write separation and high availability in the database to reduce the pressure on the master database and enhance system performance.
2. 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.
3. Automated operation and maintenance implementation: Establish an automated operation and maintenance management process to reduce manual intervention and improve operation and maintenance efficiency.
4. Dual-center disaster recovery construction: Build a dual-center disaster recovery architecture to ensure data security and business continuity.
5. Standard specification formulation: Assist Yum! Brands in establishing standard development and operation specifications to improve team collaboration efficiency and project quality.

The CloudTree® Shard distributed database solution was formulated, which has features such as high availability, read-write separation, automated operation and maintenance management, and dual-center disaster recovery. Additionally, SQL auditing was embedded into the original Devops integrated process. This enhanced the high availability and data consistency of the system database for the project, effectively improving the overall operation and maintenance efficiency of the business. Action Technology also helped the enterprise form standard development and operation specifications. At the same time, CloudTree® SQLE provides full-process control and management of SQL auditing, online, optimization, and quality tracking; it possesses security audit functions, and platform operations are traceable. This avoids the direct flow of inefficient and non-compliant SQL statements into the production database, improving the security and performance of the database.

1. System high availability and stability improvement: Through the distributed database solution and the dual-center disaster recovery architecture, the system's high availability and stability were significantly improved.
2. Operation and maintenance efficiency improvement: Automated operation and maintenance management reduced manual intervention, improving operation and maintenance efficiency and reducing costs.
3. Data consistency and security assurance: Ensured data consistency and security in the distributed environment, preventing the risk of data loss and leakage.
4. SQL management optimization: Through SQL auditing and management, the compliance and efficiency of SQL statements were improved, reducing the impact on the production database.
5. Standard specification formation: Established standard development and operation specifications, improving team collaboration efficiency and project quality.