As a leading global commercial bank, its business areas cover deposit and loan, payment and settlement, investment banking, etc., with assets exceeding 44 trillion yuan. It has ranked among the top banks in the world for many years.
The core business of Industrial and Commercial Bank of China needs to expand, but it faces the problems of limited scalability and high costs of traditional centralized databases and mainframes. Therefore, it is urgent to switch to the x86 platform and adopt an open-source database. However, mainstream open-source databases have challenges in terms of high availability and scalability.
Core business expansion requirements: The core business of Industrial and Commercial Bank of China needs to further develop, which requires the IT system to support a larger business volume and more complex data processing.
Cost and scalability considerations: The currently used traditional centralized database and mainframe have limited scalability and high maintenance costs. To reduce costs and improve scalability, Industrial and Commercial Bank of China considers migrating to the x86 platform and introducing an open-source database.
Selection and challenges of open-source databases: Open-source databases have deficiencies in high availability and scalability, which may affect business continuity and future expansion.
Industrial and Commercial Bank of China needs to achieve cost optimization and scalability improvement of the IT system while ensuring business continuity and high availability. This requires full consideration of its performance, reliability, scalability, and cost-effectiveness when selecting and implementing a new database solution, and the problem of insufficient high availability and scalability of the open-source database needs to be solved through self-developed or purchased methods.
For the problems faced by Industrial and Commercial Bank of China in the expansion of its core business, MySQL is selected as the open-source database.
MySQL serves as the decision basis for the open-source database:
Solutions to the scalability and high availability problems of MySQL:
To sum up, Industrial and Commercial Bank of China chooses MySQL as the open-source database based on its wide application verification, open-source characteristics, community support, and version quality and stability. For the deficiencies in scalability and high availability of MySQL, it can be solved through distributed architecture and high availability solutions.
Business Transformation (Oracle → MySQL)
Trial Operation of New Business
For the development of new businesses, the MySQL database is adopted in the design stage, and business development is carried out according to the MySQL specifications. Finally, the business goes online, and the MySQL business architecture and development capabilities are reserved.
Through the Action Technology CloudTree® database management platform software, the unified management of MySQL master-slave clusters, intra-city disaster recovery clusters, and remote disaster recovery clusters has been realized, achieving machine-level, computer room-level, and regional-level disaster recovery protection. The intra-city switching has achieved RPO = 0 and RTO in seconds, meeting the business high availability and disaster recovery requirements, and stably supporting the operation of more than 10 sets of businesses. At the same time, the read-write separation architecture is adopted to make full use of the standby machine resources, improve the resource utilization rate, and significantly improve the system throughput.