BestHub
Sign in
Tagged articles
32 articles
Page 1 of 1
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
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
Architect's Guide
Architect's Guide
May 8, 2025 · Databases

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

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

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

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

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

HTAPMySQL compatibilityNewSQL
0 likes · 21 min read
TiDB Overview: Distributed NewSQL Database, Architecture, Features, and MySQL Compatibility
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
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
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
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
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 16, 2023 · Databases

Deploying OceanBase 4.X as a Minimal Single‑Node Distributed Database

This article demonstrates how to deploy OceanBase 4.X in a minimal single‑node configuration, explains the key resource parameters, provides the necessary YAML configuration and command‑line steps to start the server, create a MySQL‑compatible tenant, and verify resource usage and basic database operations.

Database ConfigurationMySQL compatibilityOceanBase
0 likes · 7 min read
Deploying OceanBase 4.X as a Minimal Single‑Node Distributed Database
AntTech
AntTech
Aug 23, 2022 · Databases

OceanBase 4.0 Core Technology Overview

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

MySQL compatibilityOceanBasePaxos
0 likes · 8 min read
OceanBase 4.0 Core Technology Overview
dbaplus Community
dbaplus Community
Jul 20, 2022 · Databases

From Middleware to Distributed Database: The Evolution of PolarDB‑X

PolarDB‑X evolved from Alibaba’s internal sharding middleware TDDL to the DRDS cloud service and finally to a fully distributed MySQL‑compatible database, introducing a full SQL optimizer, MPP engine, global secondary indexes, strong‑consistent distributed transactions via TSO + 2PC, and full binlog compatibility.

MySQL compatibilityPolarDB-Xglobal index
0 likes · 26 min read
From Middleware to Distributed Database: The Evolution of PolarDB‑X
Java Architecture Diary
Java Architecture Diary
Aug 30, 2021 · Databases

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

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

Docker ComposeGreatSQLMGR
0 likes · 8 min read
How to Build a High‑Availability GreatSQL MGR Cluster with Docker‑Compose
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
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 Tech Engineering
360 Tech Engineering
Jun 19, 2020 · Databases

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

This article explains how TiDB, a MySQL‑compatible distributed NewSQL database, solves large‑table performance issues with horizontal scaling, describes its core components, deployment guidelines, key advantages, and practical tips such as avoiding auto‑increment IDs, handling hotspots, version quirks, backup strategies, and monitoring with Grafana.

MySQL compatibilityPerformance OptimizationTiDB
0 likes · 12 min read
TiDB Overview: Architecture, Deployment, Advantages, and Practical Tips
360 Quality & Efficiency
360 Quality & Efficiency
Jun 19, 2020 · Databases

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

This article introduces TiDB, an open‑source distributed HTAP database compatible with MySQL, explains its architecture—including TiDB Server, PD, TiKV, and TiSpark—covers deployment requirements, highlights key advantages such as elastic scaling, fault‑tolerance, strong consistency, and provides practical tips and common pitfalls for production use.

DeploymentHTAPMySQL compatibility
0 likes · 13 min read
TiDB Overview: Architecture, Deployment, Advantages, and Practical Tips
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
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
Architecture Digest
Architecture Digest
Apr 21, 2018 · Databases

Case Study: Scaling Ticketing System with TiDB at Tongcheng

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

KubernetesMySQL compatibilityTiDB
0 likes · 8 min read
Case Study: Scaling Ticketing System with TiDB at Tongcheng
UCloud Tech
UCloud Tech
Jan 19, 2018 · Databases

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

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

MySQL compatibilitySQL parsingdistributed database
0 likes · 15 min read
From Middleware to Distributed Database: UDDB’s Evolution and Architecture
Architecture Digest
Architecture Digest
Feb 8, 2017 · Databases

The Evolution and Architecture of TiDB: From MySQL Compatibility to Distributed Storage

TiDB’s founder Huang Dongxu recounts the journey of building a MySQL‑compatible, distributed database—detailing early challenges, architectural decisions, the extensive testing, the adoption of Go, Rust, Raft, RocksDB, and the emphasis on metrics, cloud‑native design, and open‑source community collaboration.

MySQL compatibilityRaftRocksDB
0 likes · 16 min read
The Evolution and Architecture of TiDB: From MySQL Compatibility to Distributed Storage
WeChat Backend Team
WeChat Backend Team
Sep 8, 2016 · Databases

Why PhxSQL Rejects Multi-Write, Sharding, and Serializability: Design Trade‑offs

This article explains how PhxSQL prioritizes strong linearizable consistency, high availability, serializable isolation, and full MySQL compatibility, and why it deliberately forgoes features such as multi‑write, sharding, and strict serializable isolation due to the high cost of distributed transactions and protocol complexity.

ConsistencyMySQL compatibilityPhxSQL
0 likes · 17 min read
Why PhxSQL Rejects Multi-Write, Sharding, and Serializability: Design Trade‑offs