AsiaInfo Anhui ANTDB has undergone in-depth research and careful design in the global database replacement scheme of CRM business system in a certain province of China Mobile. This solution uses a high-availability and heterogeneous database migration scheme to ensure the stability and continuity of data during the replacement process.
First, the high-availability solution ensures the high availability of the database by deploying the architecture and components.
Figure 1: HA solution architecture.
The solution uses a stand-alone version of AsiaInfo Ander ANTDB database to replace foreign commercial databases, and is deployed in two computer rooms. By using adbhamgr + adbdcs components for high availability management, the primary node can be automatically switched over to ensure high availability of the database. The adoption of this deployment architecture and components provides stable and reliable data storage and management capabilities for the CRM business system.
Second, the heterogeneous database migration solution is another important part of the solution.
Figure 2: Heterogeneous database migration scheme.
This solution synchronizes the data of foreign commercial databases to the AsiaInfo Alpha antdb database through incremental synchronization. Before the shutdown, use the synchronization tool to synchronize all the data from the foreign commercial database to the AsiaInfo AntDB databaseThe follow-up synchronization tool continuously synchronizes the incremental data in the oracle to the AsiaInfo AntDB databaseDuring cutover, only the last increment needs to be synchronized to complete data synchronization. This migration method achieves a high compatibility of 96%, saving the cost and cost of migration, and saving costs for customers. At the same time, the performance of the domestic database after migration is improved by 13% compared with the original environment, and the failure rate is 0 after the launch. This migration scheme ensures the integrity and consistency of data, and provides a strong guarantee for the smooth operation of the CRM business system.
In the process of program implementation, AsiaInfo Anhui ANTDB database has also carried out a number of technological innovations and innovations. Among them, building an SQL parsing engine is one of the important technological innovations. AsiaInfo Annhui antdb 60 In the process of cutover pilot, 6 version upgrades have been achieved, and an independent foreign commercial database syntax parser has been built on the basis of the native PostgreSQL syntax parsing, so as to achieve multi-faceted compatibility with the syntax, functions and characteristics of foreign commercial databases. The adoption of this innovative technology greatly reduces the workload of application adaptation and retrofit, and improves the efficiency and quality of replacement.
In addition, database read/write splitting is also an important technological innovation in this scheme. The read/write splitting architecture is implemented based on antdb+dbproxy to achieve bottlenecks that cannot be broken through by existing monolithic databases. After read/write splitting is fully launched, the secondary database bears about 75% of the query volume, and the CPU load of the primary database is reduced by 53%, greatly improving the overall performance. The adoption of this technology not only improves the carrying capacity of the database, but also greatly improves the overall performance, providing strong support for the smooth operation of the CRM business system.
In addition to the above technological innovations and optimizations, AsiaInfo Alpha ANTDB database has also been optimized and greatly improved for the performance problems of sub-transactions, the conflict between the secondary database read and the main database, and the LSE atomic instructions of the ARM server. These optimizations and improvements ensure the smooth completion of the replacement of the global database of the CRM system, and provide a strong guarantee for the stable operation of the subsequent system.
In short, AsiaInfo AntDB adopted a high-availability and heterogeneous database migration scheme in the global database replacement scheme of the CRM business system of a certain province of China Mobile, and carried out a number of technological innovations and optimizations. These measures ensure the smooth completion of the replacement and provide strong support for the stable operation of the CRM business system. At the same time, these innovations and optimizations also provide methods and experience for the upgrading and replacement of domestic software and hardware, and promote the development and application of domestic database technology.
About AsiaInfo Alpha ANTDB Database
Founded in 2008, ANTDB database serves hundreds of millions of users in 24 provinces, municipalities and autonomous regions in China on the operator's core system, with product characteristics such as high performance, elastic expansion, and high reliability, and can process millions of communication core transactions per second at a peak, ensuring the continuous and stable operation of the system for more than ten years, and has been successfully commercialized in communications, finance, transportation, energy, Internet of Things and other industries.