Shulou(Shulou.com)05/31 Report--

This article mainly explains "what are the advantages of HTAP". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what are the advantages of HTAP".

On April 25, PingCAP, a leading enterprise open source distributed database vendor, officially released version 5.0of TiDB for enterprise core scenarios. TiDB 5.0 has made great progress in performance, stability and ease of use, and added a number of enterprise-level features in transaction processing, high availability and disaster recovery, security compliance, and so on. By introducing MPP (Massively Parallel Processing) architecture to become a distributed database with complete HTAP capabilities, it provides an one-stack data service platform for high-growth enterprises and digital innovation scenarios.

Since 2020, the enterprise digital transformation into the deep water area, the industry digital scene explosive growth, data showing a massive, real-time, online and other trends. As enterprises have higher and higher requirements for real-time and reliability of data, the traditional heterogeneous data stack through database, middleware, big data and other components has exposed some problems, such as difficult to go online, high maintenance cost and so on, which seriously hinders the process of enterprise digitization.

HTAP (hybrid transaction / analytical processing) database can support both online transaction processing (OLTP) and online analytical processing (OLAP) scenarios on a single data source, avoiding a large amount of data interaction between online and offline databases in the traditional architecture. Gartner, an authoritative research institution, believes that HTAP database will become an important development trend in the database field, and an integrated data platform will accelerate the digital transformation.

A database with full HTAP capabilities

As a leading enterprise distributed database product, TiDB has implemented OLTP Scale (large-scale expansion of online transaction processing) as early as version 1.0, and version 4.0 has achieved preliminary HTAP capabilities. Version 5.0 introduces MPP architecture on the basis of the original HTAP engine TiFlash to provide a distributed computing engine that matches storage, which further improves the ability of parallel computing and analysis under massive data. By sharing the SQL front end with TiDB-Server to realize the sharing of Parser and optimizer, TiDB provides an integrated entrance to the business, can automatically select stand-alone execution or MPP mode, and isolates transactional and analytical loads, so that the two sides do not interfere with each other under high concurrency pressure. The measured scene shows that under the same hardware configuration and data volume, the execution speed of MPP is several times faster than that of Greenplum.

In addition, TiDB 5.0 is based on distributed architecture, supports cloud native and multi-cloud, can flexibly expand throughput or storage, easily cope with high concurrency and massive data scenarios, and implement one-stack data services. Enterprise users, Internet users, SaaS vendors and independent software developers can all build digital scenario applications through a TiDB system without paying attention to the underlying architecture.

Overall enhanced performance and stability

TiDB set the goal of becoming an enterprise database at the beginning of its design. Its technical architecture of "distributed strong consistent transactions, online elastic horizontal expansion, high availability of fault self-recovery, multi-activity across data centers" determines that it has the key characteristics needed by enterprise core databases. TiDB 5.0 has made great strides in performance, achieving an average 50% performance improvement in OLTP benchmarks such as Sysbench and TPC-C by providing clustered indexing, asynchronous transaction commit, TiFlash MPP, and so on.

At the same time, TiDB 5.0 greatly reduces the performance jitter caused by preemption of resources in QPS (queries per second) by optimizing the use of resources such as TPC-C tpmC O, network, CPU, memory and so on. In the benchmark test of TPC-C OLTP, the standard deviation of TPC-C tpmC jitter is less than or equal to 2%.

More open user ecology

At the beginning of its establishment, PingCAP took open source as its core strategy, and the highly active open source community brought the flywheel effect to the development of TiDB products. At present, TiDB's R & D capability, engineering quality and iterative speed have been in the leading level in the world. TiDB is also an eco-friendly database, TiDB 5.0integrates a richer big data ecosystem, adds Kafka connectors, supports S3 storage services, and provides multiple data migration, import and sharing components to facilitate users to use TiDB in heterogeneous environments.

With its leading technical capabilities and perfect business service support system, TiDB helps users in finance, Internet, retail, logistics, manufacturing, public service and other industries to build a future-oriented data service platform. At present, TiDB has been applied in the production environment of more than 1500 head enterprises around the world. Including Bank of China, Everbright Bank, Pudong Development Bank, Zhejiang Merchant Bank, Bank of Beijing, WeBank, Yi Lian Bank, China UnionPay, China Life, Ping an Life, lufax, China Mobile, China Unicom, China Telecom, China Sports Juncai, State Grid, ideal Automobile, Xiaopeng Automobile, VIVO, OPPO, Yum China, China Post, Shunfeng Express, Zhongtong Express, Tencent, Meituan, JD.com, pinduoduo, Xiaomi, Xiaomi Sina Weibo, 58.com, Zhihu, iqiyi, bilibili, Square (USA), Dailymotion (France), Shopee (Singapore), ZaloPay (Vietnam), BookMyShow (India), etc.

Huang Dongxu, co-founder and CTO of PingCAP, said: "A real enterprise database manufacturer should think from the perspective of users. Whether it is an enterprise to buy a database to deal with the challenge of digitization, or an engineer to face hundreds of database clusters to maintain, I think what they need is" don't worry, don't worry, don't worry ". TiDB 5.0is a milestone version with complete HTAP capabilities. No matter it is transactional or analytical, as long as a set of TiDB system can meet the "massive, real-time and online" business needs in the process of digital transformation.

Thank you for your reading, the above is the content of "what are the advantages of HTAP". After the study of this article, I believe you have a deeper understanding of the advantages of HTAP, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.