In recent years, due to changes in the international situation, various regulatory agencies have successively put forward independent and controllable regulatory requirements for core infrastructure. Localization is a necessary measure to achieve self-reliance and self-improvement in science and technology and ensure national information security. Based on the strategic background and the actual needs of rapid business development, it has become an inevitable trend for operators to use domestic databases to promote database replacement.
The SMS business hall business system is a channel for an operator to provide service functions to customers through SMS, and the operator customers can quickly and conveniently inquire about phone bills, understand the latest preferential information, handle business and so on by sending SMS. The business system used Oracle database before, and the business volume was large.
In order to follow the operator's IT localization strategy and steadily improve the localization degree of the IT system, the operator actively carried out the localization and replacement of the core system database, and successfully migrated the SMS business hall system to the OLTP distributed database - GreatDB, reducing the dependence on foreign databases and achieving the goal of independent and controllable.
What are the database requirements of the SMS business hall business system?
1.Overall requirements for database selection:
Selection: Data compatibility and continuity.
Adaptation: The application is flexible and self-adapting
Architecture: The business system is more stable.
Secure: User data is more reliable.
2.The security database GreatDB distributed database independently developed by Wanli Database can perfectly meet the above requirements:
1) High reliability.
As the core basic software of the information system, the database must meet the requirements of high reliability. The security database GreatDB has cross-data center disaster recovery deployment capabilities and automatic fault switching capabilities at the data center level, which can ensure that the RPO is 0 and the RTO is controllable under any fault field, so as to ensure the continuous and stable operation of the entire system.
2) High performance.
After the SMS business hall business system replaces the database locally, it is necessary to ensure that the performance of the replaced system is not lower than that of the original oracle database, so the database must have excellent performance;
3) Oracle compatibility.
Replacing the Oracle database with the secure database GreatDB distributed requires GreatDB to have excellent Oracle compatibility capabilities to ensure smooth and smooth database migration and minimize migration costs.
4) Good localization ecology.
At the same time, the business system adopts domestic servers and operating systems, so it is required that the database has a good localization ecology and is fully compatible with domestic mainstream software and hardware, and the same parts and other ecological chain products.
5) Security.
The first batch of security database GREATDB has passed the security and reliability assessment jointly issued by the China Information Security Evaluation Center and the National Secrecy Science and Technology Evaluation Center, and has obtained the IT product information security certification EAL4 enhanced (EAL4+) certification, indicating that GREATDB has obtained top security recognition in terms of products and information security assurance capabilities, and can fully meet the security needs of users.
One master and two replicas to build a distributed database ecosystem Greatly enhance the strategic value of operators' IT localization strategy.
In order to ensure the high availability of the system, the project adopts a cluster full redundancy design (1 primary and 2 replica redundancy mechanism) for multi-center disaster recovery deployment, so that the system has the failover capability at the equipment room level, and ensures that the recovery point objective (RPO) is 0 and the controllable recovery time objective (RTO) is < 100s in any fault scenario.
At the same time, GreatADM, a database O&M management platform equipped with GreatDB, manages the entire life cycle of the entire database cluster, greatly reducing the time, energy, O&M difficulty and labor cost of database O&M personnel.
This solution uses the distributed security database GreatDB and combines it with business transformation to help customers improve the overall performance of the system, greatly improve business continuity and agility, build a national production technology stack, continuously reduce IT costs, improve the operation efficiency of business systems, and bring great value to the operator's IT localization strategy. The official commercial use of the security database greatdb distributed in the SMS business hall business system fully proves the feasibility of the database to be independent and controllable, and can ensure the better operation of the business.
01 One main and two subordinates ensure more reliable business operation.
According to the business model, the project design initially adopts a 1 main and 1 secondary architecture. However, considering the system disaster recovery and business continuity, the 1 main and 2 secondary architecture was finally selected after evaluation and planning. This solves the original risk of single point of failure and makes the business more reliable.
Business system architecture diagram of SMS business hall.
02Product compatibility and openness are in line with the future evolution direction of business scenarios.
Considering the business complexity of the relevant core systems, the security database GreatDB distributed combines the application characteristics to plan the functions such as custom functions, triggers, stored procedures, and subqueries available in the database, which can not only be compatible with Oracle statements, realize efficient data migration, but also meet the development needs of different business scenarios in the future.
Architecture diagram of the distributed product of the security database GreatDB.
03Data consistency and high availability to meet the differentiated development of business.
Since the SMS business hall business system is closely related to business applications such as service activation, service activation, service inquiry, cancellation processing, business center, commodity center, and order center in large market business scenarios, the security database GreatDB Distributed provides distributed transaction consistency syntax, and uses the database's global transaction manager to ensure the atomicity and isolation of transactions and ensure data consistency.
In order to achieve high availability, the security database GreatDB uses distributed independent database pools and combines GreatADM to carry out unified database cluster operation and maintenance management. Custom switchover policies are used to deal with component-level faults, equipment room-level faults, and city-level faults to achieve high system reliability.
Solution Advantages: Wanli Database participates in the construction of a full-stack IT independent and controllable complex business system for operators, supports system research and large-scale application, and achieves the following four goals through the solution:
01 Ensure business continuity.
By replacing foreign databases with domestic database products, we will build a business continuity guarantee system for operators' core business support systems. The high-availability mechanism is used to ensure business continuity in special scenarios. You can set configuration items to meet the balance between the requirements of the database for high data consistency and business availability.
02 Increase business agility.
Introduce distributed, cloud-based and microservice technology capabilities to replace the original IT system and build a national technology stack. Distributed cloud technology is used to horizontally expand service capacity, and application refactoring is used to achieve horizontal hierarchical and vertical sub-domain and sub-center, improving the agility of application demand delivery and better and faster support for services.
03 Facilitate full-stack localization.
Build a cloud-based resource pool for the national technology stack, realize the construction of a full-stack IT localization technology platform, form a full-stack independent and controllable technology system of the general IT system, and conduct pilot verification in the core application system, so as to prepare for the subsequent full-stack localization.
04 Continue to reduce costs and increase efficiency.
Through the construction of a full-stack IT localization system, it can effectively reduce the comprehensive cost of IT, break the monopoly of foreign technology, reduce costs and increase efficiency for the sustainable development of operators, and ultimately reduce the overall cost by 20%.
In addition to the on-off system, END security database GreatDB distributed has completed the project support of multiple core systems, including interaction center, point bill system, payment center &service opening center, marketing activity center (marketing planning library) & marketing transaction center (marketing execution library), RPS card writing application, SMS business hall, etc.
Database O&M management adopts the unified database O&M management platform GreatADM, which can customize switching policies and real-time monitoring. When different levels or business failures, the system can still operate reliably without affecting each other, achieving a good customer experience.
The SMS business hall business system project verifies the feasibility of replacing the security database GREATDB distributed database in the operator's core system, and provides successful experience and reference for the operator's future promotion in a wider range of business fields and the application of domestic database.