MySQL Compatibility

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.

Distributed DatabaseHTAPMySQL Compatibility

0 likes · 20 min read

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

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.

Distributed DatabaseHTAPMySQL Compatibility

0 likes · 21 min read

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

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.

Distributed DatabaseHTAPMySQL Compatibility

0 likes · 23 min read

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

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.

Distributed DatabaseHTAPMySQL Compatibility

0 likes · 22 min read

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

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.

Database ArchitectureDistributed DatabaseHTAP

0 likes · 22 min read

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

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.

Distributed DatabaseHTAPMySQL Compatibility

0 likes · 24 min read

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

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.

Distributed DatabaseHTAPMySQL Compatibility

0 likes · 26 min read

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

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

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.

Distributed DatabaseMySQL CompatibilityOceanBase

0 likes · 8 min read

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.

Distributed DatabaseDocker ComposeGreatSQL

0 likes · 8 min read

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

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.

Distributed DatabaseMySQL CompatibilityTiDB

0 likes · 12 min read

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

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.

Distributed DatabaseHTAPMySQL Compatibility

0 likes · 13 min read

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.

Distributed StorageIndexingMySQL Compatibility

0 likes · 15 min read

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

DataFunTalk

Jul 4, 2019 · Databases

An Overview of Apache Doris: Architecture, Key Technologies, and Real‑World Use Cases

This article introduces Apache Doris, a massively parallel processing (MPP) distributed database, covering its background, core architecture, key technologies such as reliability, maintenance, MySQL compatibility, materialized views, and real‑world applications at Baidu and beyond.

Data WarehouseDistributed DatabaseDoris

0 likes · 12 min read

An Overview of Apache Doris: Architecture, Key Technologies, and Real‑World Use Cases

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.

Distributed DatabaseKubernetesMySQL Compatibility

0 likes · 8 min read

Case Study: Scaling Ticketing System with TiDB at Tongcheng

Tongcheng Travel Technology Center

Apr 11, 2018 · Databases

Case Study: Scaling Ticketing and Flight Booking Systems with TiDB at Tongcheng Network

This article details how Tongcheng Network migrated massive ticketing and flight‑booking workloads to TiDB, combining sharding and a distributed SQL database to handle terabytes of data, real‑time monitoring, and high QPS traffic while simplifying operations and reducing costs.

Distributed DatabaseMySQL CompatibilityScaling

0 likes · 8 min read

Case Study: Scaling Ticketing and Flight Booking Systems with TiDB at Tongcheng Network

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.

Distributed DatabaseMySQL CompatibilityRaft

0 likes · 16 min read

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