China Merchants Bank

Customer Overview

As a leader in the retail banking business, it has more than 180 million retail customers and manages retail customer assets of over 12 trillion yuan. It has a stable market position and is known as the "King of Retail".

The data center of China Merchants Bank has a large-scale IT infrastructure and a wide variety of online and development and testing projects. In order to further improve the asset utilization rate of the database, alleviate the pressure of database operation and maintenance management, and enhance the guarantee of information security, China Merchants Bank chooses Action Technology to build a complete and unified Database as a Service (DBaaS) platform in its private cloud.

Solution Design

Requirements Analysis

  1. Improve database asset utilization: Realize the dynamic allocation and efficient use of database resources through the DBaaS platform in the private cloud.
  2. Reduce operational costs: Reduce the intervention of DBAs and reduce operational manpower costs through automated operation and maintenance tools.
  3. Enhance system reliability and security: Provide a highly available database solution to ensure business continuity.
  4. Improve business agility: Support DevOps practices and accelerate the development, testing, and launch process of business systems.

Technology Selection

CloudTree® RDS: CloudTree RDS (Relational Database Service) provides a full set of solutions for the rapid deployment of MySQL database instances, master-slave hot backup, backup, rollback, monitoring, rapid expansion/shrinkage, and read-write separation.

CloudTree® DMP: The CloudTree® DMP database cluster management platform provides high availability clusters and multi-data center support for MySQL databases.

Implementation Plan

Preliminary Preparation

  1. Environmental assessment: Evaluate the existing IT infrastructure to determine whether it meets the deployment requirements of CloudTree RDS and DMP.
  2. Resource preparation: Prepare the necessary hardware resources (such as servers, storage, network equipment, etc.) and software resources (such as operating systems, database software, etc.) according to the deployment requirements.

Deploy CloudTree® RDS

  1. RDS platform installation: Install and configure the CloudTree RDS platform according to the needs of China Merchants Bank.
  2. MySQL instance deployment: Deploy MySQL database instances on the RDS platform, including master-slave replication, read-write separation, and other configurations.
  3. Monitoring and alerting: Configure the monitoring and alerting system of the RDS platform to ensure the stable operation of the database.

Deploy CloudTree® DMP

  1. DMP installation and configuration: Install and configure the Action Technology DMP platform and integrate it with the RDS platform.
  2. High availability cluster configuration: Use the DMP platform to configure the high availability cluster of MySQL, including master-slave switching, fault recovery, and other strategies.
  3. Test and verification: Conduct high availability tests to ensure that the standby node can automatically take over the business when the master node fails.

Customized Development and Optimization

  1. Customized development: According to the specific needs of China Merchants Bank, customize the DMP and RDS platforms to meet specific business scenarios and technical requirements.
  2. Performance optimization: Perform performance optimization on the MySQL database, including query optimization, index optimization, configuration adjustment, etc., to improve the processing capacity and response speed of the database.
  3. Operation and Maintenance and Guarantee
    • Operation and maintenance system construction: Establish a complete operation and maintenance management system, including monitoring, alerting, log analysis, etc., to ensure the stable operation of the database system.
    • Emergency plan: Develop an emergency plan and fault handling process to ensure a quick response and business recovery in case of emergencies.

Implementation and Execution

It supports more than 100 external service systems such as mobile banking account detail inquiry, wealth experience, ZhaoHu, personal loan system, Internet online financing, credit card enterprise service, credit card Palm Account, and internal service systems such as wholesale mobile CRM, retail financial third-party data portrait development, credit card core log database, inter-bank payment log database, inter-bank application development project, paas reporting system, OLTP framework area monitoring platform, and credit card core area monitoring platform.

Among them, the mobile banking account detail inquiry and online banking income and expenditure detail inquiry adopt a distributed architecture, with 140 sets of MySQL highly available instances deployed on virtual machines, with an average data volume of 150G per instance (total 21TB).

The credit card Palm Account has 8 sets of MySQL highly available instances, supporting a concurrent scale of about 400,000 QPS (50,000 TPS).

Achievements and Benefits

Based on the integration of Action Technology CloudTree® RDS with the bank's DevOps application cloud platform, it provides powerful database capabilities and services for the bank's cloud computing PaaS. It manages more than 7,000 MySQL instances and supports hundreds of projects such as mobile banking, CRM wealth experience, personal loan system, online financing, Palm Account, and credit card enterprise service. Using the MySQL distributed architecture, 140 sets of MySQL highly available instances carry a total data volume of more than 20TB. The credit card Palm Account has 8 sets of MySQL highly available instances, supporting a concurrent scale of 400,000 QPS and 50,000 TPS.