BestHub
Sign in
Tagged articles
104 articles
Page 1 of 2
Java Companion
Java Companion
Apr 26, 2026 · Databases

Is Sharding Ready to Retire? Why the Classic Split‑Database Approach Is Becoming Legacy

The article reviews the rise and decline of traditional database sharding, explains its technical pitfalls such as wrong shard keys, cross‑database joins, and distributed transactions, compares it with emerging NewSQL solutions like TiDB, OceanBase and PolarDB‑X, and offers practical criteria for choosing the right architecture.

NewSQLOceanBasePolarDB-X
0 likes · 14 min read
Is Sharding Ready to Retire? Why the Classic Split‑Database Approach Is Becoming Legacy
macrozheng
macrozheng
Dec 26, 2025 · Databases

NewSQL vs Middleware Sharding: Which Architecture Really Wins?

This article objectively compares middleware‑based sharding solutions with native NewSQL distributed databases, examining their architectural differences, transaction handling, high‑availability, scaling, SQL support, storage engines, and maturity to help engineers decide which approach best fits their workload.

CAP theoremNewSQLPaxos
0 likes · 20 min read
NewSQL vs Middleware Sharding: Which Architecture Really Wins?
Java Web Project
Java Web Project
Dec 7, 2025 · Databases

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

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

HTAPMySQL compatibilityNewSQL
0 likes · 24 min read
What Makes TiDB a NewSQL Powerhouse? A Deep Dive into Architecture, Features, and Use Cases
DeWu Technology
DeWu Technology
Nov 10, 2025 · Databases

How TiDB v7 Upgrade Boosted Performance and Solved Real‑World Issues

This article details the TiDB upgrade journey from version 5.3.3 to 7.5.x, covering architecture, new v7 features, migration strategies, encountered problems with full‑table scans and inaccurate aggregation plans, the solutions applied, and the measurable performance and stability gains achieved after the upgrade.

Database UpgradeDistributed SQLNewSQL
0 likes · 15 min read
How TiDB v7 Upgrade Boosted Performance and Solved Real‑World Issues
Architect's Guide
Architect's Guide
Sep 29, 2025 · Databases

What Is NewSQL? Exploring TiDB’s Distributed Database Features

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

HTAPMySQL compatibilityNewSQL
0 likes · 22 min read
What Is NewSQL? Exploring TiDB’s Distributed Database Features
macrozheng
macrozheng
Jul 12, 2025 · Databases

NewSQL vs Middleware Sharding: Which Architecture Truly Wins?

This article objectively compares middleware‑based sharding with NewSQL distributed databases, examining their architectures, transaction support, CAP implications, high‑availability, scaling, storage engines, and ecosystem maturity to help readers decide which solution best fits their workload.

CAP theoremDistributed TransactionsNewSQL
0 likes · 19 min read
NewSQL vs Middleware Sharding: Which Architecture Truly Wins?
Architect's Guide
Architect's Guide
May 8, 2025 · Databases

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

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

Cloud NativeHTAPMySQL compatibility
0 likes · 20 min read
An Overview of TiDB: NewSQL Distributed Database Architecture, Features, and MySQL Compatibility
Architect
Architect
May 4, 2025 · Databases

NewSQL vs Middleware Sharding: Which Architecture Truly Wins?

This article objectively compares middleware‑based sharding with NewSQL distributed databases, examining architecture, distributed transactions, performance, high availability, scaling, SQL support, storage engines, and ecosystem maturity to help architects decide which solution fits their specific workload and operational constraints.

CAP theoremDatabase ArchitectureNewSQL
0 likes · 20 min read
NewSQL vs Middleware Sharding: Which Architecture Truly Wins?
Java Captain
Java Captain
Apr 17, 2025 · Databases

Choosing Between Sharding Middleware and NewSQL Distributed Databases: An Objective Comparison

This article objectively compares middleware‑based sharding with NewSQL distributed databases, examining their architectural differences, transaction models, high‑availability mechanisms, scaling, SQL support, storage engines, and maturity to help practitioners decide which approach best fits their workload and operational constraints.

Database ArchitectureDistributed TransactionsNewSQL
0 likes · 17 min read
Choosing Between Sharding Middleware and NewSQL Distributed Databases: An Objective Comparison
Java Architect Essentials
Java Architect Essentials
Mar 14, 2025 · Databases

Comparing NewSQL Databases with Middleware‑Based Sharding: Advantages, Trade‑offs, and Selection Guidance

This article objectively compares NewSQL distributed databases with traditional middleware‑based sharding solutions, examining their architectures, distributed transaction handling, high‑availability, scaling, storage engines, and ecosystem maturity, and provides guidance on selecting the appropriate approach based on consistency, growth, operational capacity, and performance requirements.

Database ArchitectureDistributed TransactionsNewSQL
0 likes · 19 min read
Comparing NewSQL Databases with Middleware‑Based Sharding: Advantages, Trade‑offs, and Selection Guidance
Top Architect
Top Architect
Mar 13, 2025 · Databases

Choosing Between NewSQL Databases and Middleware‑Based Sharding: Advantages, Trade‑offs and Practical Guidance

The article objectively compares NewSQL distributed databases with middleware‑plus‑sharding solutions, covering architectural differences, distributed transaction handling, high‑availability, scaling, SQL support, storage engines, maturity, and provides a decision‑making checklist to help engineers select the most suitable approach for their workloads.

NewSQLScalabilitydistributed databases
0 likes · 23 min read
Choosing Between NewSQL Databases and Middleware‑Based Sharding: Advantages, Trade‑offs and Practical Guidance
Java Web Project
Java Web Project
Mar 6, 2025 · Databases

NewSQL vs Middleware Sharding: Which Architecture Truly Wins?

This article objectively compares NewSQL databases with middleware‑based sharding, dissecting their core architectures, distributed transaction handling, high‑availability designs, scaling mechanisms, SQL support, storage engines, and maturity to help engineers decide the most suitable solution for their workloads.

CAP theoremDatabase ArchitectureDistributed Transactions
0 likes · 20 min read
NewSQL vs Middleware Sharding: Which Architecture Truly Wins?
Architecture Digest
Architecture Digest
Mar 3, 2025 · Databases

NewSQL vs Middleware Sharding: A Comparative Analysis of Distributed Databases

This article objectively compares NewSQL distributed databases with traditional middleware‑based sharding solutions, examining their architectures, distributed transaction support, high availability, scaling, SQL capabilities, and maturity to help readers decide which approach best fits their workload and operational constraints.

NewSQLdistributed databaseshigh availability
0 likes · 18 min read
NewSQL vs Middleware Sharding: A Comparative Analysis of Distributed Databases
macrozheng
macrozheng
Mar 1, 2025 · Databases

NewSQL vs Middleware Sharding: Which Database Architecture Truly Wins?

An in‑depth comparison of NewSQL databases and middleware‑based sharding reveals each approach’s architectural strengths, distributed transaction handling, scalability, HA mechanisms, storage engine design, and ecosystem maturity, guiding readers on when to adopt NewSQL versus traditional sharding solutions.

NewSQLScalabilitydistributed databases
0 likes · 18 min read
NewSQL vs Middleware Sharding: Which Database Architecture Truly Wins?
Selected Java Interview Questions
Selected Java Interview Questions
Feb 23, 2025 · Databases

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

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

HTAPMySQL compatibilityNewSQL
0 likes · 21 min read
TiDB Overview: Distributed NewSQL Database, Architecture, Features, and MySQL Compatibility
Baidu Geek Talk
Baidu Geek Talk
Nov 6, 2024 · Cloud Computing

Baidu Canghai Storage Unified Technology Base: Architecture and Evolution of Metadata, Namespace, and Data Layers

Baidu’s Canghai Storage unifies metadata, hierarchical namespace, and data layers into a Meta‑Aware, three‑generation architecture that scales to trillions of metadata items and zettabyte‑scale data, using a distributed transactional KV store, single‑machine‑distributed namespace, and online erasure‑coding micro‑services to deliver high performance, low cost, and seamless scalability.

Big DataDistributed SystemsNewSQL
0 likes · 18 min read
Baidu Canghai Storage Unified Technology Base: Architecture and Evolution of Metadata, Namespace, and Data Layers
Architect's Guide
Architect's Guide
Sep 29, 2024 · Databases

Advantages of NewSQL Databases Over Middleware‑Based Sharding: Architecture, Transactions, HA, and Scaling

This article objectively compares NewSQL distributed databases with traditional middleware‑based sharding, examining their architectural advantages, distributed transaction handling, high‑availability mechanisms, scaling and sharding strategies, storage engine differences, ecosystem maturity, and provides guidance on selecting the appropriate solution for various workloads.

Database ArchitectureNewSQLPaxos
0 likes · 21 min read
Advantages of NewSQL Databases Over Middleware‑Based Sharding: Architecture, Transactions, HA, and Scaling
Java High-Performance Architecture
Java High-Performance Architecture
Aug 28, 2024 · Databases

NewSQL vs Sharding: Which Database Architecture Truly Wins?

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

HANewSQLScalability
0 likes · 18 min read
NewSQL vs Sharding: Which Database Architecture Truly Wins?
macrozheng
macrozheng
Aug 23, 2024 · Databases

NewSQL vs Middleware Sharding: Which Architecture Truly Wins?

This article objectively compares NewSQL databases with middleware‑based sharding solutions, examining architecture, distributed transactions, CAP constraints, high availability, scaling, SQL support, storage engines, and maturity to help readers choose the right approach for their workloads.

CAP theoremNewSQLdistributed databases
0 likes · 19 min read
NewSQL vs Middleware Sharding: Which Architecture Truly Wins?
21CTO
21CTO
Jul 30, 2024 · Databases

How Database Architectures Evolved Over 20 Years: From Columnar to Cloud & Beyond

This article surveys two decades of database system architecture innovations—including columnar stores, cloud databases, data lakes, NewSQL, hardware accelerators, and blockchain databases—highlighting their motivations, trade‑offs, and the shifting landscape that shapes modern DBMS design.

Columnar StorageDBMSNewSQL
0 likes · 23 min read
How Database Architectures Evolved Over 20 Years: From Columnar to Cloud & Beyond
Architect
Architect
Jul 29, 2024 · Databases

NewSQL vs Middleware Sharding: Which Architecture Truly Wins?

This article objectively compares NewSQL distributed databases with traditional middleware‑based sharding solutions, examining their architectures, transaction models, scalability, high‑availability mechanisms, storage engines, maturity, and offering a decision framework to help engineers choose the most suitable approach for their workloads.

CAP theoremDatabase ArchitectureNewSQL
0 likes · 20 min read
NewSQL vs Middleware Sharding: Which Architecture Truly Wins?
Architect's Guide
Architect's Guide
Jun 22, 2024 · Databases

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

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

Cloud NativeHTAPMySQL compatibility
0 likes · 23 min read
Understanding TiDB: NewSQL Features, Architecture, and Comparison with MySQL and NoSQL
Top Architect
Top Architect
Jun 19, 2024 · Databases

Choosing Between NewSQL Databases and Middleware‑Based Sharding: A Comparative Analysis

This article objectively compares NewSQL databases with middleware‑based sharding solutions, examining their architectures, distributed transaction handling, scalability, high‑availability mechanisms, storage engines, and suitability for various workloads, and provides guidance on selecting the appropriate approach based on specific system requirements.

CAP theoremDistributed TransactionsNewSQL
0 likes · 19 min read
Choosing Between NewSQL Databases and Middleware‑Based Sharding: A Comparative Analysis
Java Architect Essentials
Java Architect Essentials
May 19, 2024 · Databases

Choosing Between NewSQL Databases and Middleware‑Based Sharding: A Comparative Analysis

This article objectively compares NewSQL distributed databases with traditional middleware‑based sharding solutions, examining their architectures, distributed transaction support, high availability, scaling, storage engines, SQL capabilities, maturity, and suitability for various workloads, to help architects decide which approach best fits their needs.

Database ArchitectureDistributed TransactionsNewSQL
0 likes · 20 min read
Choosing Between NewSQL Databases and Middleware‑Based Sharding: A Comparative Analysis
Java High-Performance Architecture
Java High-Performance Architecture
May 12, 2024 · Databases

NewSQL vs Sharding: Which Database Architecture Truly Wins?

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

CAP theoremNewSQLScalability
0 likes · 18 min read
NewSQL vs Sharding: Which Database Architecture Truly Wins?
Selected Java Interview Questions
Selected Java Interview Questions
May 10, 2024 · Databases

Comparing NewSQL Databases with Middleware‑Based Sharding: Advantages, Limitations, and Practical Guidance

This article objectively compares NewSQL databases and middleware‑plus‑sharding architectures, examining their core principles, distributed transaction handling, high‑availability mechanisms, scaling and sharding strategies, SQL support, storage engines, and maturity to help engineers decide which solution fits their workload.

Database ArchitectureDistributed TransactionsNewSQL
0 likes · 18 min read
Comparing NewSQL Databases with Middleware‑Based Sharding: Advantages, Limitations, and Practical Guidance
Java Captain
Java Captain
Apr 26, 2024 · Databases

Choosing Between Sharding Middleware and NewSQL Distributed Databases: Advantages, Trade‑offs, and Use Cases

This article objectively compares middleware‑based sharding with modern NewSQL distributed databases, examining their architectural differences, performance, transaction support, scalability, high‑availability, and operational considerations, to help practitioners decide which approach best fits their workload and organizational constraints.

Database ArchitectureDistributed TransactionsNewSQL
0 likes · 20 min read
Choosing Between Sharding Middleware and NewSQL Distributed Databases: Advantages, Trade‑offs, and Use Cases
Architecture Digest
Architecture Digest
Apr 19, 2024 · Databases

Comparing NewSQL Distributed Databases with Middleware‑Based Sharding: Advantages, Trade‑offs, and Use Cases

The article objectively compares NewSQL distributed databases with traditional middleware‑based sharding solutions, examining their architectural differences, distributed transaction support, performance, scalability, high‑availability mechanisms, storage engines, and practical suitability for various application scenarios.

CAP theoremNewSQLScalability
0 likes · 18 min read
Comparing NewSQL Distributed Databases with Middleware‑Based Sharding: Advantages, Trade‑offs, and Use Cases
Selected Java Interview Questions
Selected Java Interview Questions
Apr 1, 2024 · Databases

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

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

Cloud NativeHTAPMySQL compatibility
0 likes · 22 min read
Understanding NewSQL and TiDB: Architecture, Features, and Comparison with Traditional Databases
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Mar 21, 2024 · Databases

What Makes Distributed Databases Tick? Features, Examples, and Real‑World Picks

This article explains what distributed databases are, outlines their four key characteristics—high performance, scalability, high availability, and data consistency—and reviews five prominent systems (OceanBase, TDSQL, Google Spanner, CockroachDB, and TiDB) that illustrate these concepts in real‑world applications.

Data ConsistencyNewSQLScalability
0 likes · 6 min read
What Makes Distributed Databases Tick? Features, Examples, and Real‑World Picks
Java Architect Essentials
Java Architect Essentials
Oct 12, 2023 · Databases

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

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

Cloud NativeDatabase ArchitectureHTAP
0 likes · 22 min read
TiDB Overview: Architecture, Features, Compatibility, and Use Cases
Java Architect Essentials
Java Architect Essentials
Sep 10, 2023 · Databases

Why TiDB Is the NewSQL Database Redefining OLTP & OLAP

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

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

Why TiDB Is the Leading NewSQL Database for HTAP Workloads

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

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

What Is NewSQL? Exploring TiDB’s Distributed Database Features

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

Database ArchitectureHTAPMySQL compatibility
0 likes · 24 min read
What Is NewSQL? Exploring TiDB’s Distributed Database Features
Top Architect
Top Architect
Jul 31, 2023 · Databases

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

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

HTAPMySQL compatibilityNewSQL
0 likes · 24 min read
TiDB Overview: NewSQL Features, Architecture, Compatibility, and Application Scenarios
Su San Talks Tech
Su San Talks Tech
Jul 24, 2023 · Databases

How TiDB’s NewSQL Design Solves Traditional Database Limits

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

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

Mid‑Year 2023 Database Industry Roundup: Major Releases and Trends

The 2023 first‑half newsletter compiles a comprehensive overview of the database sector, highlighting the surge of domestic vendors, key technological breakthroughs such as HTAP and serverless, and detailed version updates across RDBMS, NewSQL, graph, time‑series, big‑data, and cloud databases, offering valuable insights for practitioners and decision‑makers.

Big DataIndustry ReportNewSQL
0 likes · 48 min read
Mid‑Year 2023 Database Industry Roundup: Major Releases and Trends
JD Retail Technology
JD Retail Technology
May 26, 2023 · Databases

Overview of Database Evolution, Types, and Data Structure Design

This article traces the history of database development from early file systems to relational models, outlines major database categories such as hierarchical, relational, NoSQL, NewSQL, and columnar stores, and explores practical data structure designs like chain tables, bitwise operations, and circular queues for modern software engineering.

Data StructuresHashingNewSQL
0 likes · 28 min read
Overview of Database Evolution, Types, and Data Structure Design
Su San Talks Tech
Su San Talks Tech
Apr 11, 2023 · Databases

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

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

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

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

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

HTAPMySQL compatibilityNewSQL
0 likes · 26 min read
Understanding TiDB: NewSQL Features, Architecture, and Comparison with MySQL
IT Architects Alliance
IT Architects Alliance
Nov 16, 2022 · Backend Development

How to Transform a Simple Blog into a Scalable High‑Traffic System

This article walks through turning a basic personal‑blog architecture—single server, MySQL, and Node.js—into a high‑concurrency system by adding Redis caching, Nginx load balancing, horizontal scaling, read‑write splitting, sharding, NewSQL databases, and message‑queue techniques.

BackendNewSQLScalability
0 likes · 15 min read
How to Transform a Simple Blog into a Scalable High‑Traffic System
Top Architect
Top Architect
Nov 15, 2022 · Backend Development

Scaling a Personal Blog: Caching, Load Balancing, Read/Write Splitting, Sharding, and NewSQL

This article explains how to transform a simple personal‑blog backend into a high‑performance, horizontally scalable system by introducing caching with Redis, load balancing with Nginx/LVS, read/write separation, database sharding, and modern NewSQL solutions such as TiDB, while also discussing related challenges like cache consistency and data migration.

NewSQLmysqlread/write splitting
0 likes · 14 min read
Scaling a Personal Blog: Caching, Load Balancing, Read/Write Splitting, Sharding, and NewSQL
IT Architects Alliance
IT Architects Alliance
Feb 17, 2022 · Databases

Understanding Consistency in Distributed Transactions: Strong vs. Weak, CAP Theory, and NewSQL Approaches

This article explains the concept of consistency in distributed transactions, compares strong and weak consistency, relates it to the CAP theorem, and explores theoretical and practical approaches—including XA, NewSQL, and MVCC—to achieve stronger consistency across databases and micro‑services.

ACIDCAP theoremConsistency
0 likes · 13 min read
Understanding Consistency in Distributed Transactions: Strong vs. Weak, CAP Theory, and NewSQL Approaches
dbaplus Community
dbaplus Community
Nov 7, 2021 · Databases

Why Distributed Databases Matter: From Early DBMS to Modern NewSQL

This article traces the evolution of database systems—from the first network and hierarchical models through relational databases, NoSQL sharding, and finally modern distributed SQL—explaining why distributed databases emerged, how they handle data distribution, consistency, SQL-to‑KV mapping, and transaction challenges.

NewSQLSQL to KVconsensus algorithms
0 likes · 16 min read
Why Distributed Databases Matter: From Early DBMS to Modern NewSQL
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
JD Cloud Developers
JD Cloud Developers
Mar 5, 2021 · Databases

How Transparent Sharding Middleware Powers NewSQL: Core Functions Explained

This article explains the fundamentals of transparent sharding middleware in NewSQL systems, covering data partitioning strategies, read/write separation, the complete SQL processing pipeline, protocol adaptation for MySQL/PostgreSQL, distributed transaction models such as XA, Saga and TCC, and essential database governance and online scaling techniques.

Database GovernanceDatabase MiddlewareDistributed Transactions
0 likes · 28 min read
How Transparent Sharding Middleware Powers NewSQL: Core Functions Explained
Top Architect
Top Architect
Feb 11, 2021 · Databases

Case Study: Scaling Zhihu’s Moneta Application with TiDB

This article details how Zhihu’s Moneta service, handling over a trillion rows of user‑read data, migrated from MySQL sharding and MHA to the open‑source NewSQL database TiDB, achieving millisecond‑level query latency, high write throughput, and improved scalability through a layered architecture and TiDB’s advanced features.

HTAPMonetaNewSQL
0 likes · 13 min read
Case Study: Scaling Zhihu’s Moneta Application with TiDB
Architects' Tech Alliance
Architects' Tech Alliance
Feb 4, 2021 · Databases

What Makes NewSQL Databases Advanced? A Comparative Analysis with Middleware‑Based Sharding

This article objectively compares NewSQL distributed databases with traditional middleware‑plus‑sharding solutions, examining architecture, distributed transactions, CAP constraints, high‑availability, scaling, storage engines, maturity, and practical adoption scenarios to help readers decide which approach best fits their needs.

NewSQLTransactional Consistencydistributed databases
0 likes · 17 min read
What Makes NewSQL Databases Advanced? A Comparative Analysis with Middleware‑Based Sharding
Architecture Digest
Architecture Digest
Feb 1, 2021 · Databases

Comparing NewSQL Distributed Databases with Middleware‑Based Sharding: Advantages, Trade‑offs, and Application Scenarios

This article objectively compares NewSQL distributed databases with traditional middleware‑plus‑sharding solutions, examining their architectural differences, distributed transaction handling, high‑availability mechanisms, scaling and sharding strategies, SQL support, storage engines, and maturity to help practitioners decide which approach best fits their workload and operational constraints.

Database ArchitectureNewSQLScalability
0 likes · 17 min read
Comparing NewSQL Distributed Databases with Middleware‑Based Sharding: Advantages, Trade‑offs, and Application Scenarios
Programmer DD
Programmer DD
Jan 12, 2021 · Databases

NewSQL vs Sharding: Which Database Architecture Truly Wins?

This article objectively compares NewSQL distributed databases with middleware‑based sharding solutions, examining their architectural differences, distributed transaction handling, high‑availability mechanisms, scaling and sharding strategies, SQL support, storage engines, and overall maturity to help readers decide which approach best fits their workload.

NewSQLdistributed databaseshigh availability
0 likes · 21 min read
NewSQL vs Sharding: Which Database Architecture Truly Wins?
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
Programmer DD
Programmer DD
Apr 29, 2020 · Databases

NewSQL vs Sharding: Which Database Architecture Truly Wins?

This article objectively compares NewSQL databases with middleware‑based sharding approaches, examining their architectural differences, transaction models, CAP implications, high‑availability designs, scaling mechanisms, storage engines, maturity, and provides a decision guide to help engineers choose the right solution for their workloads.

Distributed TransactionsNewSQLdatabase scaling
0 likes · 17 min read
NewSQL vs Sharding: Which Database Architecture Truly Wins?
Architecture Digest
Architecture Digest
Apr 19, 2020 · Databases

Sharding (Partitioning) vs NewSQL Databases: A Comparative Analysis

This article objectively compares traditional sharding‑plus‑middleware architectures with modern NewSQL distributed databases, examining their design principles, distributed transaction handling, high‑availability mechanisms, scaling and sharding strategies, SQL support, storage engines, and overall maturity to help practitioners choose the most suitable solution for their workloads.

Database ArchitectureNewSQLhigh availability
0 likes · 21 min read
Sharding (Partitioning) vs NewSQL Databases: A Comparative Analysis
Java Backend Technology
Java Backend Technology
Apr 6, 2020 · Databases

Why NewSQL Databases Outperform Middleware Sharding? A Deep Comparison

This article objectively compares NewSQL databases with middleware‑based sharding solutions, examining architecture, distributed transactions, CAP constraints, performance, high availability, scaling, SQL support, storage engines, maturity, and provides practical guidance for choosing the right approach.

CAP theoremNewSQLdistributed databases
0 likes · 18 min read
Why NewSQL Databases Outperform Middleware Sharding? A Deep Comparison
dbaplus Community
dbaplus Community
Jan 15, 2020 · Databases

How Didi Built Fusion-NewSQL: A High‑Throughput, Low‑Latency NewSQL on Distributed KV

Fusion-NewSQL is Didi’s internally‑developed NewSQL system built atop the Fusion distributed KV store, offering MySQL compatibility, high throughput, low latency, flexible schema changes, secondary indexes, and integration with ElasticSearch and Hive, with detailed architecture, data flow, and future roadmap.

MySQL compatibilityNewSQLdistributed storage
0 likes · 16 min read
How Didi Built Fusion-NewSQL: A High‑Throughput, Low‑Latency NewSQL on Distributed KV
58 Tech
58 Tech
Nov 8, 2019 · Databases

Design and Optimization Practices of 58.com Distributed KV Storage System (WTable)

The article details the three‑stage evolution of 58.com’s distributed key‑value storage system WTable, covering its initial architecture, performance and operational optimizations, and the introduction of NewSQL‑style strong consistency and Raft‑based replication to improve scalability and reliability.

NewSQLSystem Architecturedistributed storage
0 likes · 9 min read
Design and Optimization Practices of 58.com Distributed KV Storage System (WTable)
Didi Tech
Didi Tech
Oct 8, 2019 · Databases

Design and Implementation of Fusion-NewSQL: A NewSQL System Built on Distributed NoSQL Storage

Fusion‑NewSQL is a NewSQL layer built atop Didi’s distributed KV store Fusion, translating MySQL queries into Redis‑style hashmaps, asynchronously maintaining secondary indexes, supporting fast Hive‑to‑Fusion loads and Elasticsearch integration, thereby delivering over 2 million QPS, 600 TB storage and flexible schema evolution for dozens of services.

MySQL compatibilityNewSQLfusion
0 likes · 15 min read
Design and Implementation of Fusion-NewSQL: A NewSQL System Built on Distributed NoSQL Storage
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 12, 2019 · Databases

Choosing Between NewSQL Databases and Middleware‑Based Sharding: A Comparative Analysis

This article objectively compares NewSQL distributed databases with middleware‑based sharding solutions, examining their architectures, distributed transaction handling, scalability, performance, high‑availability, and operational considerations, and provides guidance on selecting the appropriate approach based on workload, consistency, and organizational constraints.

CAP theoremDistributed TransactionsNewSQL
0 likes · 19 min read
Choosing Between NewSQL Databases and Middleware‑Based Sharding: A Comparative Analysis
21CTO
21CTO
Aug 6, 2019 · Databases

Why SQL Is Making a Comeback: From NoSQL’s Rise to the New Data Era

This article explores the resurgence of SQL, tracing its historical roots, the rise and limitations of NoSQL, and how modern cloud and NewSQL solutions are re‑establishing SQL as the universal interface for data storage, processing, and analysis.

NewSQLNoSQLSQL
0 likes · 14 min read
Why SQL Is Making a Comeback: From NoSQL’s Rise to the New Data Era
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
dbaplus Community
dbaplus Community
Jun 1, 2019 · Databases

What Drives TiDB’s Architecture? The Philosophy Behind a NewSQL Database

The article explores TiDB’s evolution philosophy, detailing its core beliefs, early user stories, and the three‑step "Make it work, make it right, make it fast" approach, while covering technical choices such as cloud‑first design, hardware‑agnosticism, formal verification, massive testing, performance tuning, and cost‑effective scaling.

NewSQLTiDBarchitecture
0 likes · 32 min read
What Drives TiDB’s Architecture? The Philosophy Behind a NewSQL Database
Didi Tech
Didi Tech
May 23, 2019 · Databases

Fusion: Didi’s Self‑Developed NewSQL System and Its Evolution from a NoSQL Platform

Fusion, Didi’s home‑grown C++ NoSQL database built on RocksDB, powers over 400 services and 1.5 PB of data, then evolved into the NewSQL layer dise with schema, secondary indexes, transactions and MySQL‑compatible binlog, and now guides a next‑gen distributed database project targeting true elastic scaling, distributed transactions and full SQL compatibility.

Database ArchitectureNewSQLNoSQL
0 likes · 24 min read
Fusion: Didi’s Self‑Developed NewSQL System and Its Evolution from a NoSQL Platform
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
58 Tech
58 Tech
May 14, 2019 · Databases

Designing Structured Table and Index Storage in RocksDB for NewSQL Systems

This article explains how to map relational table rows and various indexes—including primary key, integer, float, string, and composite indexes—into RocksDB key‑value pairs using custom serialization, big‑endian ordering, and encoding functions to enable efficient point, range, and multi‑field queries.

NewSQLRocksDBindexing
0 likes · 14 min read
Designing Structured Table and Index Storage in RocksDB for NewSQL Systems
Tencent Cloud Developer
Tencent Cloud Developer
Mar 26, 2019 · Databases

Technical Overview of Tencent Cloud CynosDB Distributed Storage and Compute‑Storage Separation Architecture

The Beijing technical exchange detailed Tencent Cloud CynosDB’s compute-storage separation architecture, explaining how CynosStore’s block and file-system layers asynchronously persist write-ahead logs via Raft, provide multi-transaction atomicity, continuous snapshots, and rapid recovery, while benchmarks demonstrate high log-throughput and the Q&A covered tenancy, failover, and scaling.

CynosDBDatabase ArchitectureNewSQL
0 likes · 14 min read
Technical Overview of Tencent Cloud CynosDB Distributed Storage and Compute‑Storage Separation Architecture
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
dbaplus Community
dbaplus Community
Jan 13, 2019 · Databases

January 2019 DB-Engines Newsletter: Latest Database Releases & Key Features

The January 2019 DB-Engines newsletter compiles the newest releases, feature highlights, and performance improvements across RDBMS, NoSQL, NewSQL, time‑series, big‑data, domestic, and cloud database families, while also explaining the ranking methodology and providing download links for the full issue.

Big DataNewSQLNoSQL
0 likes · 41 min read
January 2019 DB-Engines Newsletter: Latest Database Releases & Key Features
Tencent Cloud Developer
Tencent Cloud Developer
Dec 20, 2018 · Databases

CynosDB Architecture and Optimization: A PostgreSQL-Compatible NewSQL Database

CynosDB, Tencent’s PostgreSQL‑compatible NewSQL service, separates compute and storage, uses a log‑based distributed CynosStore with idempotent logs, offloads CRC checks, and implements async table extension, eliminating full‑page writes and dirty‑page flushing to deliver scalable, cost‑effective performance while preserving PostgreSQL features.

CynosDBDatabase ArchitectureLog System Optimization
0 likes · 12 min read
CynosDB Architecture and Optimization: A PostgreSQL-Compatible NewSQL Database
Tencent Cloud Developer
Tencent Cloud Developer
Sep 11, 2018 · Databases

CynosDB Architecture and Core Mechanisms: A Comprehensive Technical Overview

CynosDB is Tencent Cloud’s high‑performance, highly‑available NewSQL distributed database that uses a shared‑storage architecture with primary and replica instances, log‑structured storage, RDMA/SPDK transmission, Raft consensus, SSI MVCC, two‑phase locking, and state‑machine replication to provide elastic scaling, fast recovery, and cost‑effective enterprise data management.

CynosDBMVCCNewSQL
0 likes · 17 min read
CynosDB Architecture and Core Mechanisms: A Comprehensive Technical Overview
AntTech
AntTech
Aug 7, 2018 · Databases

A Timeline Review of Optimistic Concurrency Control (OCC) from Theory to Production Systems

This article presents a chronological overview of Optimistic Concurrency Control (OCC), covering its early theoretical foundations, key research papers, prototype implementations such as MVCC+OCC+2PC and Hekaton, and its adoption in modern distributed NewSQL databases like Megastore, F1, and MaaT, highlighting both advantages and challenges.

Concurrency ControlDatabase TransactionsDistributed Systems
0 likes · 33 min read
A Timeline Review of Optimistic Concurrency Control (OCC) from Theory to Production Systems
Architecture Digest
Architecture Digest
Jun 22, 2018 · Databases

Distributed Databases for OLAP: MPP, Hadoop Ecosystem, and Like‑Mesa (ClickHouse/Palo) Overview

This article examines the evolution and classification of distributed databases for OLAP workloads, comparing traditional RDBMS, MPP solutions such as Teradata and Greenplum, Hadoop‑based ecosystems, and newer architectures like ClickHouse and Palo, while highlighting their architectural traits, strengths, and limitations.

ClickHouseHadoopMPP
0 likes · 17 min read
Distributed Databases for OLAP: MPP, Hadoop Ecosystem, and Like‑Mesa (ClickHouse/Palo) Overview
Tencent Cloud Developer
Tencent Cloud Developer
Jun 12, 2018 · Cloud Native

CynosDB: Tencent Cloud's Next-Generation Enterprise Distributed Cloud Database

CynosDB, Tencent Cloud’s next‑generation enterprise distributed database, re‑architects MySQL with compute‑storage separation, distributed high‑availability storage, and RDMA‑accelerated low‑latency replication, delivering extreme performance, scalability, sub‑millisecond response times, and nine‑nine data reliability for cloud‑native applications.

Cloud NativeCompute-Storage SeparationCynosDB
0 likes · 9 min read
CynosDB: Tencent Cloud's Next-Generation Enterprise Distributed Cloud Database
Qunar Tech Salon
Qunar Tech Salon
May 11, 2018 · Databases

Minsheng Bank’s Distributed Transformation and NewSQL Practice with SequoiaDB

The article details Minsheng Bank’s shift to distributed architecture, outlining regulatory drivers, business requirements, the adoption of sharding, cross‑center high‑availability, and new‑type distributed databases, and showcases performance results of SequoiaDB 3.0 across multiple high‑throughput banking scenarios.

BankingDistributed SystemsNewSQL
0 likes · 9 min read
Minsheng Bank’s Distributed Transformation and NewSQL Practice with SequoiaDB
dbaplus Community
dbaplus Community
May 6, 2018 · Databases

NewSQL Explained: Storage Engines, Sharding, and Distributed Transactions

This article examines the core technologies behind NewSQL databases for OLTP workloads, contrasting them with NoSQL and traditional relational systems by exploring storage engines such as B‑Tree and LSM‑Tree, sharding strategies, replication models, and distributed transaction mechanisms like two‑phase commit.

NewSQLReplicationStorage Engines
0 likes · 20 min read
NewSQL Explained: Storage Engines, Sharding, and Distributed Transactions
dbaplus Community
dbaplus Community
Mar 18, 2018 · Databases

What’s New in the Database World? March 2018 Release Roundup

The March 2018 DBAplus Newsletter compiles the latest releases across RDBMS, NoSQL, NewSQL, time‑series and big‑data ecosystems, highlighting new features, performance improvements, compatibility updates and key technical links for Oracle, MySQL, MariaDB, SQL Server, DB2, PostgreSQL, TiDB, CockroachDB, InfluxDB, Hadoop and several Chinese‑made databases.

Big DataDatabase ReleasesHTAP
0 likes · 21 min read
What’s New in the Database World? March 2018 Release Roundup
ITPUB
ITPUB
Jan 27, 2018 · Databases

Why NewSQL Matters: From Relational Roots to Modern HTAP

This article traces the evolution of database systems—from early navigational models and Codd's relational theory through the rise of NoSQL and sharding, to the resurgence of NewSQL and the emerging HTAP paradigm—highlighting technical motivations, design trade‑offs, and future directions.

HTAPNewSQLSQL
0 likes · 21 min read
Why NewSQL Matters: From Relational Roots to Modern HTAP
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
dbaplus Community
dbaplus Community
Dec 18, 2017 · Databases

How Aurora Redefines Cloud‑Native Relational Databases: Architecture, Benefits, and Limits

This article interprets the 2017 SIGMOD paper on Amazon Aurora, explaining its cloud‑native architecture, key advantages such as self‑healing storage and reduced network I/O, the challenges it introduces, a comparison with traditional databases and TiDB, and insights into deployment, replication, and recovery mechanisms.

Amazon AuroraDatabase ArchitectureNewSQL
0 likes · 26 min read
How Aurora Redefines Cloud‑Native Relational Databases: Architecture, Benefits, and Limits
Tongcheng Travel Technology Center
Tongcheng Travel Technology Center
Nov 14, 2017 · Backend Development

Highlights of the First Tongcheng Technology Conference in Suzhou: Serverless, Microservices, Go, NewSQL, Hybrid Cloud, and Ticket Search Architecture

The two‑day Tongcheng Technology Conference in Suzhou featured six technical sessions covering serverless architecture, microservices with Go, Facebook‑style development tools, NewSQL database practices, hybrid cloud management at Sina Weibo, and high‑performance ticket search systems, offering practical insights for backend engineers.

Backend ArchitectureGoMicroservices
0 likes · 10 min read
Highlights of the First Tongcheng Technology Conference in Suzhou: Serverless, Microservices, Go, NewSQL, Hybrid Cloud, and Ticket Search Architecture
dbaplus Community
dbaplus Community
Apr 27, 2017 · Databases

What’s New in Databases? April 2017 DBAplus Newsletter Highlights

The April 2017 DBAplus Newsletter compiles the latest database releases, DB‑Engines ranking data, feature updates for Oracle, MySQL, MariaDB, SQL Server, PostgreSQL, Hadoop, and emerging domestic systems, while summarizing key new‑SQL, NoSQL, and big‑data developments for database professionals.

DB-EnginesNewSQLNoSQL
0 likes · 21 min read
What’s New in Databases? April 2017 DBAplus Newsletter Highlights
dbaplus Community
dbaplus Community
Feb 21, 2017 · Databases

What Do DB‑Engines Trends Reveal About the Future of Databases?

The DBAplus Newsletter reviews recent DB‑Engines ranking trends, highlights major releases across RDBMS, NoSQL, NewSQL and big‑data ecosystems, analyzes shifting market dynamics, and lists upcoming community events and resources for database professionals.

DB-EnginesDatabase TrendsNewSQL
0 likes · 22 min read
What Do DB‑Engines Trends Reveal About the Future of Databases?
Architecture Digest
Architecture Digest
Dec 12, 2016 · Databases

Why NewSQL? Classification, Technical Challenges, and Discussion

This article reviews the motivations behind NewSQL, outlines its three main classifications, examines the technical challenges such as memory storage, sharding, concurrency control, replication and crash recovery, and provides a discussion on its scalability and architectural trade‑offs.

NewSQLmiddleware
0 likes · 11 min read
Why NewSQL? Classification, Technical Challenges, and Discussion
StarRing Big Data Open Lab
StarRing Big Data Open Lab
Nov 11, 2016 · Big Data

Why SQL Still Rules Big Data—and How NoSQL & NewSQL Fit In

The article explores the evolution of data processing from Hadoop and Spark to modern SQL, NoSQL, and NewSQL solutions, comparing their architectures, performance trade‑offs, and use‑cases, while illustrating concepts with examples like MapReduce, Hive, Impala, and streaming platforms such as Storm.

Big DataHadoopNewSQL
0 likes · 14 min read
Why SQL Still Rules Big Data—and How NoSQL & NewSQL Fit In
ITPUB
ITPUB
Aug 30, 2016 · Databases

How to Build a Distributed KV Store with Full ACID Guarantees

This talk walks through the evolution of databases, explains the challenges of building a distributed key‑value system that provides full ACID properties, and details the architectural components, sharding, migration, snapshot isolation, two‑phase commit, timestamp handling, and distributed transaction processing techniques.

ACIDDistributed SystemsNewSQL
0 likes · 13 min read
How to Build a Distributed KV Store with Full ACID Guarantees