BestHub
Sign in
Tagged articles

distributed database

232 articles · Page 2 of 3
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 22, 2022 · Databases

Quick Start Guide: Building a Multi‑Tenant Ad Analytics Database with Distributed PostgreSQL (Citus)

This tutorial walks through setting up Citus, creating and distributing PostgreSQL tables for a multi‑tenant ad‑analytics application, loading sample data, executing CRUD and analytical queries, and extending the approach to real‑time GitHub event analysis, demonstrating end‑to‑end database operations in a distributed environment.

CitusPostgreSQLReal-Time Analytics
0 likes · 14 min read
Quick Start Guide: Building a Multi‑Tenant Ad Analytics Database with Distributed PostgreSQL (Citus)
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 20, 2022 · Databases

Official Guide to Installing a Distributed PostgreSQL (Citus) Cluster

This step‑by‑step guide shows how to set up both single‑node and multi‑node Citus clusters on Docker, Ubuntu/Debian, and Fedora/CentOS/Red Hat, covering repository addition, package installation, configuration of shared_preload_libraries, database initialization, worker node registration, and verification commands.

CentOSCitusDocker
0 likes · 14 min read
Official Guide to Installing a Distributed PostgreSQL (Citus) Cluster
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 17, 2022 · Databases

Building Scalable Time‑Series with Distributed PostgreSQL (Citus) – Official Example

This guide shows how to combine PostgreSQL declarative time‑range partitioning with Citus distributed sharding to create a scalable time‑series database, covering table creation, distribution, automatic monthly partition generation, columnar archiving, maintenance with pg_cron, and performance benefits such as faster inserts, queries, and data expiration.

CitusPartitioningPostgreSQL
0 likes · 11 min read
Building Scalable Time‑Series with Distributed PostgreSQL (Citus) – Official Example
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 15, 2022 · Databases

Migrating Existing Applications to a Distributed PostgreSQL (Citus) Cluster

This guide walks through planning a distribution strategy, adding and back‑filling a distribution key, preparing a development Citus cluster, updating schema and queries for multi‑tenant workloads, securing connections, monitoring cross‑node traffic, and finally migrating production data using either pg_dump/pg_restore for small databases or Citus Warp for large deployments.

Migrationdistributed databasemulti-tenant
0 likes · 20 min read
Migrating Existing Applications to a Distributed PostgreSQL (Citus) Cluster
Hacker Afternoon Tea
Hacker Afternoon Tea
Mar 6, 2022 · Databases

Understanding Citus: Distributed PostgreSQL Architecture and Core Concepts

Citus extends PostgreSQL into a shared‑nothing distributed system where a coordinator node routes queries to worker nodes, supporting distributed, reference, and local tables, shard placement, replication modes, co‑location, parallel execution, and configurable connection‑pool settings to scale storage and CPU across a cluster.

CitusPostgreSQLQuery Execution
0 likes · 12 min read
Understanding Citus: Distributed PostgreSQL Architecture and Core Concepts
Hacker Afternoon Tea
Hacker Afternoon Tea
Feb 25, 2022 · Databases

How Citus Turns PostgreSQL into a Distributed Database

Citus is an open‑source PostgreSQL extension that adds sharding, distributed tables and parallel query execution, enabling horizontal and vertical scaling for multi‑tenant SaaS, real‑time analytics, and massive workloads, while outlining acquisition options, practical use cases, and scenarios where it is unsuitable.

AzureCitusPostgreSQL
0 likes · 7 min read
How Citus Turns PostgreSQL into a Distributed Database
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.

HTAPMigrationMySQL
0 likes · 35 min read
Efficiency Choice: NetEase Internal Evaluation of Distributed Database TiDB
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.

TiDBarchitecturecloud-native
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.

HTAPHigh AvailabilityPerformance Testing
0 likes · 11 min read
Case Study: TiDB Deployment for the 2021 "818 Global Auto Festival"
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 ComposeGreatSQLHigh Availability
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.

BaikalDBHTAPHigh Availability
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.

Cloud DatabaseOracleTDSQL
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 storeOpen SourceRedis compatible
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.

Service Splittingbackend developmentdistributed database
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.

ClusterHigh AvailabilityRedis 6.0
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.

Cloud DatabaseData MigrationReal-Time Analytics
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 ArchitecturePikadistributed database
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 DataHBaseMonitoring
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.

Cloud DatabaseDBADatabase 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.

Elastic ScalingKV storecache storage integration
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.

HTAPMySQL CompatibilityTiDB
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.

High AvailabilityShardingTDSQL
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.

TiDBWrite Hotspotdatabase optimization
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.

HBasePharosdistributed database
0 likes · 14 min read
How Pharos Accelerates HBase Multi‑Condition Queries with Low‑Latency Indexing
Yanxuan Tech Team
Yanxuan Tech Team
Mar 23, 2020 · Databases

How to Boost E‑commerce Inventory Performance Without Sacrificing Consistency

This article explains how the inventory service at a large e‑commerce platform was optimized for high‑traffic sales events by redesigning transaction handling, sharding data by SKU, and combining flexible and rigid transactions to improve throughput while preserving data consistency.

InventoryTransaction Managementdistributed database
0 likes · 10 min read
How to Boost E‑commerce Inventory Performance Without Sacrificing Consistency
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 DataCassandraLSM
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 DataCassandraCloud Storage
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 DataHigh AvailabilityNoSQL
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.

Database MigrationETLPerformance Testing
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.

Database MigrationMySQLTiDB
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 BenchmarkOceanBaseTPC-C
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
Big Data Technology & Architecture
Big Data Technology & Architecture
Sep 24, 2019 · Databases

Overview of Apache Cassandra: History, Features, and Use Cases

This article provides a comprehensive overview of Apache Cassandra, covering its origins at Facebook, key architectural features such as distributed design, elastic scalability, tunable consistency, and high availability, as well as typical deployment scenarios and notable companies that use it.

Apache CassandraData ModelingHigh Availability
0 likes · 14 min read
Overview of Apache Cassandra: History, Features, and Use Cases
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.

Database MigrationOceanBasecloud architecture
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 NativeDatabase MigrationHigh Availability
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 TransformationDatabase MigrationHigh Availability
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 DataCloud ComputingData Analytics
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.

High AvailabilityMigrationPaxos
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 ProcessingMySQLQuery Optimization
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 FinancialDatabase MigrationOceanBase
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.

Cloud StorageCynosDBDatabase Architecture
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.

Database MigrationMeituanMonitoring
0 likes · 20 min read
Meituan's TiDB Adoption: Architecture, Deployment, and Operational Practices