Shulou(Shulou.com)06/01 Report--

During the National Day, the most lively news is the news that a database product in our country won the first performance in the TPC-C test. The spread of the news was controversial and sparked a big discussion about the database. In fact, as one of the most important basic software, database plays an important role in the whole IT ecosystem. After more than 40 years of arduous development, it is gratifying for Chinese database products to win the first place in the test results of international evaluation institutions, but it also inspires us to think further:

Is database performance evaluation really important for Chinese database products? At a time when Chinese database brands and products are in the ascendant, how to make a real breakthrough and find a way of value in this market dominated by international giants?

The answer is: very important.

However, we must not be complacent and embark on the road of indulging in "test results". What Chinese database brands need most now is to work hard on technology, products, talents and ecology. further build a strong database product close to the user's actual business scene and a robust and perfect database ecology, otherwise it will never reach the level of international database brands, let alone achieve transcendence.

What kind of database test is more valuable? database performance evaluation can not be "deviated".

Take the TPC-C test as an example, the international database giant Oracle's test results stay at nine years ago, and then no longer participate in the TPC-C test. This makes people wonder, what kind of database testing will have more practical reference value?

Obviously, for users in various industries, they pay more attention to some performance and functional tests that are close to the real business scenarios of the industry, rather than various evaluation of the list. Take the financial industry as an example, the most stringent business requirements of the financial industry determine that database products need to have sufficient supporting capacity in terms of function, performance, high reliability, security, compatibility, ecology and so on. Database testing, including the financial industry, is obviously easier to be recognized by users.

In the database-related tests of the domestic financial industry, the financial industry standard compliance pilot test of CICC Guosheng is a well-deserved authoritative evaluation in the financial industry. China Gold Guosheng Certification Center is the first professional certification body in China to engage in the quality and safety management of domestic financial services and products with the approval of the National Certification and Accreditation Supervision and Administration Committee. its relevant evaluation results and certification have been widely recognized by the member countries and regions of the International Mutual recognition Agreement Group. China Jin Guosheng financial industry standard compliance pilot evaluation covers key capability projects required by financial-level databases, such as database environment construction, environmental monitoring, syntax support, security support, expansion, performance, and disaster recovery.

For example, CICC Guosheng Financial Industry Standard Compliance pilot Test will test the basic functions of relational distributed database under the business characteristics of the financial industry, including distributed access transaction scripts. meet the atomicity of data operations, isolation of data objects, process consistency, global consistency Test whether it meets the requirements of ANSI SQL 99gam2003, supporting complex SQL, functional indexes, views, stored procedures, sequences, character sets, pattern management, primary key constraints, triggers, partition tables, JAVA/C UDF, deadlocks, fault diagnosis, disaster recovery, flashback data, data security, encryption, user rights management and other financial core transactional databases should have functions.

In addition, the evaluation will also evaluate the reliability most valued by the financial industry, including online backup, offline backup, full and incremental backup, disk backup, regular automatic data backup and other backup functions, as well as double activity in the same city. Testing of the highest level of disaster recovery, such as two places and three centers. In view of the situation that the number of users of domestic financial institutions generally reaches 10 million, CICC Guosheng Certification Center will focus on testing the performance of the database, including whether the stand-alone kernel capability of the database is strong enough; in a distributed environment, the linear scalability and performance expansion ratio of the database, in view of the high concurrency evaluation of the database, is of great reference value for data access in business scenarios such as second kill and panic buying in the financial industry.

In view of the widespread existence of multi-database brands in domestic financial institutions due to historical reasons, Zhongjin Guosheng Certification Center will also test the heterogeneous database compatibility and migration ability of the database. set the synchronous relationship between the tested object database and the heterogeneous database, and then perform the data modification and insertion operation in the tested object, verifying the function that the relevant operations can be automatically synchronized to other heterogeneous databases.

In the latest review, Huawei GaussDB has become a prominent representative of Chinese database brands. According to the financial industry standard "Financial Application Specification for distributed Database Technology (draft)" and the Enterprise Standard "Financial Application Specification for distributed Database Technology (trial)", Huawei GaussDB database based on Huawei Kunpeng processor and GM CPU is the first to pass this test, and all 82 test items are "consistent". It meets the normative requirements of the financial industry in terms of functionality, performance, security, reliability, stability and so on.

Specific to the detailed test results, GaussDB meets the requirements of testing specifications in terms of functionality, security, disaster recovery and performance. In the bank batch settlement business test, the functionality and stability of GaussDB meet the needs of bank batch settlement business, and the performance is even better than 30% of the industry's leading database. In the bank credit card authorization business test, the functionality and stability of GaussDB also meet the requirements, and the performance of its single node is the same as that of the industry-leading database. In the distributed environment, the performance expansion ratio of GaussDB is more than 0.8.

In fact, in terms of performance evaluation, some domestic banks and Huawei are respectively conducting TPC-C competition tests based on TaiShan servers and general CPU servers, which proves that the performance of GaussDB on TaiShan servers is about 20% higher than that of equivalent general CPU servers. Based on the TPC-C standard test of 16 nodes of TaiShan server, the performance of Huawei has reached tens of millions of tpmC.

This data shows that GaussDB's average stand-alone kernel performance is strong enough to have the potential for linear expansion to break through the highest TPC-C performance.

In the latest distributed analytical database test of China Institute of Information and Communications, Huawei GaussDB analytical database also took the lead in completing six indicators and 51 test items, including basic capability, operation and maintenance capability, compatibility, security, high availability and scalability, under the scale of 512-node cluster.

There is no doubt that the Chinese database brands represented by Huawei have more and more dared to show their achievements in various industry evaluation institutions, so that industry users can see the actual reference value of Chinese database brands and products, and become a trend that users are pleased to see.

There is no shortcut to the development of database, and business scenario practice is the only way out. in fact, database, as a high-tech and difficult IT basic product, often requires a large number of talents and funds for long-term patient investment. At the same time, the database is a particularly high threshold of competition in the field. Foreign database giants have built the competition threshold high enough, Chinese database brands often need to pay greater efforts to achieve the same height.

Especially in commercial markets such as finance, telecommunications, manufacturing, transportation, energy and other commercial markets, the international database already has sufficient product capacity, brand capacity and ecological capacity. A database expert confessed to the author: "it is not easy to build a general-purpose database. In addition to performance, ease of use, reliability and recoverability are hidden capabilities, which can not be done overnight." Therefore, there is no shortcut to the development of Chinese database brand, and we need to firmly grasp the window period of accelerating digital transformation in various industries in China, constantly explore and grow from the practice in the actual business scene, accelerate iteration and improvement, and get out of our own value road.

For example, in the financial industry that is most stringent on database products, as far as I know, so far this year, most of the domestic financial industry customers are still using international database giant products, but for the sake of long-term development in the future, many financial institutions are trying to use Chinese database brands in their business. However, the business complexity of traditional financial institutions represented by banks and insurance is far from being comparable to the single business of Internet financial companies, and Chinese database products are often required to have sufficient strength in many aspects.

Take China Merchants Bank as an example. By the end of 2018, the number of registered users of APP alone has reached 140 million, and the number of monthly active users has reached more than 80 million. Almost every day, from head office to branch, and then to sub-branches, various promotional activities such as personalized recommendation, panic buying, second killing and so on are carried out through APP. In the process of its transformation to financial technology, massive and complex core business scenarios make China Merchants Bank carefully evaluate open source databases and commercial data products. There are clear and clear requirements for the database: financial distributed database products with high performance, high scalability, high availability, friendly to business development, and easy to manage, operation and maintenance.

To this end, China Merchants Bank and Huawei carry out joint innovation, China Merchants Bank provides advanced financial business scenarios, and puts forward specific requirements for distributed data based on years of experience in database use and operation and maintenance. and deeply involved in the design, coding, testing and production phase of the core core and architecture of the database. Through joint innovation, Huawei GaussDB has seven characteristics: high-performance database kernel, high scalability of performance and capacity, high availability of data in two places and multi-centers, fast fault switching, support for high-performance distributed transactions, easy development, easy operation and maintenance, and management, and has been fully verified and landed in the actual business scenario of China Merchants Bank.

For example, in terms of the scalability of the database, China Merchants Bank can achieve a quasi-linear expansion with an expansion ratio of no less than 0.8 in the actual business, and the node expansion adopts the method of full volume + increment to achieve imperceptible expansion of the business. It can support more than 8000 concurrent database connections, which can well cope with the sudden increase of database access requests in the instant kill and panic buying scenarios of China Merchants Bank. For example, in the active and standby switching phase of the database, GaussDB achieved a substantial lead in key failure recovery indicators, RTO

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.