Tagged articles

distributed database

232 articles · Page 3 of 3
dbaplus Community
dbaplus Community
Oct 10, 2018 · Databases

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

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

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

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

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

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

OceanBase 2.0 Release: Technical Overview and Innovations

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

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

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

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

Data MigrationHigh AvailabilityMonitoring
0 likes · 10 min read
Case Study of iQIYI’s Adoption of TiDB for Scalable High‑Availability Database Services
AntTech
AntTech
Jul 31, 2018 · Databases

High Availability and Disaster Recovery Strategies for OceanBase Distributed Database

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

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

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

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

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

Case Study: Scaling Ticketing System with TiDB at Tongcheng

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

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

Reflections on Building OceanBase: A Distributed Relational Database Journey

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

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

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

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

MiddlewareMySQL CompatibilitySQL parsing
0 likes · 15 min read
From Middleware to Distributed Database: UDDB’s Evolution and Architecture
High Availability Architecture
High Availability Architecture
Dec 19, 2017 · Databases

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

PingCAP co‑founder and CEO Liu Qi discusses the motivation behind creating TiDB, its evolution into a HTAP NewSQL database, key development priorities such as SQL enhancements, storage engine innovation, cloud‑native integration, and shares insights on open‑source project management and future database trends.

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

TiDB Architecture, Deployment, and Monitoring Practices at Qunar

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

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

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

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

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

Alibaba’s Secrets to Scaling HBase for PB‑Level Big Data

This article explains how Alibaba built, customized, and operated a massive HBase platform—covering its architecture, high‑availability design, asynchronous and synchronous replication, multi‑link data flow, cost‑aware redundancy, cross‑cluster migration, performance optimizations, and future directions for the distributed NoSQL database.

AlibabaHBasedistributed database
0 likes · 29 min read
Alibaba’s Secrets to Scaling HBase for PB‑Level Big Data
AntTech
AntTech
Feb 28, 2017 · Databases

The Rise of OceanBase: China’s Homegrown Distributed Database Behind Alibaba’s Double‑11 Peaks

OceanBase, a homegrown distributed database developed by a small Ant Group team, overcame technical and cultural challenges to power Alibaba’s record‑breaking Double‑11 payment peaks, earning international recognition and illustrating China’s push to break the Western monopoly on core database technology.

AlibabaAnt GroupDatabase Innovation
0 likes · 12 min read
The Rise of OceanBase: China’s Homegrown Distributed Database Behind Alibaba’s Double‑11 Peaks
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
Architecture Digest
Architecture Digest
Jun 9, 2016 · Databases

Understanding HBase Architecture and Core Principles

This article provides a comprehensive overview of HBase, covering its distributed architecture, component roles, data organization, read/write mechanisms, and best practices for schema and region design to ensure efficient big‑data storage and retrieval.

Big DataData StorageHBase
0 likes · 17 min read
Understanding HBase Architecture and Core Principles
Architecture Digest
Architecture Digest
May 21, 2016 · Databases

An Overview of MyCat: Open‑Source Distributed Database Middleware and Its Technical Features

The article introduces MyCat, an open‑source distributed database middleware that provides transparent sharding, multi‑backend support, AI‑driven catlet extensions, and advanced read‑write splitting to enable low‑cost migration of single‑node databases to cloud environments while addressing performance and scalability challenges.

Database MiddlewareMycatOpen Source
0 likes · 9 min read
An Overview of MyCat: Open‑Source Distributed Database Middleware and Its Technical Features
Architecture Digest
Architecture Digest
Feb 27, 2016 · Databases

Architecture and Design of TDSQL: A Distributed MySQL‑Based SQL System for High‑Consistency Billing

The article analyzes the architecture of TDSQL, a MySQL‑based distributed SQL system designed for Tencent’s billing platform, detailing its transition from an in‑memory NoSQL solution to a high‑consistency, auto‑scaling, fault‑tolerant database with sharding, scheduler, agent, and gateway components.

High AvailabilityMySQLScaling
0 likes · 17 min read
Architecture and Design of TDSQL: A Distributed MySQL‑Based SQL System for High‑Consistency Billing
Architect
Architect
Nov 7, 2015 · Databases

Design and Implementation of the NewSQL Distributed Database TiDB

This article presents a comprehensive technical overview of TiDB, a NewSQL distributed database, covering its architecture, SQL layer, KV engine, distributed transaction mechanisms, code implementation in Go, open‑source practices, and future roadmap.

GoKV storeNewSQL
0 likes · 23 min read
Design and Implementation of the NewSQL Distributed Database TiDB
Qunar Tech Salon
Qunar Tech Salon
Nov 5, 2015 · Databases

Design and Architecture of TDSQL: A Distributed MySQL‑Based SQL System

The article describes how the limitations of an in‑memory NoSQL HOLD platform led to the creation of TDSQL, a distributed MySQL‑based SQL system featuring ZooKeeper‑coordinated Scheduler, Agent, and Gateway modules, automatic cross‑IDC disaster recovery, transparent horizontal scaling, strong synchronous replication, and future integration with container technologies.

High AvailabilityMySQLSharding
0 likes · 19 min read
Design and Architecture of TDSQL: A Distributed MySQL‑Based SQL System
21CTO
21CTO
Sep 16, 2015 · Databases

How TDSQL Achieves Scalable, High‑Availability Distributed SQL on MySQL

This article explains how TDSQL transforms MySQL into a distributed, high‑availability SQL system by addressing NoSQL limitations, introducing a Scheduler‑Agent‑Gateway architecture, automatic scaling, sharding, robust disaster‑recovery mechanisms, and future integration with container technologies.

Auto ScalingHigh AvailabilityMySQL
0 likes · 19 min read
How TDSQL Achieves Scalable, High‑Availability Distributed SQL on MySQL

An Overview of MyCat: Open‑Source Distributed Database Middleware and Its Core Features

MyCat is an open‑source distributed database middleware that transparently shreds tables across multiple backend databases, solves connection overload, provides ER‑based sharding, global partitioning, AI‑driven catlets, and advanced read‑write separation, enabling low‑cost migration of single‑node databases to the cloud.

AI catletDatabase MiddlewareMycat
0 likes · 9 min read
An Overview of MyCat: Open‑Source Distributed Database Middleware and Its Core Features

Design and Implementation of TDSQL: A Distributed High‑Consistency MySQL‑Based Storage System

The article describes the evolution, architecture, automatic scaling, sharding, disaster‑recovery mechanisms, and strong synchronous replication strategy of TDSQL, a MySQL‑engine based distributed database built to meet the high‑availability and high‑consistency requirements of Tencent's billing platform.

MySQLShardingTDSQL
0 likes · 18 min read
Design and Implementation of TDSQL: A Distributed High‑Consistency MySQL‑Based Storage System
Qunar Tech Salon
Qunar Tech Salon
May 20, 2015 · Databases

An Overview of Google Spanner: Architecture, Design, and Concurrency Control

This article provides a comprehensive overview of Google Spanner, a globally distributed, multi‑version database, covering its background, core components, TrueTime‑based global synchronization, Paxos replication, data model, and the various transaction and concurrency mechanisms it employs.

Database ArchitectureGoogle SpannerPaxos replication
0 likes · 19 min read
An Overview of Google Spanner: Architecture, Design, and Concurrency Control
ITPUB
ITPUB
Jan 9, 2015 · Databases

Inside Alibaba’s DRDS: How Distributed Databases Power Double‑11

This interview with Alibaba’s DRDS expert Shen Xun reveals how the distributed relational database service evolved from an internal tool to a cloud‑native solution, detailing its architecture, scalability advantages, middleware ecosystem, and real‑world performance during massive events like Double‑11.

Alibaba CloudDRDSMessage Queue
0 likes · 18 min read
Inside Alibaba’s DRDS: How Distributed Databases Power Double‑11