BestHub
Sign in
Tagged articles
215 articles
Page 1 of 3
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Dec 15, 2025 · Databases

How TiDB Achieves Multi‑Datacenter High Availability with Multi‑Raft and TiCDC

This article explains TiDB's distributed, financial‑grade high‑availability architecture, covering single‑cluster same‑zone multi‑datacenter deployment, cross‑cluster DTS synchronization, underlying Raft and label mechanisms, configuration examples, performance trade‑offs, and real‑world monitoring results on the HULK cloud platform.

TiCDCTiDBdistributed database
0 likes · 16 min read
How TiDB Achieves Multi‑Datacenter High Availability with Multi‑Raft and TiCDC
Java Web Project
Java Web Project
Dec 7, 2025 · Databases

What Makes TiDB a NewSQL Powerhouse? A Deep Dive into Architecture, Features, and Use Cases

This article analyzes TiDB as a distributed NewSQL database, explaining the evolution from traditional SQL to NoSQL and NewSQL, detailing TiDB's core components, elastic scaling, ACID transactions, HTAP capabilities, high‑availability design, compatibility with MySQL, real‑world use cases, and its limitations compared to conventional databases.

HTAPMySQL compatibilityNewSQL
0 likes · 24 min read
What Makes TiDB a NewSQL Powerhouse? A Deep Dive into Architecture, Features, and Use Cases
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 29, 2025 · Databases

Why Does the Same SQL Run Faster on Oracle Than on OceanBase? Uncovering Execution Plan Discrepancies

A customer observed a SQL statement that runs twice as fast on Oracle as on OceanBase, prompting a detailed analysis of execution plans, leader distribution, and distributed query behavior, followed by practical hint and table‑group optimizations that reduce the runtime from several seconds to sub‑second levels.

OceanBaseSQL OptimizationTable Group
0 likes · 18 min read
Why Does the Same SQL Run Faster on Oracle Than on OceanBase? Uncovering Execution Plan Discrepancies
Alibaba Cloud Developer
Alibaba Cloud Developer
Oct 17, 2025 · Databases

Explore PolarDB‑X v2.4.2: New Proxy, Multi‑Language Connectors, and High‑Performance Features

PolarDB‑X version 2.4.2 introduces a Java‑based proxy, multi‑language client drivers, enhanced HA switching, MySQL‑compatible replication, performance testing results, and the open‑source MCP server for AI integration, providing a comprehensive overview of the latest distributed database capabilities.

ConnectorMCP ServerMySQL replication
0 likes · 19 min read
Explore PolarDB‑X v2.4.2: New Proxy, Multi‑Language Connectors, and High‑Performance Features
Architect's Guide
Architect's Guide
Sep 29, 2025 · Databases

What Is NewSQL? Exploring TiDB’s Distributed Database Features

This article explains NewSQL concepts, compares traditional SQL, NoSQL and NewSQL, and provides an in‑depth overview of TiDB’s architecture, high‑availability design, HTAP capabilities, MySQL compatibility, configuration differences, and real‑world application scenarios.

HTAPMySQL compatibilityNewSQL
0 likes · 22 min read
What Is NewSQL? Exploring TiDB’s Distributed Database Features
Amap Tech
Amap Tech
May 27, 2025 · Databases

OceanBase Unitization: Building the Next Generation of Online Map Applications

This paper presents the design, implementation, and experimental evaluation of OceanBase's unitization architecture for large‑scale online map services, demonstrating superior disaster‑recovery, high‑throughput OLTP/OLAP performance, and storage efficiency compared with competing distributed databases.

OceanBaseOnline MapsPerformance Evaluation
0 likes · 24 min read
OceanBase Unitization: Building the Next Generation of Online Map Applications
Architect's Guide
Architect's Guide
May 8, 2025 · Databases

An Overview of TiDB: NewSQL Distributed Database Architecture, Features, and MySQL Compatibility

This article provides a comprehensive introduction to TiDB, a NewSQL distributed database, covering its origins, core components, high‑availability design, NewSQL characteristics, differences from traditional SQL and NoSQL, compatibility with MySQL, configuration nuances, and typical use cases such as HTAP and cloud‑native deployments.

Cloud NativeHTAPMySQL compatibility
0 likes · 20 min read
An Overview of TiDB: NewSQL Distributed Database Architecture, Features, and MySQL Compatibility
Selected Java Interview Questions
Selected Java Interview Questions
Feb 23, 2025 · Databases

TiDB Overview: Distributed NewSQL Database, Architecture, Features, and MySQL Compatibility

This article provides a comprehensive introduction to TiDB, a distributed NewSQL database that combines OLTP and OLAP capabilities, explains NewSQL concepts, compares traditional SQL, NoSQL and NewSQL, details TiDB's architecture and core components, highlights its high‑availability and scalability features, and outlines compatibility differences and practical use cases.

HTAPMySQL compatibilityNewSQL
0 likes · 21 min read
TiDB Overview: Distributed NewSQL Database, Architecture, Features, and MySQL Compatibility
MaGe Linux Operations
MaGe Linux Operations
Jan 17, 2025 · Databases

Understanding Redis Cluster: Architecture, Data Distribution, and Fault Tolerance

Redis Cluster provides a scalable, fault‑tolerant distributed Redis solution, explaining why it’s needed, its architecture, virtual slot partitioning, data distribution methods, limitations, smart client optimization, and automatic failover mechanisms, while highlighting key operational considerations for high‑performance deployments.

ClusterVirtual Slotsdata sharding
0 likes · 11 min read
Understanding Redis Cluster: Architecture, Data Distribution, and Fault Tolerance
IT Services Circle
IT Services Circle
Dec 15, 2024 · Databases

DBOS: A Database‑Oriented Operating System for Cloud Computing

The article explains how Databricks’ scaling challenges with PostgreSQL inspired the creation of DBOS, a database‑oriented operating system that places the OS beneath a distributed transactional database to simplify task scheduling, state management, and cloud‑native workloads.

DBOSKubernetesPostgreSQL
0 likes · 9 min read
DBOS: A Database‑Oriented Operating System for Cloud Computing
vivo Internet Technology
vivo Internet Technology
Dec 4, 2024 · Databases

OceanBase Implementation and Migration Practices at vivo

vivo migrated five 20‑TB MySQL clusters to OceanBase using OCP, oblogproxy, and OMS, eliminating sharding costs, achieving over 70% storage savings, improving consistency and performance, and leveraging native distributed architecture, tenant isolation, and strong compression to support scalable, reliable operations.

OceanBasedata compressiondatabase migration
0 likes · 16 min read
OceanBase Implementation and Migration Practices at vivo
Zhihu Tech Column
Zhihu Tech Column
Oct 28, 2024 · Databases

TiDB Architecture, Deployment Choices, and Zhihu’s Database Platform Practices

This article explains TiDB’s distributed relational database architecture, compares Kubernetes‑based and physical‑machine deployments, and describes Zhihu’s platform‑driven approach—including TiDB Operator, TiUP, self‑service tooling, monitoring, backup, security, and FinOps—to enable efficient database management for both developers and DBAs.

Data MigrationDatabase operationsFinOps
0 likes · 15 min read
TiDB Architecture, Deployment Choices, and Zhihu’s Database Platform Practices
Yum! Tech Team
Yum! Tech Team
Oct 17, 2024 · Databases

Leveraging Distributed Database Technology (TiDB) for Digital Transformation in the Restaurant Industry: A Joint Innovation Lab Case Study

This report examines how Yum China and PingCAP’s joint innovation lab applies TiDB’s distributed database capabilities—such as elastic scaling, real‑time analytics, HTAP architecture, and multi‑region high availability—to address the restaurant sector’s operational challenges, improve customer experience, and drive data‑driven business growth.

Digital TransformationHTAPTiDB
0 likes · 16 min read
Leveraging Distributed Database Technology (TiDB) for Digital Transformation in the Restaurant Industry: A Joint Innovation Lab Case Study
ITPUB
ITPUB
Aug 29, 2024 · Databases

How TeleDB Evolved from Centralized to Native Distributed Architecture

TeleDB’s journey from a centralized MySQL/PostgreSQL‑based system to a native distributed HTAP database showcases innovations such as share‑nothing architecture, columnar storage, vectorized execution, Remote Data Access, global caching, and advanced dead‑lock detection, dramatically improving query performance, storage efficiency, and scalability.

Columnar StorageHTAPTeleDB
0 likes · 13 min read
How TeleDB Evolved from Centralized to Native Distributed Architecture
Java High-Performance Architecture
Java High-Performance Architecture
Aug 28, 2024 · Databases

NewSQL vs Sharding: Which Database Architecture Truly Wins?

This article objectively compares NewSQL distributed databases with traditional middleware‑based sharding solutions, examining their architectural differences, transaction support, scalability, HA, storage engines, and ecosystem maturity, to help readers decide which approach best fits their performance, consistency, and operational needs.

HANewSQLScalability
0 likes · 18 min read
NewSQL vs Sharding: Which Database Architecture Truly Wins?
vivo Internet Technology
vivo Internet Technology
Jul 10, 2024 · Databases

HBase Optimization Practice in Vivo's Unified Content Platform

Vivo's unified content platform replaced its unwieldy 60 TB MongoDB store with HBase, then upgraded the cluster, introduced table‑specific connection pools, column‑only reads, tuned compaction, and leveraged multi‑version cells, cutting response times from seconds to under ten milliseconds and dramatically lowering operational costs while boosting read/write performance.

Columnar StorageCompaction OptimizationDatabase Optimization
0 likes · 16 min read
HBase Optimization Practice in Vivo's Unified Content Platform
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 27, 2024 · Databases

Evaluation of OceanBase Arbitration Service in a 2F1A Deployment: Fault Injection Experiments and Recovery Procedures

This article presents a detailed experimental study of OceanBase's Arbitration Service in a 2F1A (two full‑function replicas plus one arbitration node) configuration, examining how the system behaves when one or both full‑function replicas fail, how log‑stream degradation and permanent offline mechanisms work, and how normal service is restored after node recovery.

Arbitration ServiceFault InjectionOceanBase
0 likes · 17 min read
Evaluation of OceanBase Arbitration Service in a 2F1A Deployment: Fault Injection Experiments and Recovery Procedures
Architect's Guide
Architect's Guide
Jun 22, 2024 · Databases

Understanding TiDB: NewSQL Features, Architecture, and Comparison with MySQL and NoSQL

This article provides a comprehensive overview of TiDB, a cloud‑native NewSQL database that combines the scalability of NoSQL with the strong consistency of traditional relational databases, detailing its architecture, high‑availability design, HTAP capabilities, MySQL compatibility, and practical application scenarios.

Cloud NativeHTAPMySQL compatibility
0 likes · 23 min read
Understanding TiDB: NewSQL Features, Architecture, and Comparison with MySQL and NoSQL
Beijing SF i-TECH City Technology Team
Beijing SF i-TECH City Technology Team
Jun 18, 2024 · Databases

TiDB Operational Practices and Performance Benchmarking at Beijing Shunfeng Tongcheng Technology

This article presents a comprehensive case study of TiDB deployment at Beijing Shunfeng Tongcheng Technology, covering application scenarios, TiDB features, detailed performance benchmarks, operational challenges, optimization techniques, ecosystem tools, and best‑practice recommendations for large‑scale distributed database management.

ScalabilityTiDBdistributed database
0 likes · 19 min read
TiDB Operational Practices and Performance Benchmarking at Beijing Shunfeng Tongcheng Technology
Java High-Performance Architecture
Java High-Performance Architecture
May 12, 2024 · Databases

NewSQL vs Sharding: Which Database Architecture Truly Wins?

This article objectively compares NewSQL databases with middleware‑based sharding solutions, examining their architectural differences, transaction handling, scalability, high‑availability mechanisms, storage engines, and maturity to help readers decide which approach best fits their specific workload and business requirements.

CAP theoremNewSQLScalability
0 likes · 18 min read
NewSQL vs Sharding: Which Database Architecture Truly Wins?
Aikesheng Open Source Community
Aikesheng Open Source Community
May 8, 2024 · Databases

OceanBase DBA from Beginner to Practice: Comprehensive Tutorial and Learning Path

The OceanBase community offers a detailed, eight‑session DBA tutorial covering the platform’s architecture, deployment, migration, performance tuning, diagnostic tools, and ecosystem components, complemented by live streaming, hands‑on exercises, certification incentives, and real‑world user testimonials to help developers and DBAs master this distributed database.

Database AdministrationOceanBaseSQL
0 likes · 9 min read
OceanBase DBA from Beginner to Practice: Comprehensive Tutorial and Learning Path
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Apr 24, 2024 · Databases

How Does GaussDB Execute SQL? Inside Its Engine and Optimization

This article explains GaussDB's system architecture, the roles of GTM, CN, and DN, the SQL and storage engines, parsing stages, rule‑based and cost‑based optimizers (including AI‑based techniques), distributed query plans, execution operators, and the parallel execution framework that together enable high‑performance SQL processing in a cloud‑native distributed database.

Database ArchitectureGaussDBSQL Engine
0 likes · 15 min read
How Does GaussDB Execute SQL? Inside Its Engine and Optimization
Inke Technology
Inke Technology
Apr 23, 2024 · Databases

How We Scaled a High‑Traffic Messaging Service by Migrating MySQL to PolarDB

This article details the migration of a popular social app's private‑message service from a saturated MySQL cluster to PolarDB, covering business challenges, evaluation of storage‑optimization, vertical and horizontal scaling, the chosen distributed database solution, step‑by‑step offline and online migration procedures, and the resulting performance and cost benefits.

PolardbScalabilitydatabase migration
0 likes · 12 min read
How We Scaled a High‑Traffic Messaging Service by Migrating MySQL to PolarDB
Sohu Tech Products
Sohu Tech Products
Apr 10, 2024 · Databases

ShardingSphere-JDBC Database Sharding Tutorial Project

The tutorial project showcases how to implement database sharding with ShardingSphere-JDBC (versions 4 and 5) in a SpringBoot O2O order service, providing modules for sharding, a gRPC ID generator, detailed configuration of four data sources, sharding algorithms, and Swagger-based testing of order creation and queries.

ShardingSphere-JDBCSpringBootdatabase scaling
0 likes · 5 min read
ShardingSphere-JDBC Database Sharding Tutorial Project
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 9, 2024 · Databases

OceanBase DBA: From Beginner to Practice – Comprehensive Tutorial Series and E‑Book

OceanBase, a distributed open‑source database, offers a free e‑book and an eight‑session tutorial series covering installation, migration, operation, performance tuning, diagnostics, and ecosystem tools such as OCP, OMS, ODC, and obdiag, aimed at students, developers, and DBAs seeking practical skills and certification.

DBAOceanBaseTutorial
0 likes · 10 min read
OceanBase DBA: From Beginner to Practice – Comprehensive Tutorial Series and E‑Book
Selected Java Interview Questions
Selected Java Interview Questions
Apr 1, 2024 · Databases

Understanding NewSQL and TiDB: Architecture, Features, and Comparison with Traditional Databases

TiDB, an open‑source NewSQL distributed database, combines the strong consistency and ACID guarantees of traditional relational databases with the scalability of NoSQL, offering cloud‑native architecture, HTAP capabilities, high availability, and seamless MySQL compatibility, while highlighting NewSQL concepts, design trade‑offs, and migration scenarios.

Cloud NativeHTAPMySQL compatibility
0 likes · 22 min read
Understanding NewSQL and TiDB: Architecture, Features, and Comparison with Traditional Databases
DataFunTalk
DataFunTalk
Mar 17, 2024 · Databases

MatrixOne Storage Format Design Overview

This article provides a comprehensive overview of MatrixOne's hyper‑converged cloud‑native database architecture, detailing its three‑layer design, data execution flow, columnar storage format, metadata hierarchy, performance optimizations, compatibility mechanisms, and practical usage scenarios.

CompatibilityMatrixOneStorage Engine
0 likes · 12 min read
MatrixOne Storage Format Design Overview
Didi Tech
Didi Tech
Mar 5, 2024 · Databases

Migrating Didi's Log Retrieval from Elasticsearch to ClickHouse: Architecture, Challenges, and Performance Optimizations

Didi replaced its Elasticsearch‑based log platform with ClickHouse, redesigning architecture into isolated Log and Trace clusters, using hourly‑partitioned MergeTree tables and aggregating views to handle petabyte‑scale writes, diverse low‑latency queries, and high QPS, achieving over 400 nodes, 40 GB/s throughput, 30 % cost savings and four‑fold query latency reduction.

Big DataClickHouseElasticsearch
0 likes · 15 min read
Migrating Didi's Log Retrieval from Elasticsearch to ClickHouse: Architecture, Challenges, and Performance Optimizations
Baidu Geek Talk
Baidu Geek Talk
Mar 4, 2024 · Databases

Bank Core System Transformation and GaiaDB-X Distributed Database Solutions for Financial Scenarios

To meet exploding transaction volumes, rapid innovation cycles, and strict regulatory demands, large banks are replacing mainframe core systems with distributed, horizontally‑scalable architectures, and Baidu’s GaiaDB‑X database—offering strong ACID consistency, zero‑RPO disaster recovery, and automated operations—has successfully powered core banking migrations for institutions such as Bank of China and state‑owned banks.

GaiaDB-XTSO consistencybank core system
0 likes · 26 min read
Bank Core System Transformation and GaiaDB-X Distributed Database Solutions for Financial Scenarios
21CTO
21CTO
Mar 1, 2024 · Databases

Why Oracle 23c’s Global Distributed Database Is a Game-Changer for Multi‑Region Data

The article examines Oracle’s evolution from RAC‑based sharding to the 23c Global Distributed Database, highlighting its RAFT replication, cross‑region capabilities, compliance benefits, and performance advantages that position it as a true multi‑cloud, multi‑location solution for modern OLTP workloads.

OracleRaftdata localization
0 likes · 7 min read
Why Oracle 23c’s Global Distributed Database Is a Game-Changer for Multi‑Region Data
IT Services Circle
IT Services Circle
Feb 8, 2024 · Databases

TiDB Overview: Architecture, Core Features, and Performance Compared with MySQL

The article explains why traditional MySQL sharding is discouraged, introduces the distributed database TiDB, details its architecture, core capabilities such as HTAP and Raft‑based consistency, compares feature support and resource usage with MySQL, and presents benchmark results demonstrating TiDB’s advantages at large scale.

HTAPMySQL ComparisonRaft
0 likes · 12 min read
TiDB Overview: Architecture, Core Features, and Performance Compared with MySQL
DataFunTalk
DataFunTalk
Dec 17, 2023 · Databases

Evolution of MatrixOne: From NewSQL/MPP Roots to a Modern HTAP Architecture

This article introduces the open‑source distributed database MatrixOne, tracing its early NewSQL/MPP architecture, the challenges that prompted a major redesign, and the resulting HTAP‑oriented three‑layer architecture with decoupled compute, transaction, and storage layers, highlighting performance, cost, and scalability improvements.

HTAPMatrixOneStorage Engine
0 likes · 22 min read
Evolution of MatrixOne: From NewSQL/MPP Roots to a Modern HTAP Architecture
DataFunSummit
DataFunSummit
Nov 2, 2023 · Databases

Understanding TiKV: Features, Architecture, and Large‑Scale Operational Challenges

This article introduces the distributed transactional KV store TiKV, explains its role as TiDB’s storage engine, details its multi‑layered architecture and Raft‑based consistency model, and discusses the performance and resource challenges encountered at massive data scales along with the engineering solutions implemented to address them.

Performance OptimizationRaftTiKV
0 likes · 14 min read
Understanding TiKV: Features, Architecture, and Large‑Scale Operational Challenges
DataFunTalk
DataFunTalk
Oct 17, 2023 · Databases

Evolution of MatrixOne: From NewSQL MPP to a Modern HTAP Architecture

This article details the evolution of the open‑source distributed database MatrixOne, describing its early NewSQL/MPP design, the scalability, performance and cost challenges it faced, and the architectural redesign that introduced decoupled compute, transaction, and storage layers with HTAP support using TAE, S3, and Logtail.

ComputeHTAPMatrixOne
0 likes · 20 min read
Evolution of MatrixOne: From NewSQL MPP to a Modern HTAP Architecture
DataFunTalk
DataFunTalk
Oct 14, 2023 · Databases

Abase2 Multi‑Region Deployment and CRDT Support: Architecture, Challenges, and Redis Command Compatibility

This article explains how Abase2 enables multi‑region deployment for a high‑scale NoSQL database by adopting CRDT technology, detailing the challenges of cross‑region consistency, the evolution of Abase's architecture, and the engineering solutions that provide Redis‑compatible CRDT command support with low latency and strong eventual consistency.

Abase2CRDTNoSQL
0 likes · 15 min read
Abase2 Multi‑Region Deployment and CRDT Support: Architecture, Challenges, and Redis Command Compatibility
Java Architect Essentials
Java Architect Essentials
Oct 12, 2023 · Databases

TiDB Overview: Architecture, Features, Compatibility, and Use Cases

This article provides a comprehensive overview of TiDB, an open‑source distributed NewSQL database, covering its origins, architecture components, high‑availability design, HTAP capabilities, MySQL compatibility, differences from traditional SQL and NoSQL, and practical deployment scenarios.

Cloud NativeDatabase ArchitectureHTAP
0 likes · 22 min read
TiDB Overview: Architecture, Features, Compatibility, and Use Cases
Tencent Cloud Developer
Tencent Cloud Developer
Sep 13, 2023 · Cloud Native

Designing and Implementing a Payment Fund Account System

The article details how to design and implement a cloud‑native payment fund account system on Tencent Cloud, covering account definitions, fund flow and multiple account types, TDSQL storage, separated fund and account services, robust security, distributed transactions, auditing, reconciliation, and high‑availability measures for high‑concurrency merchant payments.

AvailabilityConsistencySecurity
0 likes · 35 min read
Designing and Implementing a Payment Fund Account System
Java Architect Essentials
Java Architect Essentials
Sep 10, 2023 · Databases

Why TiDB Is the NewSQL Database Redefining OLTP & OLAP

This article provides a comprehensive technical overview of NewSQL concepts and TiDB, covering its origins, core features, distributed architecture, high‑availability design, MySQL compatibility, unsupported MySQL functionalities, configuration defaults, and real‑world application scenarios for both OLTP and OLAP workloads.

HTAPMySQL compatibilityNewSQL
0 likes · 24 min read
Why TiDB Is the NewSQL Database Redefining OLTP & OLAP
ITPUB
ITPUB
Aug 23, 2023 · Databases

Why TiDB Is the Leading NewSQL Database for HTAP Workloads

TiDB is an open‑source NewSQL database that combines horizontal scalability, strong ACID guarantees, MySQL compatibility, and cloud‑native design to support both OLTP and OLAP workloads, offering high availability and real‑time HTAP capabilities for large‑scale applications.

Cloud NativeHTAPMySQL compatibility
0 likes · 22 min read
Why TiDB Is the Leading NewSQL Database for HTAP Workloads
MaGe Linux Operations
MaGe Linux Operations
Aug 10, 2023 · Databases

What Is NewSQL? Exploring TiDB’s Distributed Database Features

This article explains the evolution from traditional SQL and NoSQL to NewSQL, outlines the limitations of each, and provides an in‑depth look at TiDB—a cloud‑native, distributed NewSQL database—covering its architecture, core features, high‑availability design, compatibility with MySQL, and typical use cases.

Database ArchitectureHTAPMySQL compatibility
0 likes · 24 min read
What Is NewSQL? Exploring TiDB’s Distributed Database Features
Amap Tech
Amap Tech
Aug 1, 2023 · Databases

Gaode’s Adoption of OceanBase: Architecture, Practices, and Future Roadmap

Gaode migrated its core navigation, traffic, and financial services to OceanBase, leveraging Paxos‑based multi‑replica consistency, LSM‑Tree storage, and distributed transactions, selecting multi‑point write for massive sync workloads and central‑write for latency‑critical queries, achieving sub‑millisecond latency, significant storage savings, and a roadmap toward broader cost‑effective, serverless deployment.

Cloud NativeOceanBaseScalability
0 likes · 58 min read
Gaode’s Adoption of OceanBase: Architecture, Practices, and Future Roadmap
Top Architect
Top Architect
Jul 31, 2023 · Databases

TiDB Overview: NewSQL Features, Architecture, Compatibility, and Application Scenarios

This article provides a comprehensive introduction to TiDB, a distributed NewSQL database, covering the evolution from traditional SQL to NoSQL, NewSQL characteristics, TiDB’s origin, core components, high‑availability design, cloud‑native architecture, compatibility with MySQL, unsupported features, and typical use cases such as sharding, data warehousing, and HTAP workloads.

HTAPMySQL compatibilityNewSQL
0 likes · 24 min read
TiDB Overview: NewSQL Features, Architecture, Compatibility, and Application Scenarios
DataFunSummit
DataFunSummit
Jul 26, 2023 · Databases

Deep Dive into OceanBase HTAP Capabilities and Architecture

This article provides a comprehensive overview of OceanBase, an open‑source distributed database, detailing its evolution, core HTAP features, multi‑tenant architecture, execution engine optimizations, advanced query optimizer, storage engine design, resource isolation mechanisms, fast import capabilities, and performance benchmarks.

Execution EngineHTAPOceanBase
0 likes · 22 min read
Deep Dive into OceanBase HTAP Capabilities and Architecture
Su San Talks Tech
Su San Talks Tech
Jul 24, 2023 · Databases

How TiDB’s NewSQL Design Solves Traditional Database Limits

This article explains the evolution from traditional SQL to NewSQL, outlines the shortcomings of classic relational databases and NoSQL, and details TiDB’s architecture, core features, high‑availability design, and practical use cases as a cloud‑native, MySQL‑compatible HTAP solution.

Cloud NativeHTAPMySQL compatibility
0 likes · 28 min read
How TiDB’s NewSQL Design Solves Traditional Database Limits
Didi Tech
Didi Tech
Jul 5, 2023 · Databases

Performance Optimization of ClickHouse: Identifying and Fixing High CPU Usage in BgMoveProcPool Threads

By adding a guard that skips the costly part‑scan in MergeTreePartsMover::selectPartsForMove when disk usage is below the threshold and no MoveTTL is set, Didi reduced BgMoveProcPool thread CPU consumption from about 30 % to under 4 %, halving overall node CPU load and improving ClickHouse’s PB‑scale performance.

BgMoveProcPoolCPUClickHouse
0 likes · 10 min read
Performance Optimization of ClickHouse: Identifying and Fixing High CPU Usage in BgMoveProcPool Threads
21CTO
21CTO
Apr 25, 2023 · Databases

How Baidu’s PegaDB Redefines Redis with Low‑Cost, High‑Capacity KV Storage

This article summarizes Liu Donghui’s presentation at DTCC2022, detailing Baidu Intelligent Cloud’s Redis‑compatible, high‑capacity, low‑cost PegaDB, covering its design goals, architecture, KV storage engine choices, cluster scaling, replication enhancements, performance optimizations, multi‑region active‑active support, and future roadmap.

KV storagePegaDBPerformance Optimization
0 likes · 17 min read
How Baidu’s PegaDB Redefines Redis with Low‑Cost, High‑Capacity KV Storage
Baidu Intelligent Cloud Tech Hub
Baidu Intelligent Cloud Tech Hub
Apr 25, 2023 · Databases

How Baidu’s PegaDB Redefines Redis with Low‑Cost, High‑Capacity Storage

This article details Baidu Cloud's PegaDB—a Redis‑compatible, high‑capacity, low‑cost distributed KV store—covering its design choices, architecture, performance and replication optimizations, multi‑region active‑active support, native JSON model, community contributions, and future roadmap.

Low-Cost StoragePegaDBdistributed database
0 likes · 16 min read
How Baidu’s PegaDB Redefines Redis with Low‑Cost, High‑Capacity Storage
Su San Talks Tech
Su San Talks Tech
Apr 11, 2023 · Databases

Why TiDB Leads the NewSQL Landscape for HTAP and Cloud‑Native Workloads

This article explains the evolution from traditional SQL to NewSQL, outlines the limitations of classic relational and NoSQL databases, and details TiDB's architecture, core features, high‑availability design, compatibility with MySQL, and real‑world use cases for both OLTP and OLAP workloads.

Cloud NativeHTAPNewSQL
0 likes · 24 min read
Why TiDB Leads the NewSQL Landscape for HTAP and Cloud‑Native Workloads
Code Ape Tech Column
Code Ape Tech Column
Mar 28, 2023 · Databases

Understanding TiDB: NewSQL Features, Architecture, and Comparison with MySQL

This article provides a comprehensive overview of TiDB, a NewSQL distributed database, covering its origins, core features such as horizontal scaling, ACID transactions, HTAP support, cloud‑native design, MySQL compatibility, architectural components, high‑availability mechanisms, application scenarios, and differences from traditional MySQL implementations.

HTAPMySQL compatibilityNewSQL
0 likes · 26 min read
Understanding TiDB: NewSQL Features, Architecture, and Comparison with MySQL
ITPUB
ITPUB
Feb 24, 2023 · Databases

How Ctrip Migrated MySQL to OceanBase: Tools, Process, and Lessons Learned

Ctrip evaluated and extended OceanBase Migration Assessment tools, built a one‑click migration workflow, implemented comprehensive monitoring and automatic fault‑diagnosis pipelines, and addressed compatibility challenges such as .NET charset issues and Druid parser errors, ultimately achieving a smooth MySQL‑to‑OceanBase transition.

OceanBasePerformance Diagnosisdatabase migration
0 likes · 18 min read
How Ctrip Migrated MySQL to OceanBase: Tools, Process, and Lessons Learned
Ctrip Technology
Ctrip Technology
Feb 2, 2023 · Databases

MySQL to OceanBase Migration: Evaluation Tools, Migration Process, Monitoring, and Automated Fault Diagnosis

This article details Ctrip's experience migrating MySQL workloads to the distributed OceanBase database, covering the design of an assessment tool, a one‑click migration workflow, comprehensive monitoring dashboards, automated fault‑diagnosis pipelines, encountered compatibility issues, and future roadmap for the platform.

Database MonitoringFault DiagnosisMySQL Migration
0 likes · 17 min read
MySQL to OceanBase Migration: Evaluation Tools, Migration Process, Monitoring, and Automated Fault Diagnosis
HomeTech
HomeTech
Feb 1, 2023 · Databases

TiDB Database Deployment and Operational Practices at AutoHome

This article presents a comprehensive case study of TiDB, an open‑source distributed relational database, detailing its features, architecture, evolution within AutoHome, key business applications such as recommendation pools, financial reporting, and interactive events, as well as the automated operations and troubleshooting practices adopted to ensure high availability and scalability.

AutohomeDatabase operationsHTAP
0 likes · 6 min read
TiDB Database Deployment and Operational Practices at AutoHome
dbaplus Community
dbaplus Community
Jan 29, 2023 · Databases

Why Single‑Node MySQL Is Dying and Distributed Databases Are the Future

The article explains how single‑instance MySQL struggles with huge tables, resource‑starved databases, and high read traffic, and argues that sharding middleware is being replaced by modern distributed databases such as TiDB, OceanBase, Aurora, and PolarDB as the sustainable scaling solution.

Database Architecturedistributed databasemysql
0 likes · 9 min read
Why Single‑Node MySQL Is Dying and Distributed Databases Are the Future
Java Backend Technology
Java Backend Technology
Dec 29, 2022 · Databases

Why MySQL Must Evolve: From Single‑Node Limits to Distributed Databases

The article explains how traditional single‑node MySQL faces scalability challenges such as massive tables, resource exhaustion, and read‑heavy workloads, and argues that adopting sharding, middleware, or modern distributed databases like TiDB, OceanBase, Aurora, and PolarDB is the inevitable path forward for robust data management.

cloud databasedatabase scalingdistributed database
0 likes · 6 min read
Why MySQL Must Evolve: From Single‑Node Limits to Distributed Databases
macrozheng
macrozheng
Dec 28, 2022 · Databases

Why Single‑Node MySQL Won’t Scale and How to Move to Distributed Databases

The article explains the limitations of standalone MySQL, outlines common scaling problems such as oversized tables and high read traffic, and compares middleware‑based sharding solutions with modern distributed databases, highlighting why the latter are becoming the preferred choice for growing applications.

database scalingdistributed databasemiddleware
0 likes · 6 min read
Why Single‑Node MySQL Won’t Scale and How to Move to Distributed Databases
DeWu Technology
DeWu Technology
Dec 16, 2022 · Databases

TiDB Adoption and Operational Practices at Dewu

Dewu transitioned from a single‑instance MySQL setup to a distributed TiDB architecture—using three TiDB, PD, and TiKV/TiFlash nodes, automated backups, Prometheus monitoring, and chaos‑engineering controls—which delivered linear scalability, eliminated slow queries, cut infrastructure costs by about 58 % and maintained stable performance during major sales events.

MySQL ComparisonTiDBdistributed database
0 likes · 28 min read
TiDB Adoption and Operational Practices at Dewu
iQIYI Technical Product Team
iQIYI Technical Product Team
Dec 16, 2022 · Databases

Database Mesh 2.0 and Pisanix: Cloud‑Native Database Governance at iQIYI

iQIYI adopts SphereEx’s Database Mesh 2.0 by extending ShardingSphere‑JDBC and integrating the cloud‑native Pisanix proxy, creating a unified, encrypted configuration center that enables dynamic sharding, load‑balancing, read‑write separation, hot‑updates and observability, dramatically simplifying database governance and cloud migration.

Data GovernanceDatabase MeshPisanix
0 likes · 14 min read
Database Mesh 2.0 and Pisanix: Cloud‑Native Database Governance at iQIYI
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 14, 2022 · Databases

Understanding User and Role Management in Cassandra Clusters Across Data Centers

This article explains how Cassandra clusters organize nodes, racks, and data centers, describes the gossip and snitch protocols, token ring architecture, replication strategies, and provides step‑by‑step commands to create, list, and delete users and roles while highlighting cross‑data‑center visibility constraints and common errors.

CQLData centerNoSQL
0 likes · 12 min read
Understanding User and Role Management in Cassandra Clusters Across Data Centers
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 28, 2022 · Databases

Recovering a Deleted Greenplum Standby Node: Analysis and Step‑by‑Step Procedure

This article describes the background, architecture, and a detailed troubleshooting process for restoring a mistakenly deleted Greenplum standby data directory, including status checks, configuration cleanup, standby initialization, verification commands, and additional recommendations for handling master failures in a distributed database cluster.

Database AdministrationGreenplumStandby Recovery
0 likes · 10 min read
Recovering a Deleted Greenplum Standby Node: Analysis and Step‑by‑Step Procedure
Tencent Cloud Developer
Tencent Cloud Developer
Nov 18, 2022 · Databases

How CDW PG Optimizer Finds Optimal Join Order for Multi-Table Queries

CDW PG’s optimizer determines the most efficient join order for multi‑table OLAP queries by combining bottom‑up dynamic programming for smaller joins with a genetic algorithm for larger ones, while jointly selecting scan paths, join algorithms, and data‑distribution strategies to minimize execution cost.

CDW PGJOIN optimizationMPP architecture
0 likes · 9 min read
How CDW PG Optimizer Finds Optimal Join Order for Multi-Table Queries
Tencent Cloud Developer
Tencent Cloud Developer
Nov 11, 2022 · Databases

How KeeWiDB Solves Redis’s Memory Cost with Tiered Storage & Async I/O

KeeWiDB, a next‑generation distributed KV store from Tencent Cloud, combines a proxy layer, multi‑node service layer, tiered hot‑cold data placement, multi‑threaded and coroutine‑based processing, persistent memory caching, direct I/O, and enhanced replication to address Redis’s memory cost, scalability, and latency challenges.

Async IOKV StoreReplication
0 likes · 18 min read
How KeeWiDB Solves Redis’s Memory Cost with Tiered Storage & Async I/O
DeWu Technology
DeWu Technology
Nov 11, 2022 · Databases

TiDB Overview: Architecture, Storage Model, and Execution Plan

TiDB is an open‑source, MySQL‑compatible distributed database that unifies OLTP and OLAP by using a stateless SQL layer, a Placement Driver for metadata and Raft‑managed TiKV/TiFlash storage, key‑value mapping with RocksDB, and a push‑down execution engine that splits work between coprocessor and root tasks for scalable, highly available workloads.

HTAPSQL Execution PlanStorage Engine
0 likes · 17 min read
TiDB Overview: Architecture, Storage Model, and Execution Plan
AntTech
AntTech
Sep 30, 2022 · Databases

OceanBase: Distributed Architecture, High‑Performance Storage Engine, Paxos‑Based 2PC, and Record‑Breaking TPC‑C Benchmarks

The article reviews OceanBase's distributed relational database design, its integrated architecture, high‑compression LSM‑tree storage engine, Paxos‑enhanced two‑phase commit protocol, and how these innovations enabled the system to set successive world records in the TPC‑C benchmark, illustrating China's growing database capabilities.

Database PerformanceOceanBasePaxos
0 likes · 18 min read
OceanBase: Distributed Architecture, High‑Performance Storage Engine, Paxos‑Based 2PC, and Record‑Breaking TPC‑C Benchmarks
Baidu Geek Talk
Baidu Geek Talk
Sep 29, 2022 · Databases

Design and Challenges of TafDB: A Scalable Metadata Storage Engine for Cloud Data Lakes

TafDB, Baidu’s Spanner‑like distributed transaction database built on RocksDB and Multi‑Raft, provides a virtually unlimited metadata layer for cloud data lakes by unifying hierarchical and flat namespaces, minimizing cross‑shard transaction overhead, handling garbage collection, and employing a distributed clock, thus delivering trillion‑scale metadata capacity and tens of millions of QPS with low latency.

NamespaceScalabilityTafDB
0 likes · 21 min read
Design and Challenges of TafDB: A Scalable Metadata Storage Engine for Cloud Data Lakes
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Sep 26, 2022 · Databases

Mastering Horizontal Scaling with TDSQL: Design, Practices, and Performance

This article explains the motivations, challenges, and design principles of horizontal scaling for databases, using TDSQL as a case study to illustrate architecture, scaling procedures, shard key selection, high‑availability mechanisms, distributed transactions, and performance optimization techniques.

Performance OptimizationTDSQLdistributed database
0 likes · 24 min read
Mastering Horizontal Scaling with TDSQL: Design, Practices, and Performance
JavaEdge
JavaEdge
Sep 7, 2022 · Databases

Understanding HBase: Architecture, Data Model, and Read/Write Mechanics

This article provides a comprehensive overview of HBase, covering its column‑oriented design, core components such as HMaster, RegionServer and ZooKeeper, the data model with column families and row keys, and detailed step‑by‑step write and read processes for distributed storage.

Big DataHBaseNoSQL
0 likes · 16 min read
Understanding HBase: Architecture, Data Model, and Read/Write Mechanics
Alimama Tech
Alimama Tech
Aug 24, 2022 · Artificial Intelligence

Distributed High‑Performance Vector Retrieval with gpdb‑faiss‑vector Plugin on Dolphin Engine

The gpdb‑faiss‑vector plugin embeds Facebook’s Faiss library into the Dolphin (Greenplum‑compatible) engine, exposing SQL functions for distributed, high‑performance approximate nearest‑neighbor vector retrieval with caching, parallel search, configurable indexes, and sub‑millisecond latency, enabling scalable recommendation and advertising workloads.

AIFAISSSQL
0 likes · 15 min read
Distributed High‑Performance Vector Retrieval with gpdb‑faiss‑vector Plugin on Dolphin Engine
AntTech
AntTech
Aug 23, 2022 · Databases

OceanBase 4.0 Core Technology Overview

The OceanBase 4.0 core technology presentation recounts twelve years of evolution from the early 0.1 version to a single-node distributed integrated database, highlighting breakthroughs such as sub-8-second RTO, RPO = 0, Paxos three-replica high availability, and competitive performance in TPC-C and TPC-H benchmarks.

MySQL compatibilityOceanBasePaxos
0 likes · 8 min read
OceanBase 4.0 Core Technology Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 23, 2022 · Databases

DBLE Cache Mechanism: Primary‑Key Routing Issue, Diagnosis and Resolution

This article examines the DBLE distributed database middleware cache, reproduces a primary‑key update query that returns incomplete results due to stale routing cache, analyzes cache contents via the management console, explains the cache’s behavior and limitations, and shows how disabling the primary‑key cache restores correct query routing.

CacheDBLESQL Routing
0 likes · 10 min read
DBLE Cache Mechanism: Primary‑Key Routing Issue, Diagnosis and Resolution
StarRocks
StarRocks
Apr 24, 2022 · Databases

How StarRocks Transforms a SQL Query into Distributed Execution: A Deep Dive

This article explains how StarRocks converts a SQL statement into an optimal distributed physical execution plan, schedules the plan across compute nodes, and runs it using MPP, pipeline parallelism, and vectorized execution to achieve near‑linear performance scaling.

CBO optimizerMPPSQL query processing
0 likes · 15 min read
How StarRocks Transforms a SQL Query into Distributed Execution: A Deep Dive
DataFunTalk
DataFunTalk
Jan 3, 2022 · Databases

Pegasus: Architecture, New Features, Ecosystem, and Community Overview

This article introduces Pegasus, a distributed key‑value store, covering its background, system architecture, double‑WAL design, performance benchmarks, recent features such as hot backup, bulk load, access control, partition split, as well as its ecosystem tools and community development plans.

Big DataHot BackupPEGASUS
0 likes · 12 min read
Pegasus: Architecture, New Features, Ecosystem, and Community Overview
High Availability Architecture
High Availability Architecture
Dec 7, 2021 · Databases

Efficiency Choice: NetEase Internal Evaluation of Distributed Database TiDB

NetEase’s DBA team presents a comprehensive analysis comparing TiDB‑based innovative architecture with the traditional MySQL + DDB stack, detailing business fit, cost reduction, technical innovation, scalability, high availability, HTAP capabilities, migration strategies, and practical deployment experiences to justify adopting TiDB as a next‑generation distributed database solution.

HTAPTiDBdistributed database
0 likes · 35 min read
Efficiency Choice: NetEase Internal Evaluation of Distributed Database TiDB
Java Interview Crash Guide
Java Interview Crash Guide
Dec 2, 2021 · Databases

How Zhihu Scaled to Trillions of Rows with TiDB – Real‑Time Query Performance Insights

Zhihu’s Moneta service stores over a trillion rows and faces massive write and read loads; this article explains why TiDB was chosen, how its architecture and features such as HTAP, Raft, Titan and table partitioning enable millisecond‑level query latency, high availability, and seamless scaling.

HTAPPerformance OptimizationScalability
0 likes · 15 min read
How Zhihu Scaled to Trillions of Rows with TiDB – Real‑Time Query Performance Insights
DataFunSummit
DataFunSummit
Nov 13, 2021 · Cloud Native

Designing Cloud‑Native Distributed Database Architecture: Insights from TiDB

This article explores how to design a cloud‑native distributed database architecture using TiDB as a case study, discussing cost reduction, storage choices, compute‑storage separation, fault tolerance, scaling strategies, and the trade‑offs of caching and persistent storage in modern cloud environments.

ScalabilityTiDBarchitecture
0 likes · 15 min read
Designing Cloud‑Native Distributed Database Architecture: Insights from TiDB
Programmer DD
Programmer DD
Oct 24, 2021 · Databases

OceanBase Star Buying Scandal: Is China’s Top Database Purchasing GitHub Stars?

The article outlines OceanBase’s evolution into an open‑source, HTAP‑capable distributed database, then details allegations that its community engaged in purchasing GitHub stars, including screenshots of incentive messages, sparking debate over the ethics of star‑inflation in Chinese open‑source projects.

GitHub StarsOceanBasedistributed database
0 likes · 5 min read
OceanBase Star Buying Scandal: Is China’s Top Database Purchasing GitHub Stars?
Baidu Intelligent Testing
Baidu Intelligent Testing
Sep 28, 2021 · Databases

Design and Evolution of BaikalDB: A Cloud‑Native Distributed Database for Commercial Advertising Systems

This article examines the business storage requirements of large‑scale advertising platforms and details how BaikalDB was architected as a cloud‑native, MySQL‑compatible distributed database that combines OLTP, OLAP, KV and full‑text capabilities while ensuring high reliability, low cost and linear scalability.

AdvertisingBaikalDBCloud Native
0 likes · 24 min read
Design and Evolution of BaikalDB: A Cloud‑Native Distributed Database for Commercial Advertising Systems
HomeTech
HomeTech
Sep 1, 2021 · Databases

Case Study: TiDB Deployment for the 2021 "818 Global Auto Festival"

This case study details how Car Home leveraged TiDB 5.1.1 with a three‑data‑center, five‑replica HTAP architecture to support the high‑traffic 818 Global Auto Festival, covering background, business requirements, database selection, system design, performance challenges, solutions, and post‑event insights.

HTAPPerformance TestingTiCDC
0 likes · 11 min read
Case Study: TiDB Deployment for the 2021 "818 Global Auto Festival"