BestHub
Sign in
Tagged articles

Database Architecture

276 articles · Page 2 of 3
Big Data Technology & Architecture
Big Data Technology & Architecture
May 30, 2022 · Big Data

Doris Architecture, Principles, and Key Features Overview

This article provides a comprehensive overview of Doris's architecture—including its FE and BE components, metadata management, data organization, execution planning—and details its major features such as adaptive join aggregation, vectorized execution, materialized views, and Elasticsearch integration, supplemented with example DDL and query code.

Big DataDatabase ArchitectureDoris
0 likes · 7 min read
Doris Architecture, Principles, and Key Features Overview
Top Architect
Top Architect
May 18, 2022 · Databases

Evolution of JD Baitiao Backend Architecture: From MySQL to ShardingSphere

This article chronicles the architectural evolution of JD Baitiao’s backend—from early MySQL monoliths through Solr‑HBase, MongoDB, and DBRep—to the adoption of Apache ShardingSphere, highlighting the motivations, technical trade‑offs, decoupling strategies, and performance outcomes for a high‑throughput financial service.

Data PartitioningDatabase ArchitectureJD Baitiao
0 likes · 15 min read
Evolution of JD Baitiao Backend Architecture: From MySQL to ShardingSphere
Architect
Architect
May 16, 2022 · Databases

Understanding MySQL Execution Process and SQL Execution Order

This article explains the complete MySQL execution pipeline—from client connection, authentication, and permission checks through caching, parsing, optimization, and execution—plus the logical order of SQL clauses, illustrated with diagrams to help developers optimize and comprehend database queries.

Database ArchitecturePermission ManagementQuery Optimization
0 likes · 12 min read
Understanding MySQL Execution Process and SQL Execution Order
Top Architect
Top Architect
Apr 22, 2022 · Databases

Redis Single‑Threaded Architecture, Lazy Free Mechanism, and Multi‑Threaded I/O

This article explains Redis's original single‑threaded event‑driven design, the problems it causes, how the Lazy Free mechanism and asynchronous deletion were introduced in Redis 4.0, and how Redis 6.0 adds multi‑threaded I/O while discussing its limitations and comparing it with Tair's approach.

Database ArchitectureLazy FreeMulti-threaded I/O
0 likes · 16 min read
Redis Single‑Threaded Architecture, Lazy Free Mechanism, and Multi‑Threaded I/O
TAL Education Technology
TAL Education Technology
Apr 21, 2022 · Databases

Applying Orchestrator for High‑Availability MySQL in TAL Education Group’s Database System

This article describes how TAL Education Group evaluated, selected, and customized the open‑source Orchestrator tool to build a highly available, secure, and extensible MySQL HA solution that meets 99.99% uptime, data‑integrity, cross‑datacenter, and operational automation requirements.

Database ArchitectureHigh AvailabilityOperations
0 likes · 9 min read
Applying Orchestrator for High‑Availability MySQL in TAL Education Group’s Database System
Architecture Digest
Architecture Digest
Mar 31, 2022 · Databases

Seven Key Aspects of Distributed Storage Systems

This article outlines the motivation and seven fundamental aspects of distributed storage—replication, storage engine, transactions, analytics, multi‑core processing, computation, and compilation—detailing their roles, challenges, and design considerations for building scalable, reliable, and high‑performance data systems.

Database ArchitectureDistributed storagemulticore
0 likes · 14 min read
Seven Key Aspects of Distributed Storage Systems
IT Architects Alliance
IT Architects Alliance
Mar 21, 2022 · Databases

Seven Key Aspects of Distributed Storage Systems

This article outlines seven fundamental aspects of distributed storage—replication, storage engine, transactions, analysis, multi‑core processing, computation, and compilation—explaining their roles, challenges, and design considerations for building scalable, reliable, and high‑performance storage systems.

Database ArchitectureDistributed storageperformance
0 likes · 13 min read
Seven Key Aspects of Distributed Storage Systems
vivo Internet Technology
vivo Internet Technology
Feb 28, 2022 · Databases

Distributed Database Sorting Solutions

In distributed databases, proxies must merge sorted results from multiple shards, but large result sets exceed memory limits; the article proposes a batch‑fetching approach using per‑shard sort buffers and a priority‑queue merge, eliminating disk I/O and reducing network waste while preserving global order.

Data PartitioningDatabase ArchitectureSorting Algorithms
0 likes · 15 min read
Distributed Database Sorting Solutions
DataFunSummit
DataFunSummit
Feb 20, 2022 · Databases

Understanding TiDB Architecture and Real‑Time Application Scenarios

This article explains TiDB's HTAP architecture, covering industry challenges, the row‑store TiKV and column‑store TiFlash design, MPP integration in TiDB 5.0, and a range of real‑time use cases such as dashboards, reporting, and data‑warehouse pipelines.

Database ArchitectureHTAPMPP
0 likes · 16 min read
Understanding TiDB Architecture and Real‑Time Application Scenarios
Architect's Journey
Architect's Journey
Feb 9, 2022 · Databases

Choosing the Right Database Architecture: A Practical Guide

The article walks through the challenges of growing data volumes, compares master‑slave, vertical, horizontal, and sharding‑plus‑partitioning architectures, explains their pros and cons, and provides concrete guidance on selecting and implementing a suitable database solution, including middleware options and real‑world case studies.

Database ArchitectureMiddlewareSharding
0 likes · 21 min read
Choosing the Right Database Architecture: A Practical Guide
Tencent Architect
Tencent Architect
Jan 18, 2022 · Databases

Inside Tencent’s TXSQL: Architecture, Evolution, and Enterprise‑Grade Features

This article reviews Tencent Cloud’s self‑developed MySQL kernel TXSQL, detailing its enterprise‑grade features, evolutionary roadmap, overall and cloud‑native TDSQL‑C architecture, columnar engine for OLAP, instant DDL capabilities, high‑availability mechanisms, performance optimizations, and the rigorous development and release process that underpins its stability.

Cloud NativeColumnar EngineDatabase Architecture
0 likes · 12 min read
Inside Tencent’s TXSQL: Architecture, Evolution, and Enterprise‑Grade Features
dbaplus Community
dbaplus Community
Dec 23, 2021 · Databases

Building a 16,000‑Node Cloud‑Native MPP Data Warehouse: Lessons from CCB

The article details how China Construction Bank's fintech arm designed, deployed, and operated a cloud‑native, three‑layer MPP data warehouse spanning 16,000 servers, covering architectural choices, performance gains, operational automation, and high‑availability strategies for ultra‑large scale workloads.

Cloud NativeData WarehouseDatabase Architecture
0 likes · 10 min read
Building a 16,000‑Node Cloud‑Native MPP Data Warehouse: Lessons from CCB
IT Architects Alliance
IT Architects Alliance
Dec 18, 2021 · Backend Development

Designing Data for Microservices: Choosing the Right Database Strategy

This article explains microservice fundamentals, outlines their advantages, and dives deep into data‑design considerations such as one‑database‑per‑service, polyglot persistence versus multi‑model databases, and why MongoDB’s dynamic schema, change streams, and sharding make it a strong fit for scalable microservice architectures.

Database ArchitectureMicroservicesMongoDB
0 likes · 17 min read
Designing Data for Microservices: Choosing the Right Database Strategy
ITPUB
ITPUB
Dec 16, 2021 · Databases

How Alibaba Cloud RDS MySQL Three‑Node Enterprise Uses X‑Paxos for High Availability

This article explains the architecture of Alibaba Cloud RDS MySQL three‑node enterprise edition, detailing the X‑Paxos consensus protocol, node roles, election mechanisms, weight‑based leader selection, state‑machine diagnostics, disk health probing, and reverse‑heartbeat design that together provide a robust high‑availability database solution.

Database ArchitectureRDSX-Paxos
0 likes · 11 min read
How Alibaba Cloud RDS MySQL Three‑Node Enterprise Uses X‑Paxos for High Availability
政采云技术
政采云技术
Nov 30, 2021 · Databases

Overview of MySQL and InnoDB Storage Engine Architecture

This article provides a comprehensive overview of MySQL, detailing its configuration file search order, component architecture, various storage engines such as MyISAM, NDB, Memory, and an in‑depth examination of InnoDB’s internal structures, memory management, background threads, LRU handling, redo log buffering, and checkpoint mechanisms.

CheckpointDatabase ArchitectureInnoDB
0 likes · 26 min read
Overview of MySQL and InnoDB Storage Engine Architecture
JavaEdge
JavaEdge
Nov 6, 2021 · Databases

Mastering Redis Architecture: From Data Models to Persistence Strategies

This article explains Redis’s overall architecture, covering its data model, supported value types, operation interfaces, memory versus disk storage choices, access pattern selection, I/O threading models, indexing mechanisms, specific CRUD logic, and persistence strategies, helping readers grasp both high‑level design and detailed implementation.

Database ArchitectureI/O DesignKV store
0 likes · 8 min read
Mastering Redis Architecture: From Data Models to Persistence Strategies
Programmer DD
Programmer DD
Oct 17, 2021 · Databases

TiDB Architecture Explained: TiKV, PD, and Raft in Distributed Databases

TiDB is a distributed, MySQL-compatible database built from three core components—TiDB Server for stateless SQL processing, PD for global scheduling and metadata management, and TiKV for high‑performance key‑value storage—coordinated via the Raft consensus algorithm to ensure strong consistency and fault tolerance.

Database ArchitecturePDRaft
0 likes · 13 min read
TiDB Architecture Explained: TiKV, PD, and Raft in Distributed Databases
21CTO
21CTO
Sep 19, 2021 · Databases

From Two‑Site Three‑Center to Three‑Site Five‑Center: NetBank’s Database Architecture Evolution

NetBank’s database deployment has evolved from a simple two‑site three‑center disaster‑recovery model to a sophisticated three‑site five‑center architecture, incorporating distributed databases, multi‑tenant isolation, transaction consistency, latency optimization, and containerized deployment to achieve high availability, scalability, and cost efficiency.

Database ArchitectureDisaster RecoveryMulti‑tenant
0 likes · 19 min read
From Two‑Site Three‑Center to Three‑Site Five‑Center: NetBank’s Database Architecture Evolution
Tencent Architect
Tencent Architect
Sep 10, 2021 · Databases

Design and Advantages of a Cloud‑Native ClickHouse OLAP System

This article presents the architecture, key features, and operational benefits of a cloud‑native ClickHouse OLAP platform, describing how storage‑compute separation, a unified master node, and shared storage reduce cost, improve availability, and simplify management while remaining fully compatible with the open‑source ClickHouse ecosystem.

ClickHouseDatabase ArchitectureOLAP
0 likes · 18 min read
Design and Advantages of a Cloud‑Native ClickHouse OLAP System
JavaEdge
JavaEdge
Aug 30, 2021 · Databases

Master‑Slave Replication & Read/Write Splitting: Scaling MySQL While Avoiding Latency

This article explains the principles of master‑slave read/write separation, the MySQL binlog‑based replication process, its side effects, practical ways to mitigate replication lag, and how middleware or proxy layers can simplify database access in high‑concurrency environments.

Database ArchitectureMiddlewareRead/Write Splitting
0 likes · 12 min read
Master‑Slave Replication & Read/Write Splitting: Scaling MySQL While Avoiding Latency
Shopee Tech Team
Shopee Tech Team
Aug 26, 2021 · Databases

Database Architecture Evolution and Sharding Practice in Shopee's Logistics Service

Shopee’s Logistics Channel Service migrated from a shared‑cluster MySQL setup to dedicated clusters, added TiDB for transient tracking data, and ultimately adopted hash‑based sharding with separate order and tracking services plus an asynchronous compensation mechanism, enabling uniform data distribution, cross‑database consistency, six‑month archiving, and scalable growth without rebalancing.

Database ArchitectureTiDBdatabase sharding
0 likes · 18 min read
Database Architecture Evolution and Sharding Practice in Shopee's Logistics Service
dbaplus Community
dbaplus Community
Aug 25, 2021 · Databases

Master‑Slave, Replica Set, and Sharding: How MongoDB Achieves High Availability

This article explains MongoDB's evolution from Master‑Slave to Replica Set and Sharding architectures, detailing how each model provides high availability, data reliability, and scalability, and offers practical configuration tips to ensure strong consistency and minimal downtime in production deployments.

Database ArchitectureHigh AvailabilityMongoDB
0 likes · 20 min read
Master‑Slave, Replica Set, and Sharding: How MongoDB Achieves High Availability
IT Architects Alliance
IT Architects Alliance
Aug 15, 2021 · Databases

Design Principles of 58.com Database Architecture and Codd's Twelve Rules

This article outlines 58.com’s database architecture strategies—including high availability via replication and dual‑master setups, read‑performance enhancements through indexing, read replicas, and caching, consistency solutions, scalability techniques, horizontal sharding patterns, and a review of Codd’s twelve relational rules as design guidelines.

Codd RulesDatabase ArchitectureSharding
0 likes · 14 min read
Design Principles of 58.com Database Architecture and Codd's Twelve Rules
Architect
Architect
Jul 20, 2021 · Databases

Redis New Features and Architecture Options Overview

This article reviews Redis 6.0 and 5.0 new features, compares deployment architectures such as cluster, master-replica, and read-write split, and provides Java connection-pool code examples to help engineers select the appropriate Redis setup for performance, reliability, and scalability requirements.

Database ArchitectureJavaJedis
0 likes · 11 min read
Redis New Features and Architecture Options Overview
IT Architects Alliance
IT Architects Alliance
Jul 6, 2021 · Databases

58.com Database Architecture Design Overview

This article presents a comprehensive overview of 58.com’s database architecture, covering availability through replication and dual‑master setups, read‑performance enhancements via indexing, replicas and caching, consistency strategies, rapid horizontal scaling, sharding patterns, and practical SQL considerations alongside Codd’s 12 relational rules.

CachingDatabase ArchitectureSharding
0 likes · 11 min read
58.com Database Architecture Design Overview
New Oriental Technology
New Oriental Technology
Jun 28, 2021 · Databases

InnoDB Architecture and Key Features: A Comprehensive Overview

This article provides a comprehensive overview of InnoDB architecture, covering its memory structures, background threads, and key features like checkpoint mechanisms, double write, and neighbor page flushing, essential for understanding MySQL's default storage engine.

Background ThreadsBuffer PoolCheckpoint Mechanism
0 likes · 12 min read
InnoDB Architecture and Key Features: A Comprehensive Overview
Java Architect Essentials
Java Architect Essentials
Jun 23, 2021 · Databases

How Redis Read‑Write Separation Boosts Performance and Cuts Costs

This article explains the background, architecture, and replication models of Redis read‑write separation, compares star and chain replication, and outlines its transparent compatibility, high availability, and performance benefits while noting consistency trade‑offs for read‑heavy workloads.

Database ArchitectureHigh AvailabilityRead‑Write Separation
0 likes · 9 min read
How Redis Read‑Write Separation Boosts Performance and Cuts Costs
Architecture Digest
Architecture Digest
Jun 21, 2021 · Databases

Using HBase for HR Performance Data Preprocessing Platform: Architecture, Concepts, and Best Practices

This article introduces the HR performance data preprocessing platform’s requirements, explains why HBase was selected as the storage solution, details its core concepts, architecture, data write/read processes, best practices, limitations, and presents performance metrics demonstrating its suitability for large‑scale, high‑throughput workloads.

Big DataData preprocessingDatabase Architecture
0 likes · 12 min read
Using HBase for HR Performance Data Preprocessing Platform: Architecture, Concepts, and Best Practices
Programmer DD
Programmer DD
Jun 19, 2021 · Databases

How Redis Read/Write Separation Boosts Performance and Cuts Costs

This article explains how Redis read/write separation introduces a read‑only replica role, compares star and chain replication architectures, and outlines the transparent compatibility, high availability, and performance benefits that help users reduce costs while handling read‑heavy workloads.

Database ArchitectureHigh AvailabilityRead‑Write Separation
0 likes · 9 min read
How Redis Read/Write Separation Boosts Performance and Cuts Costs
ITPUB
ITPUB
May 19, 2021 · Databases

Mastering SQL Server AlwaysOn: Enterprise‑Ready High‑Availability Architecture

This article explains the evolution of SQL Server high‑availability solutions, details the AlwaysOn availability‑group architecture, walks through its data‑synchronization workflow, compares synchronous and asynchronous commit modes, and offers practical guidance for deploying AlwaysOn in large‑scale enterprise environments.

AlwaysOnDatabase ArchitectureSQL Server
0 likes · 8 min read
Mastering SQL Server AlwaysOn: Enterprise‑Ready High‑Availability Architecture
dbaplus Community
dbaplus Community
May 17, 2021 · Databases

How Migrating from Elasticsearch to MongoDB Cut Costs 10‑Fold and Boosted Latency

This article presents a detailed case study of moving a 2‑petabyte smart‑product data workload from Elasticsearch to MongoDB, covering business background, source cluster architecture, MongoDB design and resource planning, step‑by‑step performance optimizations, latency and cost comparisons, and guidance on when each database is appropriate.

Database ArchitectureElasticsearchMongoDB
0 likes · 21 min read
How Migrating from Elasticsearch to MongoDB Cut Costs 10‑Fold and Boosted Latency
Tencent Cloud Developer
Tencent Cloud Developer
May 14, 2021 · Cloud Native

Exploration and Practice of Tencent Cloud Native Database TDSQL-C Architecture

Tencent’s cloud‑native database TDSQL‑C separates compute and storage, offering petabyte‑scale network‑attached storage, automatic scaling, million‑level QPS, MySQL/PostgreSQL compatibility, serverless per‑use billing, two‑level caching, instant snapshot‑based backup and restore, and a roadmap toward ultra‑minimal operations, multi‑region DR and column‑store analytics.

Database ArchitectureDistributed storageTDSQL-C
0 likes · 16 min read
Exploration and Practice of Tencent Cloud Native Database TDSQL-C Architecture
Tencent Cloud Developer
Tencent Cloud Developer
May 12, 2021 · Databases

Evolution and Architecture of Distributed Databases: A TDSQL Case Study

The talk traces the evolution of distributed databases—from early shared‑memory and shared‑nothing designs through New‑SQL breakthroughs—to Tencent’s HTAP‑oriented TDSQL, highlighting its strong‑consistency architecture, anomaly taxonomy, and performance advantages over systems like Google Spanner while addressing modern scalability and hardware challenges.

Database ArchitectureHTAPTDSQL
0 likes · 22 min read
Evolution and Architecture of Distributed Databases: A TDSQL Case Study
Architect
Architect
May 9, 2021 · Databases

Redis Read/Write Separation Architecture: Star vs. Chain Replication

Redis read/write separation introduces read‑only replicas to offload read traffic, offering two replication models—star replication with direct master‑replica sync and chain replication forming a replication chain—each with distinct performance, scalability, and latency trade‑offs, while maintaining high availability and transparent compatibility.

Database ArchitectureRead‑Write SeparationRedis
0 likes · 7 min read
Redis Read/Write Separation Architecture: Star vs. Chain Replication
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 6, 2021 · Databases

Understanding MySQL Query Execution Process and Architecture

This article explains MySQL’s internal architecture—including server and storage engine layers—and walks through each stage of query processing from connection and authentication, through query cache, parsing, optimization, and execution, illustrated with a concrete SELECT example.

Database ArchitectureOptimizationQuery Execution
0 likes · 9 min read
Understanding MySQL Query Execution Process and Architecture
Alibaba Cloud Developer
Alibaba Cloud Developer
Apr 25, 2021 · Databases

How ADB PG’s Multi‑Master Architecture Boosts HTAP Performance

This article explains the HTAP concept, describes AnalyticDB PostgreSQL’s shift from a single‑master to a Multi‑Master design, details the architecture, distributed transaction handling, global deadlock detection, DDL support, fault tolerance, and presents benchmark results that demonstrate linear scalability for real‑time data‑warehouse workloads.

AnalyticDBDatabase ArchitectureHTAP
0 likes · 23 min read
How ADB PG’s Multi‑Master Architecture Boosts HTAP Performance
ITPUB
ITPUB
Apr 2, 2021 · Databases

Choosing the Right MySQL Architecture: Master‑Standby, Dual‑Master, and Consistency Strategies

This article examines core MySQL architecture principles—high availability, performance, consistency, and scalability—then compares four common deployment patterns, analyzes their trade‑offs, and presents practical consistency solutions for both master‑slave replication and cache synchronization, ending with personal insights on evolution and sharding.

Database ArchitectureHigh AvailabilityRead‑Write Separation
0 likes · 12 min read
Choosing the Right MySQL Architecture: Master‑Standby, Dual‑Master, and Consistency Strategies
dbaplus Community
dbaplus Community
Feb 17, 2021 · Databases

Choosing the Right MySQL HA Architecture: From Replication to InnoDB Cluster

This article reviews MySQL's evolution of high‑availability solutions—from classic master‑slave replication to InnoDB Cluster and InnoDB Replica Set—explaining each component, their features, deployment steps, and how to select the appropriate architecture based on business requirements such as RTO, RPO, and regional scope.

Database ArchitectureHA DesignInnoDB Cluster
0 likes · 10 min read
Choosing the Right MySQL HA Architecture: From Replication to InnoDB Cluster
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 ArchitectureHigh AvailabilityNewSQL
0 likes · 17 min read
Comparing NewSQL Distributed Databases with Middleware‑Based Sharding: Advantages, Trade‑offs, and Application Scenarios
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jan 6, 2021 · Databases

Understanding MySQL Architecture: Layers, Components, and Storage Engines

This article explains the complete MySQL architecture, covering its connection, service, storage‑engine, and system‑file layers, the role of each component such as connection pools, query cache, parser, optimizer, executor, and the differences between InnoDB and MyISAM, providing practical insights for developers and interview preparation.

Database ArchitectureInnoDBMyISAM
0 likes · 13 min read
Understanding MySQL Architecture: Layers, Components, and Storage Engines
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
dbaplus Community
dbaplus Community
Dec 6, 2020 · Databases

Sharding Massive MySQL Tables: End‑to‑End Architecture, Migration & Best Practices

This article presents a comprehensive, step‑by‑step case study of a large‑scale MySQL sharding project, covering business refactoring, storage architecture design, data migration, synchronization strategies, capacity planning, validation, rollout procedures, stability safeguards, and cross‑team collaboration.

Database ArchitectureShardingmysql
0 likes · 28 min read
Sharding Massive MySQL Tables: End‑to‑End Architecture, Migration & Best Practices
dbaplus Community
dbaplus Community
Oct 20, 2020 · Databases

15 Critical MySQL vs Oracle Migration Questions Every Bank Should Know

This article compiles the most frequently asked MySQL‑related questions from developers and operations teams in banks, covering why MySQL is chosen over Oracle, compatibility gaps, migration methods, sharding strategies, performance tuning, consistency guarantees, and resource planning.

Database ArchitectureOracle migrationdatabase sharding
0 likes · 17 min read
15 Critical MySQL vs Oracle Migration Questions Every Bank Should Know
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 15, 2020 · Databases

MySQL Middleware Deep Dive: Sharding vs Middleware, Distributed Transactions, and DBLE Insights

The fifth episode of the MySQL 冲冲冲 livestream explores the trade‑offs between sharding and middleware architectures, discusses distributed transaction challenges, compares DBLE with MyCat and other solutions, and provides practical guidance for developers and DBAs handling high‑throughput MySQL workloads.

DBLEDatabase ArchitectureMiddleware
0 likes · 19 min read
MySQL Middleware Deep Dive: Sharding vs Middleware, Distributed Transactions, and DBLE Insights
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 24, 2020 · Databases

MySQL High Availability vs Oracle High Availability: Can MySQL Replace Oracle in the Financial Industry?

The livestream discusses MySQL's high‑availability architectures compared with Oracle's, analyzes share‑nothing versus share‑everything designs, logical versus physical logging, and concludes that MySQL's share‑nothing and logical binlog replication are better suited for modern financial‑industry workloads, while also covering audience Q&A and upcoming topics.

Database ArchitectureFinancial IndustryGroup Replication
0 likes · 10 min read
MySQL High Availability vs Oracle High Availability: Can MySQL Replace Oracle in the Financial Industry?
Big Data Technology & Architecture
Big Data Technology & Architecture
Aug 27, 2020 · Big Data

HBase Architecture, Components, and Operations Overview

This article provides a comprehensive overview of Apache HBase’s architecture, detailing its core components such as RegionServer, HMaster, ZooKeeper, WAL, MemStore, and HFiles, and explains key processes including read/write paths, compaction, region splitting, load balancing, and recovery mechanisms.

Big DataCompactionDatabase Architecture
0 likes · 17 min read
HBase Architecture, Components, and Operations Overview
Tencent Cloud Developer
Tencent Cloud Developer
Aug 26, 2020 · Databases

How to Become an Outstanding Data Craftsman: Insights from Database Experts

Three leading database experts from Tencent and cloud firms share how deep curiosity, hands‑on experimentation, persistent learning—combined with mastering distributed, cloud, and autonomous databases—forge an outstanding data craftsman, while advising newcomers to master performance, security, one DB per category, and start with open‑source tools.

DBADatabase ArchitectureElasticsearch
0 likes · 34 min read
How to Become an Outstanding Data Craftsman: Insights from Database Experts
Programmer DD
Programmer DD
Aug 7, 2020 · Databases

Database Architecture Guide: Principles, Patterns, and Consistency Solutions

This article outlines core database architecture principles—high availability, performance, scalability, and consistency—examines four common deployment patterns (primary‑standby, dual‑primary, primary‑replica with read/write separation, and hybrid), and presents practical consistency solutions and personal insights for selecting and evolving database designs.

Database ArchitectureHigh AvailabilityRead‑Write Separation
0 likes · 11 min read
Database Architecture Guide: Principles, Patterns, and Consistency Solutions
MaGe Linux Operations
MaGe Linux Operations
Aug 1, 2020 · Databases

What Are the Core Components of MySQL? A Deep Dive

This article breaks down MySQL’s architecture into its five key parts—connector, parser, optimizer, executor, and storage engine—explaining each component’s role from establishing connections and handling permissions to query parsing, execution planning, and data storage, with example commands and code snippets.

Database ArchitectureQuery ProcessingSQL
0 likes · 3 min read
What Are the Core Components of MySQL? A Deep Dive
vivo Internet Technology
vivo Internet Technology
Jul 24, 2020 · Databases

Database Selection and Service Platform Construction for Large-Scale Multi-Storage Scenarios

The article outlines vivo’s shift from traditional DBA firefighting to a product‑oriented database service model, detailing demand‑driven selection of MySQL, Redis, TiDB and others via a five‑dimensional radar, and the design of a unified, multi‑environment platform that emphasizes user experience, automation, and seamless cloud‑IDC integration.

DBA transformationDatabase ArchitectureDatabase Lifecycle
0 likes · 17 min read
Database Selection and Service Platform Construction for Large-Scale Multi-Storage Scenarios
DataFunTalk
DataFunTalk
Jul 18, 2020 · Databases

Core Features and Architecture of ClickHouse: An In‑Depth Overview

This article provides a comprehensive technical overview of ClickHouse, covering its complete DBMS capabilities, column‑oriented storage and compression, vectorized execution engine, relational SQL support, diverse table engines, multi‑master clustering, sharding, and the design philosophies that make it exceptionally fast for large‑scale analytical workloads.

ClickHouseColumnar DatabaseDatabase Architecture
0 likes · 29 min read
Core Features and Architecture of ClickHouse: An In‑Depth Overview
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 25, 2020 · Databases

MySQL Replication, Data Sharding, and Distributed Database Deployment Overview

This article explains MySQL replication (master‑slave and master‑master), data sharding principles and implementations, and various distributed database deployment architectures, covering replication mechanisms, advantages, failure recovery, sharding strategies, middleware like Mycat, and scaling solutions for high‑availability systems.

Database ArchitectureShardingdistributed databases
0 likes · 14 min read
MySQL Replication, Data Sharding, and Distributed Database Deployment Overview
ITPUB
ITPUB
Jun 17, 2020 · Databases

Why Go All‑in on MongoDB? Architecture, HA, Sharding & Schema Design Explained

This article explains why a fast‑growing e‑commerce platform chose MongoDB, covering its high‑availability replica‑set architecture, Raft‑based election algorithm, replica‑set size limits, write‑concern trade‑offs, sharding components and load‑balancing, as well as the flexible document schema with practical code examples.

Database ArchitectureHigh AvailabilityMongoDB
0 likes · 13 min read
Why Go All‑in on MongoDB? Architecture, HA, Sharding & Schema Design Explained
Laravel Tech Community
Laravel Tech Community
Jun 16, 2020 · Databases

Overview of MongoDB: Architecture, Features, and Storage Model

MongoDB is a versatile NoSQL database that combines relational‑like querying with a flexible BSON document model, offering high performance, easy deployment, rich indexing, replication, and cloud‑scale storage, while supporting multiple programming languages and operating systems.

BSONDatabase ArchitectureIndexing
0 likes · 4 min read
Overview of MongoDB: Architecture, Features, and Storage Model
Alibaba Cloud Developer
Alibaba Cloud Developer
May 21, 2020 · Databases

How OceanBase Overtook Oracle: The Story Behind Two Record‑Breaking TPC‑C Wins

OceanBase, Alibaba’s self‑developed distributed relational database, achieved world‑leading TPC‑C performance in 2019 and shattered its own record in 2020, a journey marked by intense team effort, architectural innovations like Paxos‑based scalability, and a vision to become a global database leader.

Database ArchitectureOceanBasePerformance Benchmark
0 likes · 13 min read
How OceanBase Overtook Oracle: The Story Behind Two Record‑Breaking TPC‑C Wins
DataFunTalk
DataFunTalk
Apr 29, 2020 · Databases

High Availability Architecture for SQL Server, MySQL, and Redis at Ctrip

This article explains Ctrip's high‑availability designs for SQL Server, MySQL, and Redis, describing multi‑replica strategies, evolution from legacy mirroring to AlwaysOn, multi‑node MHA management, and Redis sentinel‑based failover, while emphasizing fault‑tolerance across data centers.

Database ArchitectureHigh AvailabilityRedis
0 likes · 12 min read
High Availability Architecture for SQL Server, MySQL, and Redis at Ctrip
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 ArchitectureHigh AvailabilityNewSQL
0 likes · 21 min read
Sharding (Partitioning) vs NewSQL Databases: A Comparative Analysis
Architects' Tech Alliance
Architects' Tech Alliance
Apr 16, 2020 · Databases

Database Application Architecture Principles and Common Schemes

This article outlines core database architecture principles—high availability, high performance, consistency, and scalability—examines four common deployment schemes (primary‑standby, dual‑primary, primary‑replica with read/write separation, and a combined dual‑primary/replica model), and presents multiple consistency and cache‑integration solutions.

CachingDatabase ArchitectureHigh Availability
0 likes · 12 min read
Database Application Architecture Principles and Common Schemes
dbaplus Community
dbaplus Community
Apr 12, 2020 · Databases

Why and How to Migrate from MongoDB to Elasticsearch: A Practical Guide

This article explains the motivations for moving a high‑volume operation‑log system from MongoDB to Elasticsearch, outlines the existing architecture, details capacity planning, index design, and a step‑by‑step migration process using Kafka, DataX, and Spring Boot, and shares the performance gains and lessons learned.

Data MigrationDataXDatabase Architecture
0 likes · 14 min read
Why and How to Migrate from MongoDB to Elasticsearch: A Practical Guide
dbaplus Community
dbaplus Community
Mar 29, 2020 · Databases

Mastering GaussDB T: Planning Single‑Node, HA, and Distributed Architectures

This article outlines a comprehensive plan for deploying GaussDB T, covering the software architecture, component roles, and practical guidelines for single‑node, primary‑standby, and distributed setups, while highlighting common pitfalls and operational considerations for production environments.

Database ArchitectureGaussDBHigh Availability
0 likes · 13 min read
Mastering GaussDB T: Planning Single‑Node, HA, and Distributed Architectures
Top Architect
Top Architect
Feb 15, 2020 · Databases

Database Architecture Principles, Common Schemes, and Consistency Solutions

This article outlines fundamental database architecture principles such as high availability, performance, consistency, and scalability, compares four common deployment schemes (master‑slave, dual‑master, master‑slave with read‑write separation, and hybrid master‑master‑slave), and presents various consistency solutions including caching, semi‑sync replication, and middleware.

Database ArchitectureRead‑Write Separation
0 likes · 11 min read
Database Architecture Principles, Common Schemes, and Consistency Solutions
dbaplus Community
dbaplus Community
Feb 2, 2020 · Databases

JDHBase Multi‑Active Disaster Recovery: Replication, Auto‑Failover & Consistency

JDHBase, JD.com’s large‑scale KV store, powers billions of daily reads and writes across 7,000 nodes, and this article details its multi‑active, cross‑region architecture—including HBase replication fundamentals, Fox Manager routing, automatic failover policies, dynamic replication tuning, and serial replication to ensure strong consistency.

Database ArchitectureDisaster RecoveryHBase
0 likes · 15 min read
JDHBase Multi‑Active Disaster Recovery: Replication, Auto‑Failover & Consistency
21CTO
21CTO
Jan 22, 2020 · Databases

Why Distributed SQL is Revolutionizing Modern Database Architecture

Distributed SQL databases combine the familiar relational SQL API with cloud‑native, horizontally scalable architectures, offering strong consistency, distributed ACID transactions, automatic sharding, fault‑tolerant replication, and low‑latency geo‑distribution, making them an agile, resilient choice for modern application development.

ACID TransactionsDatabase ArchitectureDistributed SQL
0 likes · 9 min read
Why Distributed SQL is Revolutionizing Modern Database Architecture
Tencent Database Technology
Tencent Database Technology
Jan 9, 2020 · Databases

CynosDB: Cloud‑Native Distributed Database Architecture and Performance Optimizations

The article presents an in‑depth technical overview of Tencent Cloud's CynosDB, describing the challenges of traditional MySQL‑based cloud databases, detailing its compute‑storage decoupled architecture, redo‑log based replication, MVCC implementation, performance enhancements, and how these innovations address elasticity, stability, and resource utilization issues.

Cloud NativeCynosDBDatabase Architecture
0 likes · 21 min read
CynosDB: Cloud‑Native Distributed Database Architecture and Performance Optimizations
Qunar Tech Salon
Qunar Tech Salon
Nov 28, 2019 · Databases

Qunar Redis High‑Availability Architecture Design, Security Mechanisms, and Automated Operations

This article details the design principles, components, client implementation, data sharding, security mechanisms, high‑risk command blocking, configuration optimizations, and automated operational workflows of Qunar's Redis high‑availability cluster, including code modifications, deployment scripts, and platform‑based management for large‑scale production environments.

AutomationDatabase ArchitectureHigh Availability
0 likes · 18 min read
Qunar Redis High‑Availability Architecture Design, Security Mechanisms, and Automated Operations
ITPUB
ITPUB
Nov 25, 2019 · Databases

Which Database Architecture Best Balances Availability, Performance, and Consistency?

This article examines four common database architecture patterns—primary‑standby, dual‑primary, master‑slave read/write separation, and a hybrid dual‑primary + master‑slave—evaluating each against high availability, performance, consistency, and scalability, and then presents practical consistency‑resolution techniques and cache strategies.

CacheDatabase ArchitectureSharding
0 likes · 10 min read
Which Database Architecture Best Balances Availability, Performance, and Consistency?
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 11, 2019 · Databases

Will MySQL Be Subject to “Bottleneck” Restrictions? An Analysis of US and Chinese Export Controls and Technical Viability

The article examines whether MySQL, especially the Community Edition, faces commercial or regulatory “bottleneck” risks by reviewing US export control rules, Chinese policy guidance, and the technical feasibility of MySQL’s high‑availability architectures, concluding that current policies pose no significant threat.

Database ArchitectureHigh Availabilityexport controls
0 likes · 8 min read
Will MySQL Be Subject to “Bottleneck” Restrictions? An Analysis of US and Chinese Export Controls and Technical Viability
System Architect Go
System Architect Go
Oct 26, 2019 · Databases

Understanding InfluxDB Retention Policies and Shard Duration: A Deep Dive

This article explains InfluxDB's retention policy components—duration, replication, and shard duration—clarifies the concepts of shards and shard groups, describes default configurations, offers recommendations for shard group duration, and outlines practical considerations for performance and data management.

Database ArchitectureInfluxDBRetention Policy
0 likes · 5 min read
Understanding InfluxDB Retention Policies and Shard Duration: A Deep Dive
Open Source Tech Hub
Open Source Tech Hub
Aug 27, 2019 · Databases

Unveiling MySQL InnoDB: From Instances to Page Storage Architecture

This article explains MySQL’s fundamental concepts, distinguishing databases from instances, outlines the three‑layer MySQL architecture, and dives deep into InnoDB’s storage hierarchy—from tablespaces, pages, and row formats to .frm/.ibd files, record overflow handling, and the B+‑tree index structures that power fast queries.

Database ArchitectureIndexesInnoDB
0 likes · 11 min read
Unveiling MySQL InnoDB: From Instances to Page Storage Architecture
JD Retail Technology
JD Retail Technology
Aug 9, 2019 · Databases

CB‑SQL Overview: Architecture, RocksDB Foundations, and Performance Optimizations

This article introduces CB‑SQL, a MySQL‑compatible elastic database built on CockroachDB and RocksDB, explains RocksDB’s LSM‑tree design, details key configuration parameters, and describes the read/write/clear/file‑operation optimizations employed by CB‑SQL to achieve high scalability and stability.

CB-SQLDatabase ArchitectureDistributed storage
0 likes · 13 min read
CB‑SQL Overview: Architecture, RocksDB Foundations, and Performance Optimizations
dbaplus Community
dbaplus Community
Jul 18, 2019 · Databases

How JD.com Scales HBase to 90PB: Architecture, Optimizations, and Lessons

This article examines JD.com's massive HBase deployment, detailing its evolution from early adoption to a 90PB, 7,000‑node cluster, the platform's architecture, multi‑active disaster recovery, multi‑tenant isolation, and the integration of Phoenix for SQL‑based access, offering practical insights for large‑scale distributed storage.

Big DataDatabase ArchitectureDistributed storage
0 likes · 15 min read
How JD.com Scales HBase to 90PB: Architecture, Optimizations, and Lessons
ITPUB
ITPUB
Jul 12, 2019 · Databases

Choosing the Right Database Architecture: Master‑Slave, Dual‑Master, and Beyond

This article outlines core database architecture principles—high availability, performance, consistency, and scalability—then compares four common setups (primary‑backup, dual‑master, primary‑replica, and hybrid), analyzes their trade‑offs, and presents practical consistency and cache‑sync solutions along with personal insights.

Database ArchitectureRead‑Write SeparationSharding
0 likes · 11 min read
Choosing the Right Database Architecture: Master‑Slave, Dual‑Master, and Beyond
dbaplus Community
dbaplus Community
Jul 2, 2019 · Databases

Mastering Multi-Active Data Centers: Solving MySQL Data Sync Loops

This article explains the concepts of unitization and multi‑active data centers, analyzes the drawbacks of single‑IDC deployments, and provides a detailed guide on implementing MySQL binlog synchronization while addressing common challenges such as data loops, duplicate inserts, unique‑index conflicts, and DDL handling, including practical solutions like GTID and auxiliary tables.

BinlogData synchronizationDatabase Architecture
0 likes · 24 min read
Mastering Multi-Active Data Centers: Solving MySQL Data Sync Loops
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
Qunar Tech Salon
Qunar Tech Salon
May 21, 2019 · Databases

Interview with Wang Zhufeng, Qunar.com Database Director on DTCC Conference Insights and Database Evolution

In this interview, Qunar.com’s database director Wang Zhufeng shares his six‑year journey, discusses the significance of the DTCC conference, outlines the evolution of Qunar’s MySQL architecture toward clustering, cloud‑native solutions, and data consistency, and offers advice for aspiring database engineers.

Cloud DatabasesDTCC ConferenceData Consistency
0 likes · 12 min read
Interview with Wang Zhufeng, Qunar.com Database Director on DTCC Conference Insights and Database Evolution
Architects' Tech Alliance
Architects' Tech Alliance
May 9, 2019 · Databases

From Single‑Node to Distributed: The Evolution of Modern Database Services

This article traces the historical laws that drove computing growth, examines how Redis, MongoDB and Memcached evolved, compares client‑side, proxy and compute‑storage‑separated architectures, evaluates their trade‑offs, and answers common questions about cloud‑based distributed databases.

Cloud DatabasesCompute-Storage SeparationDatabase Architecture
0 likes · 23 min read
From Single‑Node to Distributed: The Evolution of Modern Database Services
21CTO
21CTO
Apr 24, 2019 · Databases

Which DB Architecture Wins? High Availability, Performance & Consistency Explained

This article examines core database architecture principles—high availability, performance, consistency, and scalability—and compares four common deployment patterns (primary‑standby, dual‑primary, primary‑replica with read/write separation, and a hybrid dual‑primary/replica design), followed by detailed consistency solutions and practical insights for real‑world implementation.

Database ArchitectureHigh AvailabilityRead‑Write Separation
0 likes · 11 min read
Which DB Architecture Wins? High Availability, Performance & Consistency Explained
JD Retail Technology
JD Retail Technology
Apr 10, 2019 · Databases

HBase at JD.com: Architecture, Use Cases, and Evolution

This article explains how JD.com leverages the open‑source HBase database for massive, low‑latency data storage across various business lines, detailing its architecture, multi‑tenant isolation, disaster‑recovery mechanisms, and integration with Phoenix SQL for OLTP workloads.

Big DataDatabase ArchitectureDistributed storage
0 likes · 13 min read
HBase at JD.com: Architecture, Use Cases, and Evolution