BestHub
Sign in
Tagged articles
215 articles
Page 2 of 3
Java Architecture Diary
Java Architecture Diary
Aug 30, 2021 · Databases

How to Build a High‑Availability GreatSQL MGR Cluster with Docker‑Compose

This article explains the role of distributed architecture for high‑performance internet systems, introduces GreatSQL as a native distributed relational database, compares it with MySQL, and provides step‑by‑step Docker‑Compose instructions to set up, start, and verify a three‑node MGR cluster, plus integration with the PIG microservice platform.

Docker ComposeGreatSQLMGR
0 likes · 8 min read
How to Build a High‑Availability GreatSQL MGR Cluster with Docker‑Compose
Trip Tech Team
Trip Tech Team
Aug 12, 2021 · Databases

Unlocking HTAP: Inside TiDB, TiKV, RocksDB, and LevelDB Architecture

This article introduces TiDB’s hybrid transactional‑analytical processing capabilities, explains TiKV’s region‑based storage built on RocksDB, and provides a detailed overview of RocksDB and LevelDB architectures, including their data structures, write‑read flows, and key optimizations for modern distributed database systems.

HTAPKV storageLevelDB
0 likes · 16 min read
Unlocking HTAP: Inside TiDB, TiKV, RocksDB, and LevelDB Architecture
Baidu Geek Talk
Baidu Geek Talk
Aug 9, 2021 · Databases

BaikalDB Implementation Practice at Tongcheng Yilong: High Availability, HTAP, Performance and Cost Optimization

Tongcheng Yilong’s BaikalDB deployment combines high‑availability multi‑Raft HA, HTAP support, and share‑nothing scalability to deliver over 72K TPS OLTP and ten‑fold faster OLAP queries while cutting operational costs up to a hundredfold through dual‑center, columnar storage and cloud‑native elasticity.

BaikalDBColumnar StorageHTAP
0 likes · 27 min read
BaikalDB Implementation Practice at Tongcheng Yilong: High Availability, HTAP, Performance and Cost Optimization
Baidu Geek Talk
Baidu Geek Talk
Aug 4, 2021 · Databases

How Baidu’s BaikalDB Redefined Distributed Storage for Massive Ad Platforms

This article analyzes the evolution of Baidu's advertising data storage, detailing the business-driven requirements, the design and development of the BaikalDB distributed database, its architecture across storage, compute and scheduling layers, key features such as Raft replication and multi‑index support, and the lessons learned for building cloud‑native, high‑performance databases.

BaikalDBCloud NativeRaft replication
0 likes · 27 min read
How Baidu’s BaikalDB Redefined Distributed Storage for Massive Ad Platforms
Architecture Digest
Architecture Digest
Jun 21, 2021 · Databases

Using HBase for HR Performance Data Preprocessing Platform: Architecture, Concepts, and Best Practices

This article introduces the HR performance data preprocessing platform’s requirements, explains why HBase was selected as the storage solution, details its core concepts, architecture, data write/read processes, best practices, limitations, and presents performance metrics demonstrating its suitability for large‑scale, high‑throughput workloads.

Big DataDatabase ArchitectureHBase
0 likes · 12 min read
Using HBase for HR Performance Data Preprocessing Platform: Architecture, Concepts, and Best Practices
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Jun 20, 2021 · Big Data

Why HBase Is the Ideal Choice for Large‑Scale HR Data Preprocessing

This article explains how HBase’s distributed column‑oriented architecture, high‑performance read/write capabilities, and flexible schema make it a cost‑effective solution for handling massive, unstructured HR performance data, covering its core concepts, cluster operation, best practices, and performance metrics.

Big DataHBasedata preprocessing
0 likes · 11 min read
Why HBase Is the Ideal Choice for Large‑Scale HR Data Preprocessing
Alibaba Cloud Developer
Alibaba Cloud Developer
May 27, 2021 · Databases

How OceanBase Set a New TPC‑H Record and the Future of HTAP Databases

OceanBase achieved a world‑record TPC‑H performance of 15.26 million QphH, illustrating its HTAP capabilities and detailing the technical evolution, challenges, and future direction of hybrid transactional/analytical processing in modern distributed databases.

Database PerformanceHTAPHybrid Transactional Analytical Processing
0 likes · 18 min read
How OceanBase Set a New TPC‑H Record and the Future of HTAP Databases
AntTech
AntTech
May 21, 2021 · Databases

OceanBase HTAP: Technical Insights Behind the TPC‑H World Record

This article explains how OceanBase, a distributed relational database, achieved a new TPC‑H world record, discusses the evolution of HTAP technology, the architectural challenges of combining transactional and analytical workloads, and the future direction of the product.

HTAPHybrid Transactional Analytical ProcessingOceanBase
0 likes · 17 min read
OceanBase HTAP: Technical Insights Behind the TPC‑H World Record
Alibaba Cloud Developer
Alibaba Cloud Developer
May 21, 2021 · Databases

How OceanBase Crushed the TPC‑H Benchmark with HTAP Innovation

OceanBase, the distributed relational database from Ant Group, set a new TPC‑H world record by leveraging its HTAP architecture, blending transaction and analytical processing, and the article details the technical evolution, challenges, and future direction of this hybrid database technology.

HTAPHybrid ProcessingOceanBase
0 likes · 17 min read
How OceanBase Crushed the TPC‑H Benchmark with HTAP Innovation
Tencent Cloud Developer
Tencent Cloud Developer
May 13, 2021 · Databases

Practice of Distributed Database Architecture in WeBank's Core Systems

WeBank replaced traditional IOE systems with a Tencent‑based distributed platform using TDSQL and a unitized DCN architecture, where each Data Center Node serves a fixed user base, enabling linear horizontal scaling, fault isolation, rapid provisioning, and simplified single‑instance databases while handling billions of daily transactions.

DCN architectureDatabase TrendsTDSQL
0 likes · 18 min read
Practice of Distributed Database Architecture in WeBank's Core Systems
Tencent Cloud Developer
Tencent Cloud Developer
May 11, 2021 · Databases

Database Technology Development and Future Directions: From Commercial Databases to Cloud-Native Era

The article traces database technology from the commercial Oracle era through open‑source and the emerging cloud‑native phase, highlights cloud as the primary battleground and the importance of the to‑B market, reviews historic academic contributions, examines Oracle and China’s TDSQL evolution, and outlines five future directions—distributed, intelligent, multi‑model, hardware‑software integration, and cloud convergence—while urging DBAs to adapt their full‑stack skills.

OracleTDSQLcloud database
0 likes · 21 min read
Database Technology Development and Future Directions: From Commercial Databases to Cloud-Native Era
Java Architect Essentials
Java Architect Essentials
Apr 26, 2021 · Databases

Discover How Tendis Delivers High‑Performance, Redis‑Compatible KV Storage

Tendis, an open‑source distributed KV store developed by Tencent, combines full Redis protocol compatibility with RocksDB persistence, a decentralized gossip‑based cluster architecture, horizontal scalability to thousands of nodes, and cost‑effective hot‑cold data mixing, making it suitable for large‑scale, high‑throughput workloads.

KV StoreRedis compatibleRocksDB
0 likes · 6 min read
Discover How Tendis Delivers High‑Performance, Redis‑Compatible KV Storage
DataFunTalk
DataFunTalk
Apr 21, 2021 · Databases

TiDB Practices and Solutions for Core Banking and Financial Industry

This article presents a comprehensive technical overview of TiDB, an open‑source distributed NewSQL database, detailing its architecture, migration strategies, and real‑world deployments across core banking, payment, wealth‑management, risk‑control, and insurance scenarios, while highlighting its HTAP capabilities and upcoming TiDB 5.0 enhancements.

Financial ServicesHTAPTiDB
0 likes · 20 min read
TiDB Practices and Solutions for Core Banking and Financial Industry
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 9, 2021 · Databases

Optimizing DBLE Distributed Database Middleware: Cases of Query Push‑Down Failures and Their Solutions

This article analyzes why certain join queries in DBLE distributed database middleware fail to push down to backend nodes, leading to high CPU usage and latency, and presents four concrete examples with step‑by‑step optimizations to ensure full query push‑down and improved performance.

DBLESQL pushdowndistributed database
0 likes · 8 min read
Optimizing DBLE Distributed Database Middleware: Cases of Query Push‑Down Failures and Their Solutions
21CTO
21CTO
Mar 29, 2021 · Databases

Inside YugabyteDB: Architecture, Tablet Storage, and Distributed Transactions

This article explains YugabyteDB's two‑layer logical architecture, its tablet‑based distributed storage built on Raft groups, the RocksDB‑backed local DocDB, and how it implements distributed transactions using Hybrid Logical Clocks, two‑phase commit, and MVCC, while comparing it with TiDB, CockroachDB and other rivals.

2PCMVCCRocksDB
0 likes · 14 min read
Inside YugabyteDB: Architecture, Tablet Storage, and Distributed Transactions
ITPUB
ITPUB
Mar 29, 2021 · Databases

Inside YugabyteDB: Architecture, Tablet Storage, and Distributed Transactions Explained

This article provides a comprehensive technical overview of YugabyteDB, covering its two‑layer logical architecture, tablet‑based distributed storage with Raft groups, RocksDB‑backed local storage design, hybrid hash‑range partitioning, and the MVCC‑based two‑phase‑commit transaction model using Hybrid Logical Clocks.

MVCCRocksDBTablet Storage
0 likes · 15 min read
Inside YugabyteDB: Architecture, Tablet Storage, and Distributed Transactions Explained
TAL Education Technology
TAL Education Technology
Mar 11, 2021 · Backend Development

Evolution of a Call Platform's System Architecture: From Monolith to Service Splitting, Governance, Horizontal Scaling, Distributed Databases, and Microservices

The article outlines how a call platform’s architecture progressed through successive stages—starting with a monolithic design, then business service splitting, service governance and isolated deployment, horizontal scaling, distributed database sharding, and finally micro‑service adoption—highlighting the problems each evolution solved and the new challenges introduced.

Backend DevelopmentMicroservicesScalability
0 likes · 13 min read
Evolution of a Call Platform's System Architecture: From Monolith to Service Splitting, Governance, Horizontal Scaling, Distributed Databases, and Microservices
21CTO
21CTO
Jan 6, 2021 · Databases

Step-by-Step Guide to Building and Scaling a Redis Cluster on Redis 6.0+

This tutorial walks through setting up a Redis Cluster on a single server with six nodes, covering node startup, handshake, slot assignment, master‑slave replication, command routing, fault‑tolerance, and practical scaling operations such as adding, rebalancing, and removing nodes.

ClusterRedis 6.0Redis CLI
0 likes · 25 min read
Step-by-Step Guide to Building and Scaling a Redis Cluster on Redis 6.0+
DeWu Technology
DeWu Technology
Dec 18, 2020 · Databases

TiDB Architecture, Design, and Real‑World Application

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.

Data MigrationDatabase ArchitectureHTAP
0 likes · 18 min read
TiDB Architecture, Design, and Real‑World Application
JD Cloud Developers
JD Cloud Developers
Dec 4, 2020 · Databases

How TiDB Solves High‑Traffic Database Challenges: Architecture, Features, and Real‑World Cases

This article summarizes a JD Cloud‑TiDB live webcast, explaining why JD Cloud chose TiDB, detailing its distributed architecture (TiDB Server, TiKV storage, PD), highlighting features such as horizontal scaling, strong consistency, real‑time analytics, backup, migration, and showcasing multiple enterprise migration case studies that demonstrate TiDB’s ability to overcome traditional database bottlenecks.

Data MigrationReal-time analyticsScalability
0 likes · 13 min read
How TiDB Solves High‑Traffic Database Challenges: Architecture, Features, and Real‑World Cases
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Dec 2, 2020 · Databases

How Pika’s Native Distributed Cluster Overcomes Redis Capacity Limits

This article explains Pika’s native distributed cluster architecture, detailing its deployment structure, data distribution with tables and slots, request processing flow, both non‑consistent and Raft‑based log replication, and the enhanced metadata management that enables scalable, high‑availability storage beyond single‑node Redis limitations.

Cluster ArchitecturePikaReplication
0 likes · 10 min read
How Pika’s Native Distributed Cluster Overcomes Redis Capacity Limits
Programmer DD
Programmer DD
Nov 27, 2020 · Databases

Why TiDB Is Revolutionizing Distributed Databases: Architecture, Use Cases, and HTAP

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.

Data WarehousingHTAPMySQL compatibility
0 likes · 8 min read
Why TiDB Is Revolutionizing Distributed Databases: Architecture, Use Cases, and HTAP
360 Tech Engineering
360 Tech Engineering
Nov 24, 2020 · Databases

Architecture and Design of Pika Native Distributed Cluster

The article explains the background, architecture, data distribution, processing flow, replication mechanisms, and management features of Pika's native distributed cluster, detailing how Etcd, LVS, and RocksDB are used to achieve scalable, persistent Redis-compatible storage with table isolation and flexible slot replication.

Cluster ArchitecturePikaRedis Compatibility
0 likes · 8 min read
Architecture and Design of Pika Native Distributed Cluster
DeWu Technology
DeWu Technology
Nov 19, 2020 · Operations

HBase Operations and Use Cases for High‑Concurrency E‑commerce

In this talk, Yun Jin explains how HBase’s petabyte‑scale, horizontally‑scalable architecture—built on Hadoop, HMaster, RegionServers, and Zookeeper—enables e‑commerce platforms to handle extreme promotion‑day traffic by supporting high‑throughput reads/writes, time‑series monitoring, massive order storage, and robust HA, while covering essential table operations, monitoring, and troubleshooting techniques.

Big DataHBaseOperations
0 likes · 6 min read
HBase Operations and Use Cases for High‑Concurrency E‑commerce
Architect
Architect
Sep 24, 2020 · Databases

Overview of TiDB Architecture: TiKV, PD, TiDB Server, and TiSpark

This article provides a comprehensive overview of TiDB's architecture, detailing the roles of TiKV Server, Placement Driver (PD), TiDB Server, and the TiSpark component, and explains how Raft ensures data consistency across the distributed database system.

Placement DriverRaftTiDB
0 likes · 11 min read
Overview of TiDB Architecture: TiKV, PD, TiDB Server, and TiSpark
AntTech
AntTech
Sep 2, 2020 · Databases

OceanBase Distributed Relational Database Enables Insurance Business Innovation

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.

FinTechHTAPInsurance
0 likes · 12 min read
OceanBase Distributed Relational Database Enables Insurance Business Innovation
Tencent Cloud Developer
Tencent Cloud Developer
Aug 26, 2020 · Databases

How to Become an Outstanding Data Craftsman: Insights from Database Experts

Three leading database experts from Tencent and cloud firms share how deep curiosity, hands‑on experimentation, persistent learning—combined with mastering distributed, cloud, and autonomous databases—forge an outstanding data craftsman, while advising newcomers to master performance, security, one DB per category, and start with open‑source tools.

Career DevelopmentDBADatabase Architecture
0 likes · 34 min read
How to Become an Outstanding Data Craftsman: Insights from Database Experts
dbaplus Community
dbaplus Community
Aug 5, 2020 · Databases

How JIMKV Unifies Cache and Storage to Power High‑Performance Distributed Databases

The article details JD Retail's JIMKV distributed database, explaining its unified cache‑storage architecture, fault‑detection and elastic‑scaling mechanisms, hot‑cold data tiering, read/write amplification mitigation, real‑world product‑detail use case, and future plans for intelligent operations and OLAP support.

KV Storecache storage integrationdistributed database
0 likes · 18 min read
How JIMKV Unifies Cache and Storage to Power High‑Performance Distributed Databases
MaGe Linux Operations
MaGe Linux Operations
Jun 26, 2020 · Databases

What Makes TiDB a Cloud‑Native HTAP Database? An In‑Depth Overview

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.

Cloud NativeHTAPMySQL compatibility
0 likes · 9 min read
What Makes TiDB a Cloud‑Native HTAP Database? An In‑Depth Overview
360 Quality & Efficiency
360 Quality & Efficiency
Jun 19, 2020 · Databases

TiDB Overview: Architecture, Deployment, Advantages, and Practical Tips

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.

DeploymentHTAPMySQL compatibility
0 likes · 13 min read
TiDB Overview: Architecture, Deployment, Advantages, and Practical Tips
Tencent Cloud Developer
Tencent Cloud Developer
May 7, 2020 · Databases

TDSQL Horizontal Scaling: Design Principles and Practice for Non‑Disruptive Linear Expansion

TDSQL enables Tencent Meeting’s non‑disruptive, linear horizontal scaling by using a stateless SQL engine, shard‑key selection, two‑phase distributed transactions, and one‑click set expansion, delivering near‑linear performance growth, high availability, and seamless capacity increase for millions of daily users worldwide.

TDSQLcloud video conferencedistributed database
0 likes · 17 min read
TDSQL Horizontal Scaling: Design Principles and Practice for Non‑Disruptive Linear Expansion
HomeTech
HomeTech
Apr 29, 2020 · Databases

Optimizing Write Hotspots in TiDB: Architecture Overview, Problem Analysis, and Solution

This article details a real‑world case of write‑hotspot performance degradation in a TiDB 3.0.9 cluster, explains TiDB’s architecture, analyzes monitoring data and hot‑region tables, and presents a redesign using varchar primary keys and SHARD_ROW_ID_BITS to disperse writes and dramatically improve latency.

Database OptimizationTiDBWrite Hotspot
0 likes · 16 min read
Optimizing Write Hotspots in TiDB: Architecture Overview, Problem Analysis, and Solution
dbaplus Community
dbaplus Community
Apr 7, 2020 · Databases

How Pharos Accelerates HBase Multi‑Condition Queries with Low‑Latency Indexing

This article examines Pharos, Everbright Bank's home‑grown HBase indexing middleware, detailing why existing secondary‑index solutions fall short, the design goals of low latency, simple architecture and non‑intrusiveness, and the concrete storage, pagination, and transaction‑consistency techniques that enable fast complex queries on massive data.

HBaseLow latencyPharos
0 likes · 14 min read
How Pharos Accelerates HBase Multi‑Condition Queries with Low‑Latency Indexing
360 Tech Engineering
360 Tech Engineering
Mar 12, 2020 · Databases

TiDB on 360 Cloud Platform: Deployment, Migration, and Performance Tuning

This article shares the experience of deploying TiDB on the 360 Cloud Platform, covering background challenges with massive tables, TiDB's online DDL and high‑performance features, cluster architecture, DM migration workflow, common operational issues, and detailed tuning parameters to improve latency, QPS, and resource utilization.

DMData MigrationSQL
0 likes · 22 min read
TiDB on 360 Cloud Platform: Deployment, Migration, and Performance Tuning
AntTech
AntTech
Mar 12, 2020 · Databases

Comprehensive Overview of OceanBase 2.2: Architecture, Core Features, and Enterprise Solutions

This article provides an in‑depth technical overview of OceanBase 2.2, covering its distributed architecture, high‑availability design, multi‑tenant resource pool, Oracle/MySQL compatibility, performance benchmarks, ecosystem tools such as OCP, ODC, OMS, and disaster‑recovery solutions for financial‑grade workloads.

OceanBaseSQL Compatibilitydistributed database
0 likes · 14 min read
Comprehensive Overview of OceanBase 2.2: Architecture, Core Features, and Enterprise Solutions
Big Data Technology & Architecture
Big Data Technology & Architecture
Feb 28, 2020 · Databases

TiDB Technical Deep Dive – Storage, Compute, and Scheduling Architecture

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.

HTAPKV storageRaft
0 likes · 31 min read
TiDB Technical Deep Dive – Storage, Compute, and Scheduling Architecture
DataFunTalk
DataFunTalk
Dec 30, 2019 · Databases

Cassandra: Past, Present, and Future – History, Architecture, Features, and Use Cases

This article summarizes a Cassandra meetup presentation that traces the database's origins from BigTable and Dynamo, outlines its key milestones, explains its peer‑to‑peer and LSM architecture, highlights current features, real‑world deployments, performance advantages, and previews upcoming 4.0 releases and community projects.

Big DataGossip ProtocolLSM
0 likes · 14 min read
Cassandra: Past, Present, and Future – History, Architecture, Features, and Use Cases
DataFunTalk
DataFunTalk
Dec 23, 2019 · Databases

Cassandra Deployment and Optimization at 360 Cloud Storage

This article details how 360 adopted Cassandra for its cloud drive, describing Cassandra’s decentralized architecture, the reasons for its selection over HBase, large‑scale deployment challenges, performance optimizations, reliability improvements, disk utilization techniques, and the evolution of the system from 2010 to present.

Big DataData ReliabilityScalability
0 likes · 15 min read
Cassandra Deployment and Optimization at 360 Cloud Storage
Architecture Digest
Architecture Digest
Dec 19, 2019 · Databases

Design and Migration of Zhihu's Read Service: From Bloom Filter to TiDB

This article details Zhihu's read‑service architecture, its massive data scale and performance challenges, early Bloom‑filter and HBase solutions, the design goals of high availability, high performance and scalability, and the subsequent migration from MySQL to TiDB with cloud‑native practices.

TiDBcloud-nativedistributed database
0 likes · 25 min read
Design and Migration of Zhihu's Read Service: From Bloom Filter to TiDB
DataFunTalk
DataFunTalk
Dec 13, 2019 · Databases

Lindorm: High‑Performance Distributed NoSQL Database for Big Data

Lindorm, an Alibaba‑derived distributed NoSQL database built on HBase, delivers multi‑model hybrid storage, five‑fold throughput gains, sub‑millisecond latency, advanced indexing, cloud‑native elasticity, strong/adjustable consistency, and comprehensive security and multi‑tenant features for massive data workloads.

Big DataNoSQLPerformance Optimization
0 likes · 25 min read
Lindorm: High‑Performance Distributed NoSQL Database for Big Data
HomeTech
HomeTech
Nov 27, 2019 · Databases

Migrating AutoHome Community from SQL Server to TiDB: Architecture, Testing, and Lessons Learned

This article details the AutoHome community's migration from a monolithic SQL Server database to the distributed TiDB platform, covering the performance bottlenecks that prompted the change, the evaluation of candidate databases, extensive OLTP/OLAP testing, the full‑ and incremental‑sync migration strategy, rollback mechanisms, and the resulting operational improvements.

ETLPerformance TestingSQL Server
0 likes · 15 min read
Migrating AutoHome Community from SQL Server to TiDB: Architecture, Testing, and Lessons Learned
21CTO
21CTO
Oct 26, 2019 · Databases

How We Migrated a Billion‑Transaction Payment Platform from MySQL to TiDB

This article details the challenges and solutions encountered when migrating Fengchao's high‑throughput payment platform—handling over a hundred‑billion rows and millions of QPS—from a sharded MySQL architecture to TiDB, covering performance bottlenecks, TiDB advantages, migration steps, tooling, pitfalls, and optimization recommendations.

TiDBdatabase migrationdistributed database
0 likes · 20 min read
How We Migrated a Billion‑Transaction Payment Platform from MySQL to TiDB
Alibaba Cloud Developer
Alibaba Cloud Developer
Oct 9, 2019 · Databases

How OceanBase Crushed TPC‑C: Inside the Record‑Breaking Distributed Database Benchmark

OceanBase’s distributed relational database achieved the top TPC‑C benchmark score by leveraging cloud‑native resources, optimized storage, advanced transaction engines, and extensive SQL tuning, with detailed insights into preparation, system architecture, performance testing phases, ACID compliance, and storage optimizations that set new industry standards.

OceanBaseSQL OptimizationTPC-C
0 likes · 33 min read
How OceanBase Crushed TPC‑C: Inside the Record‑Breaking Distributed Database Benchmark
AntTech
AntTech
Oct 7, 2019 · Databases

OceanBase TPC‑C Benchmark: Transaction Engine Design and ACID Guarantees

OceanBase’s TPC‑C benchmark demonstrates how its distributed database achieves high durability, atomicity, isolation, and consistency on commodity cloud servers using Paxos‑based log replication, two‑phase commit, MVCC, and replicated tables, highlighting the architectural challenges and solutions for ACID compliance.

ACIDMVCCOceanBase
0 likes · 10 min read
OceanBase TPC‑C Benchmark: Transaction Engine Design and ACID Guarantees
AntTech
AntTech
Oct 7, 2019 · Databases

OceanBase Storage Architecture and Optimizations for TPC‑C Benchmark

This article explains how OceanBase’s distributed, shared‑nothing architecture, with dual data replicas, Paxos‑based consistency, online compression, and resource‑isolated compaction, enables it to achieve top TPC‑C performance while addressing storage costs and CPU usage.

LSM‑TreeOceanBaseOnline Compression
0 likes · 10 min read
OceanBase Storage Architecture and Optimizations for TPC‑C Benchmark
AntTech
AntTech
Oct 7, 2019 · Databases

OceanBase’s TPC‑C Benchmark: Technical Deep Dive into Test Preparation, System Architecture, and Performance Results

This article provides a comprehensive technical analysis of OceanBase’s record‑breaking TPC‑C benchmark, covering the preparation work, test system design, planning, performance testing methodology, ACID verification, and the lessons learned from achieving 60.88 million tpmC on a distributed cloud platform.

ACIDDatabase BenchmarkOceanBase
0 likes · 12 min read
OceanBase’s TPC‑C Benchmark: Technical Deep Dive into Test Preparation, System Architecture, and Performance Results
AntTech
AntTech
Oct 6, 2019 · Databases

OceanBase TPC‑C Benchmark: Technical Insights and Future Directions

This article provides a detailed technical analysis of OceanBase’s TPC‑C benchmark performance, covering the database’s development history, benchmark methodology, identified shortcomings, future improvement plans, and the strict standards and audit processes that ensure reliable OLTP benchmarking results.

Database BenchmarkOceanBasePerformance Optimization
0 likes · 12 min read
OceanBase TPC‑C Benchmark: Technical Insights and Future Directions
AntTech
AntTech
Oct 5, 2019 · Databases

OceanBase Tops the TPC‑C Benchmark: Process, Significance, and Technical Insights

OceanBase, the distributed database from Ant Financial, topped the latest TPC‑C benchmark, and this article explains the benchmark’s significance, the rigorous certification process, the performance and cost metrics, and how OceanBase’s architecture and Alibaba Cloud support enabled this achievement.

Database BenchmarkOceanBaseTPC-C
0 likes · 13 min read
OceanBase Tops the TPC‑C Benchmark: Process, Significance, and Technical Insights
JD Retail Technology
JD Retail Technology
Sep 20, 2019 · Databases

Follower Reads, Closed Timestamp, and Minimum Proposal Tracker in CB‑SQL

This article explains how CB‑SQL implements follower reads by using safe (closed) timestamps, describes the CT update mechanism with a Minimum Proposal Tracker, and discusses routing, replica read validation, timestamp forwarding, range split/merge handling, and recovery strategies for consistent distributed reads.

CB-SQLCDCClosed Timestamp
0 likes · 15 min read
Follower Reads, Closed Timestamp, and Minimum Proposal Tracker in CB‑SQL
Tencent Cloud Developer
Tencent Cloud Developer
Aug 16, 2019 · Databases

WeBank’s Deployment of Tencent TDSQL: Distributed Database Architecture, High Availability, and Scaling

WeBank adopted Tencent TDSQL, a MySQL‑based distributed database with strong‑consistency replication, auto‑sharding, read/write separation, automatic failover, and a management platform; deployed across two IDC regions using a 3+2 replica model, supporting petabyte data, billions of daily transactions, and high availability.

DCNTDSQLWeBank
0 likes · 15 min read
WeBank’s Deployment of Tencent TDSQL: Distributed Database Architecture, High Availability, and Scaling
JD Retail Technology
JD Retail Technology
Jul 9, 2019 · Databases

Transparent Scalable NewSQL: Design and Implementation of CB‑SQL Distributed Database

The article explains the concept of transparent scalable NewSQL databases, discusses the historical challenges of scaling relational systems, and details the design and implementation techniques—such as dynamic sharding, distributed transactions, consensus algorithms, distributed SQL, and CB‑SQL’s specific mechanisms like HLC, SSI isolation, Multi‑Raft, and automatic load balancing—to achieve elasticity, high availability, and seamless scalability.

CB‑SQLConsensusNewSQL
0 likes · 17 min read
Transparent Scalable NewSQL: Design and Implementation of CB‑SQL Distributed Database
JD Retail Technology
JD Retail Technology
Jul 3, 2019 · Databases

CB‑SQL: JD Retail’s Elastic Distributed Database Built on CockroachDB – Architecture and Implementation Details

The article introduces CB‑SQL, JD Retail’s next‑generation elastic database based on CockroachDB, and comprehensively explains its overview, layered architecture, storage replication, cluster management, MVCC, hybrid logical clocks, lock‑free distributed transactions, CDC changefeeds, and SQL interface support.

CDCCockroachDBMVCC
0 likes · 14 min read
CB‑SQL: JD Retail’s Elastic Distributed Database Built on CockroachDB – Architecture and Implementation Details
AntTech
AntTech
Jun 11, 2019 · Databases

Applying OceanBase Financial‑Grade Distributed Database at Net Business Bank: Architecture, Migration, and High‑Availability Practices

This article, based on a 2019 Ant Financial technology summit talk, details Net Business Bank’s adoption of the financial‑grade distributed database OceanBase, covering its logical and physical architectures, migration services, high‑availability designs, elastic data sources, and future outlook for distributed database innovation in banking.

OceanBasecloud architecturedatabase migration
0 likes · 9 min read
Applying OceanBase Financial‑Grade Distributed Database at Net Business Bank: Architecture, Migration, and High‑Availability Practices
21CTO
21CTO
May 16, 2019 · Databases

How ICBC Transformed Its Legacy OLTP Systems with a Distributed MySQL Architecture

This article details the Industrial and Commercial Bank of China's multi‑year migration from mainframe‑based DB2 to a high‑availability, distributed MySQL solution, covering the challenges, strategic decisions, technical stack, containerization, operational improvements, and measurable business outcomes.

Cloud Nativebanking ITdatabase migration
0 likes · 19 min read
How ICBC Transformed Its Legacy OLTP Systems with a Distributed MySQL Architecture
Aikesheng Open Source Community
Aikesheng Open Source Community
May 14, 2019 · Databases

Industrial and Commercial Bank of China's IT Architecture Transformation: A MySQL Distributed Enterprise Solution

This article details the Industrial and Commercial Bank of China's migration from traditional OLTP mainframe databases to a large‑scale, high‑availability MySQL distributed architecture, covering challenges, strategic goals, technology selection, implementation phases, performance improvements, and future directions.

Banking IT Transformationcontainerizationdatabase migration
0 likes · 19 min read
Industrial and Commercial Bank of China's IT Architecture Transformation: A MySQL Distributed Enterprise Solution
ITPUB
ITPUB
May 14, 2019 · Databases

How Didi Built Fusion: From NoSQL to NewSQL and Distributed Database Design

This article details Didi's evolution from a self‑built NoSQL system called Fusion to a NewSQL solution and outlines the challenges, architectural highlights, data migration mechanisms, and future distributed database design, providing concrete metrics, diagrams, and practical lessons learned.

Data MigrationNewSQLNoSQL
0 likes · 18 min read
How Didi Built Fusion: From NoSQL to NewSQL and Distributed Database Design
Alibaba Cloud Developer
Alibaba Cloud Developer
Apr 25, 2019 · Databases

How OceanBase Overcame the Odds to Become China’s Homegrown Distributed Database

OceanBase, Alibaba’s home‑grown distributed relational database, survived early skepticism and near‑disbandment to replace Oracle in Ant Financial’s core systems, achieve record‑breaking transaction throughput, and now powers dozens of Chinese banks, illustrating the challenges and triumphs of building a modern DBMS.

AlibabaDatabase EngineeringOceanBase
0 likes · 18 min read
How OceanBase Overcame the Odds to Become China’s Homegrown Distributed Database
DataFunTalk
DataFunTalk
Apr 22, 2019 · Databases

Deep Dive into TiDB SQL Optimizer and Execution Engine

This article provides a comprehensive technical overview of TiDB's architecture, its SQL optimizer—including logical and physical optimization phases, rule‑based transformations, join ordering, and statistics collection—and outlines future work to improve query planning stability and performance.

Database InternalsQuery PlanningSQL Optimizer
0 likes · 16 min read
Deep Dive into TiDB SQL Optimizer and Execution Engine
dbaplus Community
dbaplus Community
Mar 31, 2019 · Databases

Unlocking Distributed Databases with Apache ShardingSphere: Features and JD.com Case Study

This article introduces Apache ShardingSphere’s ecosystem, core sharding and governance capabilities, access endpoints such as Sharding-JDBC, Sharding-Proxy and Sharding-Sidecar, and details JD.com’s real‑world implementation, including data‑sharding strategies, distributed primary keys, hint routing, performance optimizations, and future roadmap.

Apache ShardingSphereDatabase MiddlewareJD.com
0 likes · 18 min read
Unlocking Distributed Databases with Apache ShardingSphere: Features and JD.com Case Study
Tencent Cloud Developer
Tencent Cloud Developer
Mar 20, 2019 · Big Data

TVP Training Camp: Exploring Big Data Technologies and Trends

The inaugural TVP Training Camp on March 16 2019 in Beijing gathered Tencent Cloud’s TVP members and leading big‑data experts to discuss emerging technologies such as Greenplum, PMEM‑driven infrastructure, data‑operation optimization, and next‑generation cloud databases, while a round‑table addressed practical challenges and affirmed Tencent’s commitment to ongoing expert collaboration.

Big DataData AnalyticsTVP Training Camp
0 likes · 11 min read
TVP Training Camp: Exploring Big Data Technologies and Trends
Didi Tech
Didi Tech
Mar 15, 2019 · Databases

Design and Evolution of Fusion: Didi’s Distributed NoSQL Database

Fusion is Didi’s self‑developed distributed NoSQL database, fully compatible with the Redis protocol, that combines Redis‑level low latency, MySQL‑level durability, ACID transactions, multi‑replica high availability, FastLoad bulk import, NewSQL secondary indexes, and cross‑datacenter active‑active replication to serve petabyte‑scale ride‑hailing data.

Active‑Active ReplicationFastLoadNewSQL
0 likes · 15 min read
Design and Evolution of Fusion: Didi’s Distributed NoSQL Database
AntTech
AntTech
Mar 12, 2019 · Databases

Evolution and Architecture of OceanBase Distributed Database

OceanBase, a fully proprietary distributed NewSQL database, has evolved over eight years to support high‑availability, strong consistency via Paxos, flexible replica management, OBProxy routing, LSM‑Tree storage, and migration tools, enabling seamless scaling, disaster recovery, and Oracle compatibility for large‑scale financial services.

PaxosReplicationScalability
0 likes · 15 min read
Evolution and Architecture of OceanBase Distributed Database
Zhuanzhuan Tech
Zhuanzhuan Tech
Jan 11, 2019 · Databases

Differences Between TiDB and MySQL: Transactions, Queries, Server‑Side Prepared Statements, and Batch Processing

This article examines TiDB, a world‑class open‑source distributed NewSQL database, comparing its transaction and query behavior with MySQL, discussing underlying Percolator model, server‑side prepared statements, batch processing techniques, and practical optimization strategies for developers.

Batch ProcessingTiDBdistributed database
0 likes · 10 min read
Differences Between TiDB and MySQL: Transactions, Queries, Server‑Side Prepared Statements, and Batch Processing
AntTech
AntTech
Jan 9, 2019 · Databases

Evolution of Ant Financial Database Architecture and the OceanBase Migration Service

The article outlines Ant Financial's three‑generation database architecture evolution, the challenges of upgrading legacy commercial databases, and introduces the OceanBase Migration Service (OMS) as a comprehensive, automated solution that enables seamless, low‑risk migration to a distributed cloud database with rapid validation, data verification, and one‑click cut‑over capabilities.

Ant FinancialOceanBasearchitecture upgrade
0 likes · 11 min read
Evolution of Ant Financial Database Architecture and the OceanBase Migration Service
AntTech
AntTech
Dec 26, 2018 · Databases

OceanBase 2.0 Partitioning and Performance Optimizations for Ant Group’s Double‑11 Peak

This article explains how OceanBase 2.0’s partitioning architecture, partition‑group feature, and a series of performance optimizations enabled Ant Group’s payment core to handle millions of transactions per second during the Double‑11 shopping festival, while also describing the system’s advantages, results, and future capabilities.

Ant GroupDouble 11OceanBase
0 likes · 10 min read
OceanBase 2.0 Partitioning and Performance Optimizations for Ant Group’s Double‑11 Peak
Tencent Cloud Developer
Tencent Cloud Developer
Dec 3, 2018 · Databases

Architecture and Design of Tencent Cloud CynosDB and CynosFS

Tencent Cloud’s CynosDB uses a shared‑storage, primary‑multiple‑replica architecture built on the user‑space distributed file system CynosFS, separating compute from elastic block storage, sinking write‑ahead logs for asynchronous replay, and employing MVCC with Raft‑replicated segments to achieve high‑availability, scalable, and cost‑effective MySQL/PostgreSQL‑compatible performance.

CynosDBDatabase ArchitectureLog Sinking
0 likes · 17 min read
Architecture and Design of Tencent Cloud CynosDB and CynosFS
AntTech
AntTech
Dec 3, 2018 · Databases

OceanBase 2.0 Technical Overview: Enabling Ant Group’s Double 11 Mega‑Promotion

The article details how OceanBase 2.0’s distributed architecture, containerization, storage‑compute separation, and intelligent OCP platform enabled Ant Group’s 2018 Double 11 promotion to achieve 50 % performance gains, zero‑cost scaling, and seamless support for millions of concurrent payments.

Double 11Intelligent OperationsOceanBase
0 likes · 11 min read
OceanBase 2.0 Technical Overview: Enabling Ant Group’s Double 11 Mega‑Promotion
Meituan Technology Team
Meituan Technology Team
Nov 22, 2018 · Databases

Meituan's TiDB Adoption: Architecture, Deployment, and Operational Practices

Facing MySQL limits, Meituan selected TiDB for its MySQL compatibility, strong consistency, and online scaling, deploying it on ten clusters and 200 nodes, building automated deployment, monitoring, and data‑sync tools, resolving performance issues, and planning broader adoption and joint development of future TiDB features.

MeituanPerformance OptimizationTiDB
0 likes · 20 min read
Meituan's TiDB Adoption: Architecture, Deployment, and Operational Practices
dbaplus Community
dbaplus Community
Oct 10, 2018 · Databases

Why MyCat’s Pseudo‑Distributed MySQL Solution Fails and What to Do Instead

The article examines MyCat’s middleware‑based pseudo‑distributed MySQL architecture, outlines its storage, scalability, and reliability shortcomings, walks through common solutions like disk expansion, compression, and sharding, and finally offers practical steps and alternative technologies for building truly distributed database systems.

Database ArchitectureMycatdistributed database
0 likes · 24 min read
Why MyCat’s Pseudo‑Distributed MySQL Solution Fails and What to Do Instead
Tongcheng Travel Technology Center
Tongcheng Travel Technology Center
Sep 26, 2018 · Databases

Design and Implementation of the Thor System for Containerized Management of TiDB

This article describes the challenges of scaling MySQL workloads, introduces TiDB’s distributed architecture, and details the Thor system’s container‑orchestrated design—including scheduling, cluster and database management, data synchronization with Hamal, and integrated monitoring and alerting—to achieve efficient, automated operation of large‑scale TiDB clusters.

TiDBcontainer orchestrationdistributed database
0 likes · 9 min read
Design and Implementation of the Thor System for Containerized Management of TiDB
AntTech
AntTech
Sep 25, 2018 · Databases

OceanBase 2.0 Release: Technical Overview and Innovations

The article presents a comprehensive technical overview of OceanBase 2.0, detailing its evolution from a single‑node financial database to a distributed system, the three major migration challenges, new features such as global snapshots, global indexes, load‑balancing, high‑availability mechanisms, operability enhancements, performance improvements, and compatibility extensions, all illustrated with real‑world financial use cases and the upcoming Double‑Eleven stress test.

CompatibilityFinancial ServicesGlobal Snapshot
0 likes · 19 min read
OceanBase 2.0 Release: Technical Overview and Innovations
iQIYI Technical Product Team
iQIYI Technical Product Team
Sep 21, 2018 · Databases

Case Study of iQIYI’s Adoption of TiDB for Scalable High‑Availability Database Services

iQIYI migrated its critical Edge Control, Video Transcoding, and User Login services from MySQL to TiDB, gaining automatic sharding, high‑availability multi‑datacenter replication, and stable query performance that eliminated storage bottlenecks, complex sharding logic and frequent downtime, while enabling future OLTP/OLAP integration.

Data MigrationScalabilityTiDB
0 likes · 10 min read
Case Study of iQIYI’s Adoption of TiDB for Scalable High‑Availability Database Services
ITPUB
ITPUB
Aug 21, 2018 · Databases

Inside UnionPay’s Distributed MySQL Middleware: Architecture, Transactions & SQL Optimizations

This article summarizes UnionPay’s evolution of a distributed MySQL middleware platform, detailing its multi‑stage architecture, 2‑phase commit transaction handling, deadlock detection, SQL parsing optimizations, complex query strategies, and deployment considerations for high‑availability and performance.

Complex QueryDeadlock DetectionSQL Optimization
0 likes · 13 min read
Inside UnionPay’s Distributed MySQL Middleware: Architecture, Transactions & SQL Optimizations
AntTech
AntTech
Jul 31, 2018 · Databases

High Availability and Disaster Recovery Strategies for OceanBase Distributed Database

This article reviews traditional database high‑availability techniques, explains the advantages of distributed multi‑replica consistency (Paxos/Raft) used by OceanBase, and compares various deployment topologies—from single‑site three‑replica to multi‑city five‑replica designs—highlighting their trade‑offs and best‑practice recommendations.

OceanBasePaxosReplication
0 likes · 23 min read
High Availability and Disaster Recovery Strategies for OceanBase Distributed Database
ITPUB
ITPUB
Jun 5, 2018 · Databases

How T‑TDSQL Enables Full‑Temporal Data Management in Distributed Databases

T‑TDSQL, a temporal extension of Tencent's TDSQL, introduces a full‑temporal data model, scalable distributed architecture, MVCC‑based history visibility algorithms, and rich temporal features that address financial audit, data lineage, and high‑performance analytics for massive historical datasets.

MVCCTDSQLTemporal Database
0 likes · 15 min read
How T‑TDSQL Enables Full‑Temporal Data Management in Distributed Databases
Architecture Digest
Architecture Digest
Apr 21, 2018 · Databases

Case Study: Scaling Ticketing System with TiDB at Tongcheng

Facing rapid traffic growth and MySQL limitations, Tongcheng migrated its ticketing order database to a sharded MySQL cluster combined with TiDB, achieving transparent sharding, real‑time synchronization, high‑availability monitoring, and seamless handling of billions of rows and peak QPS over 10,000.

KubernetesMySQL compatibilityTiDB
0 likes · 8 min read
Case Study: Scaling Ticketing System with TiDB at Tongcheng
AntTech
AntTech
Apr 12, 2018 · Databases

Reflections on Building OceanBase: A Distributed Relational Database Journey

The article shares a senior database engineer's perspective on developing OceanBase, describing the challenges of creating a high‑performance distributed relational database, the strategic choices between open‑source and self‑built solutions, and the product’s evolution toward serving the financial industry.

Database ArchitectureFinTechOceanBase
0 likes · 10 min read
Reflections on Building OceanBase: A Distributed Relational Database Journey
UCloud Tech
UCloud Tech
Jan 19, 2018 · Databases

From Middleware to Distributed Database: UDDB’s Evolution and Architecture

The article outlines UDDB’s roadmap from a MySQL‑compatible middleware to a full‑featured distributed database, detailing its three‑stage evolution, system architecture, SQL parsing and routing design, and innovative techniques that enable read‑write separation, vertical sharding, and future horizontal scaling.

MySQL compatibilitySQL parsingdistributed database
0 likes · 15 min read
From Middleware to Distributed Database: UDDB’s Evolution and Architecture
High Availability Architecture
High Availability Architecture
Dec 19, 2017 · Databases

Interview with Liu Qi, Co‑founder and CEO of PingCAP, on TiDB’s Origin, Roadmap, and Database Trends

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.

Cloud NativeHTAPNewSQL
0 likes · 9 min read
Interview with Liu Qi, Co‑founder and CEO of PingCAP, on TiDB’s Origin, Roadmap, and Database Trends
Qunar Tech Salon
Qunar Tech Salon
Dec 14, 2017 · Databases

TiDB Architecture, Deployment, and Monitoring Practices at Qunar

This article explains Qunar's transition from MySQL, Redis, and HBase to TiDB, detailing the background of distributed databases, TiDB's architecture, hardware selection, deployment automation, monitoring setup, and real‑world usage scenarios to address scalability and high‑availability challenges.

Big DataDatabase ArchitectureDeployment
0 likes · 14 min read
TiDB Architecture, Deployment, and Monitoring Practices at Qunar
Tencent Cloud Developer
Tencent Cloud Developer
Nov 28, 2017 · Operations

Award-Winning DevOps Product “Developer Lab” and Tencent Cloud Distributed Database (DCDB) – Technical Overview

At the 2017 Global Operations Conference, Tencent Cloud’s award‑winning Developer Lab—an immersive, browser‑based IDE integrating SSH, RDP and tutorial‑driven workflows with automated resource scheduling—and its Distributed Cloud Database (DCDB), a sharded, cluster‑managed MySQL‑compatible system featuring advanced scheduling, routing and configuration services, were recognized for innovation and influence.

DevOpsInnovationOperations
0 likes · 8 min read
Award-Winning DevOps Product “Developer Lab” and Tencent Cloud Distributed Database (DCDB) – Technical Overview