This article details Zhihu's Moneta service handling over a trillion rows, the scalability challenges it faced, the evaluation of MySQL sharding and MHA, and how adopting the open‑source HTAP database TiDB enabled millisecond‑level query latency, high availability, and easy horizontal expansion.
TiDB is a distributed NewSQL database that combines MySQL compatibility with a stateless SQL layer, a PD metadata manager, and a transactional key‑value store, offering automatic scaling, multi‑data‑center Raft replication, global secondary indexes, Percolator‑style 2PC, HTAP via TiFlash, and a rich ecosystem of migration, backup, CDC, and monitoring tools, as demonstrated by its large‑scale deployment at DeWu.
TiDB, an open‑source distributed relational database, separates compute and storage, offers MySQL compatibility, supports both OLTP and OLAP workloads, and provides HTAP capabilities, with real‑world use cases ranging from MySQL sharding to full replacement, data warehousing, and serving as a modular component.
Tencent’s TBase is an enterprise‑grade, PostgreSQL‑based distributed HTAP database that combines strong consistency, high‑concurrency OLTP and high‑performance OLAP within a single cluster, using a GTM‑coordinated two‑phase commit, flexible data distribution, parallel query optimization, and extensive security and scaling features.
This article explains the core differences between OLTP and OLAP, evaluates whether traditional OLTP databases like MySQL can handle analytical workloads, introduces benchmark queries, and provides a comprehensive overview of data‑warehouse concepts such as data sources, fact and dimension tables, multi‑dimensional modeling, and common cube operations.
This article describes how Zhihu's Moneta service, which stores over a trillion rows of user‑read data, migrated from MySQL sharding to the distributed NewSQL database TiDB to achieve high availability, horizontal scalability, millisecond‑level query latency, and improved overall system performance.
The presentation outlines OceanBase's evolution, technical advantages such as high availability, scalability, performance, multi‑tenant HTAP capabilities, and its successful deployment in the insurance industry, demonstrating how a self‑developed distributed relational database can transform core financial services.
This article provides a comprehensive overview of OLAP systems, classifying them by data volume and modeling approach, comparing MOLAP, ROLAP, HOLAP and HTAP, reviewing popular open‑source products, and detailing architectural, query‑optimization, vectorization, storage and resource‑management techniques that affect analytical warehouse performance.
TiDB is an open‑source, cloud‑native distributed relational database that combines OLTP and OLAP capabilities, offers horizontal elasticity, strong ACID transactions, MySQL compatibility, and is suited for high‑availability, large‑scale, real‑time analytics scenarios across various industries.
This article introduces TiDB, an open‑source distributed HTAP database compatible with MySQL, explains its architecture—including TiDB Server, PD, TiKV, and TiSpark—covers deployment requirements, highlights key advantages such as elastic scaling, fault‑tolerance, strong consistency, and provides practical tips and common pitfalls for production use.
Tencent Cloud is hosting a three‑month online technical salon, featuring dozens of senior database experts who will nightly dissect the architecture, implementation and best practices of domestic databases such as TDSQL, TBase and CynosDB/CDB, with April’s TBase sessions open for reservation via QR code and offering live‑stream giveaways.
Zhihu’s Moneta service, handling over 1.3 trillion rows and billions of daily writes, migrated from MySQL sharding to TiDB, achieving millisecond query latency, high availability, and horizontal scalability, while sharing architectural choices, performance metrics, migration challenges, and future expectations for TiDB 3.0.
Zhihu's Moneta service stores over a trillion rows of user‑read posts and, facing massive write throughput and strict sub‑90 ms query latency requirements, migrated to the open‑source HTAP database TiDB, achieving horizontal scalability, high availability, and dramatically improved performance.
This article provides a comprehensive technical overview of TiDB, covering its HTAP design, TiKV storage engine with RocksDB and Raft replication, the mapping of relational tables to key‑value pairs, MVCC implementation, transaction handling, and the PD scheduler that balances replicas, leaders, and hot spots across a distributed cluster.
This article reviews the evolution, market trends, core components, architectural challenges, and emerging technologies of cloud‑native distributed database systems, highlighting Alibaba Cloud's solutions such as POLARDB, AnalyticDB, and AI‑driven management platforms that enable elastic, high‑availability, and intelligent data services for modern enterprises.
This article details how Yiguo Group migrated from a single‑server SQL Server setup to a distributed TiDB + TiSpark architecture, highlighting performance gains, HTAP capabilities with TiFlash, ETL differences, and future data‑platform considerations.
This article details how Zhihu’s Moneta service tackled massive data growth—over a trillion rows—by migrating from MySQL sharding to the HTAP‑capable TiDB platform, describing architectural changes, performance gains, migration lessons, and future expectations with TiDB 3.0.
This article recounts TiDB’s evolution from a transactional MySQL‑compatible database to a hybrid‑transactional/analytical platform, detailing its architecture, performance challenges, integration with TiSpark and TiFlash, and future plans to balance TP and AP workloads.
This article explains the concepts of OLTP, OLAP and HTAP, describes the DRDS HTAP architecture—including its engine and storage layers, Fireworks Spark‑based engine, optimizer stages, and streaming capabilities—and demonstrates cross‑database MPP queries and streaming joins while outlining suitable use cases and limitations.
This article examines why traditional relational databases like MySQL struggle with analytical workloads, compares ROLAP and MOLAP approaches, explains Spark’s architecture and its advantages for OLAP, and details how Alibaba Cloud’s DRDS HTAP leverages a Spark‑based engine to deliver real‑time distributed query processing.
SequoiaDB, a financial‑grade open‑source distributed database, combines a multi‑model engine with a compute‑storage separation architecture to deliver full MySQL, PostgreSQL and SparkSQL compatibility, elastic scaling, HTAP capabilities, and robust multi‑site disaster recovery for cloud‑native enterprise workloads.
In this interview, Baidu’s senior big‑data architect Ma Ruyue discusses his career transition from Hadoop to online databases, the design philosophy behind Baidu’s Palo ROLAP system, the future of HTAP, and his views on the evolving big‑data ecosystem including Spark, AI, and containerization.
The March 2018 DBAplus Newsletter compiles the latest releases across RDBMS, NoSQL, NewSQL, time‑series and big‑data ecosystems, highlighting new features, performance improvements, compatibility updates and key technical links for Oracle, MySQL, MariaDB, SQL Server, DB2, PostgreSQL, TiDB, CockroachDB, InfluxDB, Hadoop and several Chinese‑made databases.
This article traces the evolution of database systems—from early navigational models and Codd's relational theory through the rise of NoSQL and sharding, to the resurgence of NewSQL and the emerging HTAP paradigm—highlighting technical motivations, design trade‑offs, and future directions.
PingCAP co‑founder and CEO Liu Qi discusses the motivation behind creating TiDB, its evolution into a HTAP NewSQL database, key development priorities such as SQL enhancements, storage engine innovation, cloud‑native integration, and shares insights on open‑source project management and future database trends.
This article explains how Alibaba Cloud uses RDS PostgreSQL together with HybridDB for PostgreSQL and OSS to handle hundreds of thousands of transactions per second, merge order feeds into a wide table, and provide minute‑level latency with millisecond‑level real‑time analytics for e‑commerce platforms.