BestHub
Sign in
Tagged articles
275 articles
Page 3 of 3
Tencent Cloud Developer
Tencent Cloud Developer
Apr 4, 2019 · Cloud Native

Design and Optimization of CynosDB for PostgreSQL: One‑Primary Multi‑Read Architecture

The article details CynosDB’s cloud‑native PostgreSQL design—using compute‑storage separation, log sinking with asynchronous replay, and multi‑version reads—to enable a one‑primary multi‑read architecture that delivers elastic scaling, reduced I/O, stateless instances, and rapid failover and efficient resource utilization through parallel log‑based recovery.

Cloud NativeCynosDBDatabase Architecture
0 likes · 15 min read
Design and Optimization of CynosDB for PostgreSQL: One‑Primary Multi‑Read Architecture
Tencent Cloud Developer
Tencent Cloud Developer
Mar 29, 2019 · Databases

Design of High‑Availability System and Fast Recovery in Tencent CynosDB

Tencent CynosDB achieves high availability and rapid recovery through an external HA service that combines a co‑located monitoring agent, a ZooKeeper‑backed scheduler for fault detection, decision making, and automated switch/rejoin/rebuild actions, and a VDL‑driven distributed storage recovery mechanism that prevents split‑brain scenarios.

Agent‑SchedulerCynosDBDatabase Architecture
0 likes · 19 min read
Design of High‑Availability System and Fast Recovery in Tencent CynosDB
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
MaGe Linux Operations
MaGe Linux Operations
Mar 19, 2019 · Databases

Unlock MySQL Performance: Deep Dive into Query Optimization & Architecture

This article explains MySQL's logical architecture, query processing steps, and the inner workings of its optimizer, cache, and execution engine, then offers practical performance‑tuning advice on schema design, index creation, and specific query patterns to help developers make informed optimization decisions.

Database Architectureindex designmysql
0 likes · 35 min read
Unlock MySQL Performance: Deep Dive into Query Optimization & Architecture
dbaplus Community
dbaplus Community
Mar 12, 2019 · Databases

Mastering HBase Cross‑Datacenter Migration: Snapshots, Architecture, and Real‑World Tips

This article provides a comprehensive technical guide on HBase, covering its core concepts, advantages and drawbacks, architecture layers, practical use cases, and a detailed step‑by‑step process for large‑scale cross‑datacenter migration using snapshot‑based strategies, with commands, diagrams, and lessons learned.

Big DataData MigrationDatabase Architecture
0 likes · 19 min read
Mastering HBase Cross‑Datacenter Migration: Snapshots, Architecture, and Real‑World Tips
dbaplus Community
dbaplus Community
Mar 5, 2019 · Databases

How HTAP and DRDS HTAP Enable Real‑Time OLTP/OLAP Integration

This article explains the concepts of OLTP, OLAP and HTAP, describes the DRDS HTAP architecture—including its engine and storage layers, Fireworks Spark‑based engine, optimizer stages, and streaming capabilities—and demonstrates cross‑database MPP queries and streaming joins while outlining suitable use cases and limitations.

DRDSDatabase ArchitectureHTAP
0 likes · 17 min read
How HTAP and DRDS HTAP Enable Real‑Time OLTP/OLAP Integration
Architect's Tech Stack
Architect's Tech Stack
Feb 26, 2019 · Databases

Database Architecture: Primary‑Backup, Master‑Slave, Read‑Write Splitting, and Consistency Solutions

This article explains fundamental database architecture principles, compares four common deployment patterns—including primary‑backup, dual‑primary, master‑slave with read‑write separation, and a hybrid dual‑primary/master‑slave design—analyzes their high‑availability, performance, consistency, and scalability characteristics, and presents practical consistency‑resolution techniques and personal insights.

ConsistencyDatabase Architecturecaching
0 likes · 10 min read
Database Architecture: Primary‑Backup, Master‑Slave, Read‑Write Splitting, and Consistency Solutions
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 25, 2019 · Databases

Highlights from the 2019 MySQL Technical Exchange Conference in Shenzhen

The 2019 MySQL Technical Exchange Conference in Shenzhen, co‑hosted by Shanghai Aikesheng and Oracle, featured six expert talks covering secure MySQL platform design, large‑scale architecture optimization, backup and recovery strategies, open‑source middleware, automated operations, and InnoDB row‑lock mechanics, followed by community Q&A and a look ahead to open‑source initiatives.

Database ArchitectureInnoDBbackup and recovery
0 likes · 5 min read
Highlights from the 2019 MySQL Technical Exchange Conference in Shenzhen
Tencent Database Technology
Tencent Database Technology
Jan 24, 2019 · Databases

Architecture Evolution and Performance Optimization of Tencent's CKV Distributed In-Memory Storage System

This article details the architectural evolution and comprehensive refactoring of Tencent's CKV distributed in-memory key-value storage system, highlighting its transition to a two-tier single-process multi-threaded model, multi-tenant resource isolation, deep Redis protocol compatibility, and optimized memory engine, which collectively deliver significant improvements in performance, scalability, and operational cost efficiency.

Database ArchitectureIn-Memory DatabaseMulti-Tenant Architecture
0 likes · 10 min read
Architecture Evolution and Performance Optimization of Tencent's CKV Distributed In-Memory Storage System
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
vivo Internet Technology
vivo Internet Technology
Dec 18, 2018 · Databases

2018 3306π 深圳站年会 - Database Technologies and Practices

The 2018 3306π Shenzhen annual conference, co‑hosted by the 3306π community, Zhishu Hall and vivo, attracted over 150 attendees and featured expert talks on MySQL 8.0, open‑source data‑transfer middleware, TDSQL for finance, RadonDB, InnoDB enhancements, large‑scale Redis clusters, and Youzan database operations, with presentation materials available online.

Database ArchitectureDatabase OptimizationMongoDB
0 likes · 3 min read
2018 3306π 深圳站年会 - Database Technologies and Practices
DataFunTalk
DataFunTalk
Dec 6, 2018 · Databases

HBase RowKey and Index Design: Principles, Practices, and Case Studies

This article introduces HBase fundamentals, explores effective RowKey and secondary index design principles, discusses demand analysis, presents techniques such as reversing, salting, hashing, and reviews real-world case studies for OpenTSDB, JanusGraph, and GeoMesa, offering practical guidance for scalable NoSQL data modeling.

Database ArchitectureHBaseNoSQL
0 likes · 19 min read
HBase RowKey and Index Design: Principles, Practices, and Case Studies
Java Backend Technology
Java Backend Technology
Dec 4, 2018 · Databases

Mastering MySQL: A Practical Knowledge Map of Deployment Scenarios

This article presents a comprehensive knowledge map of MySQL deployment scenarios—including single‑master, master‑slave, master‑multiple‑slaves, horizontal and vertical clustering, and mixed modes—detailing backup methods, performance tuning, scaling strategies, and high‑availability considerations.

Backup StrategiesDatabase Architecturehigh availability
0 likes · 8 min read
Mastering MySQL: A Practical Knowledge Map of Deployment Scenarios
Tencent Cloud Developer
Tencent Cloud Developer
Dec 3, 2018 · Databases

Architecture and Design of Tencent Cloud CynosDB and CynosFS

Tencent Cloud’s CynosDB uses a shared‑storage, primary‑multiple‑replica architecture built on the user‑space distributed file system CynosFS, separating compute from elastic block storage, sinking write‑ahead logs for asynchronous replay, and employing MVCC with Raft‑replicated segments to achieve high‑availability, scalable, and cost‑effective MySQL/PostgreSQL‑compatible performance.

CynosDBDatabase ArchitectureLog Sinking
0 likes · 17 min read
Architecture and Design of Tencent Cloud CynosDB and CynosFS
Tencent Cloud Developer
Tencent Cloud Developer
Nov 6, 2018 · Databases

Design and Implementation of High‑Availability MySQL

The talk by Tencent’s senior MySQL engineer explains high‑availability concepts—99.95% uptime, RPO/RTO metrics, backup methods, and replication modes—while comparing single‑node, shared‑storage, and share‑nothing architectures, detailing failover tools (Keepalived, MMM, MHA), cluster solutions (PXC, MGC, Group Replication) and NewSQL examples such as Aurora, PolarDB and CynosDB.

BackupDatabase ArchitectureRPO
0 likes · 15 min read
Design and Implementation of High‑Availability MySQL
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 ArchitectureMycatdistributed database
0 likes · 24 min read
Why MyCat’s Pseudo‑Distributed MySQL Solution Fails and What to Do Instead
Java Backend Technology
Java Backend Technology
Sep 20, 2018 · Databases

Unveiling MySQL: Step‑by‑Step How a SQL Query Is Executed

This article walks through MySQL's overall architecture, the complete query execution flow, and the exact order in which SQL clauses are parsed and processed, using diagrams and detailed explanations to reveal how a statement travels from client request to final result.

Database ArchitectureQuery ProcessingSQL Execution
0 likes · 10 min read
Unveiling MySQL: Step‑by‑Step How a SQL Query Is Executed
dbaplus Community
dbaplus Community
Aug 25, 2018 · Databases

Why Multi-Model Databases Are the Future of Cloud Data Management

The article explains how cloud-driven demands and diverse data types have spurred the rise of multi-model databases, detailing their architecture, storage structures, compression techniques, and access methods using SequoiaDB as a concrete example.

BSONCloud DatabasesDatabase Architecture
0 likes · 14 min read
Why Multi-Model Databases Are the Future of Cloud Data Management
JD Tech
JD Tech
Jun 19, 2018 · Databases

JD Logistics Warehouse Database Architecture, Automation, Performance Optimization, and Scaling

This article explains JD Logistics' warehouse management system database architecture, covering local and centralized deployment modes, the UDBA automated DBA platform, performance tuning practices, fault‑self‑healing mechanisms, automated data archiving, and MySQL 5.7 upgrade and scaling strategies to ensure high performance and availability.

CockroachDBDatabase Architecturemysql
0 likes · 10 min read
JD Logistics Warehouse Database Architecture, Automation, Performance Optimization, and Scaling
ITPUB
ITPUB
May 27, 2018 · Databases

Comparing Redis Cluster Architectures: Codis‑Style, Alibaba, Baidu BDRP, JD, and Official Redis Cluster

This article compares several Redis cluster solutions—including Codis‑style architecture, Alibaba Cloud ApsaraCache, Baidu BDRP 2.0, JD's custom implementation, the official Redis Cluster, AWS ElasticCache, and Baidu Tieba's ksarch‑saas—detailing their components, sharding methods, migration strategies, and deployment scenarios.

Alibaba CloudBaiduCluster
0 likes · 8 min read
Comparing Redis Cluster Architectures: Codis‑Style, Alibaba, Baidu BDRP, JD, and Official Redis Cluster
Alibaba Cloud Developer
Alibaba Cloud Developer
Apr 23, 2018 · Fundamentals

Top Technical Books Recommended by Alibaba Experts for World Book Day

On World Book Day, nine Alibaba technology veterans share a curated list of essential technical books—covering software testing, design patterns, AI, machine learning, reinforcement learning, Rust, and database architecture—offering concise reasons why each title is valuable for developers and engineers.

Database ArchitectureDesign PatternsReinforcement Learning
0 likes · 10 min read
Top Technical Books Recommended by Alibaba Experts for World Book Day
Architecture Digest
Architecture Digest
Apr 18, 2018 · Databases

Understanding Distributed Architecture and Its Applications in MySQL and Large‑Scale Systems

The article explains the concept of distributed architecture, its key characteristics such as cohesion and transparency, showcases how MySQL and middleware like Mycat are used in e‑commerce platforms, and outlines the evolution, practical implementations, and challenges of building scalable distributed database systems.

Big DataDatabase ArchitectureDistributed Systems
0 likes · 15 min read
Understanding Distributed Architecture and Its Applications in MySQL and Large‑Scale Systems
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
Efficient Ops
Efficient Ops
Mar 19, 2018 · Databases

Redis Deep Dive: Core Technologies, Evolution, and Real-World Practices

In this interview, Redis China User Group chair Zhang Donghong shares the database’s key features, version history, data types, high‑availability options, clustering mechanics, automation challenges, future trends, and practical advice for beginners, illustrating how Redis powers massive online services.

ClusterDatabase ArchitectureNoSQL
0 likes · 21 min read
Redis Deep Dive: Core Technologies, Evolution, and Real-World Practices
Efficient Ops
Efficient Ops
Dec 21, 2017 · Databases

Master MySQL: From Beginner Basics to Advanced High‑Availability and Backup Strategies

This comprehensive guide uses a gaming‑level analogy to walk readers through MySQL fundamentals, architecture, storage engines, memory structures, logging, backup and recovery methods, high‑availability designs, and advanced performance tuning, providing practical commands, diagrams, and best‑practice recommendations.

Database Architecturehigh availabilitymysql
0 likes · 19 min read
Master MySQL: From Beginner Basics to Advanced High‑Availability and Backup Strategies
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
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 ArchitectureDeployment
0 likes · 14 min read
TiDB Architecture, Deployment, and Monitoring Practices at Qunar
dbaplus Community
dbaplus Community
Aug 29, 2017 · Databases

Unlock Oracle Performance: How Architecture Impacts SQL Optimization

This article explains Oracle's architecture—including the SGA, Shared Pool, Data Buffer, and Log Buffer—shows how each component influences SQL parsing, bind variables, result caching, direct‑path inserts, batch commits and logging, and provides step‑by‑step experiments and practical techniques for diagnosing and tuning performance bottlenecks.

Bind VariablesDatabase ArchitectureOracle
0 likes · 16 min read
Unlock Oracle Performance: How Architecture Impacts SQL Optimization
dbaplus Community
dbaplus Community
Aug 14, 2017 · Databases

How Meituan‑Dianping Evolved MySQL HA: From MMM to MHA+Zebra and Beyond

This article traces Meituan‑Dianping's MySQL high‑availability journey, detailing the legacy MMM system, the transition to MHA, integrations with Zebra and Proxy middleware, current challenges, and future designs such as distributed agents, semi‑sync replication, and MySQL Group Replication.

Database ArchitectureDistributed SystemsMHA
0 likes · 13 min read
How Meituan‑Dianping Evolved MySQL HA: From MMM to MHA+Zebra and Beyond
Taobao Frontend Technology
Taobao Frontend Technology
Jul 6, 2017 · Databases

Understanding LevelDB: Architecture, Interfaces, and New Features

LevelDB, Google's high-performance key‑value store built on LSM trees, uses an in‑memory skip‑list, immutable memtables, and sstable files organized in multi‑level compaction, offering interfaces for creation, reads, writes, snapshots, and new features like fuzzy search and JSON storage, all explained with diagrams.

Database ArchitectureLSM‑TreeLevelDB
0 likes · 11 min read
Understanding LevelDB: Architecture, Interfaces, and New Features
Meituan Technology Team
Meituan Technology Team
Jun 30, 2017 · Operations

How Meituan‑Dianping Evolved MySQL HA from MMM to MHA‑Zebra and Beyond

This article traces Meituan‑Dianping's MySQL high‑availability journey from the early MMM replication manager to the modern MHA‑Zebra and MHA‑Proxy solutions, compares each architecture, highlights their shortcomings, and outlines future directions such as distributed agents, semi‑sync replication, and Paxos‑based MySQL Group Replication.

Database ArchitectureDistributed SystemsMHA
0 likes · 12 min read
How Meituan‑Dianping Evolved MySQL HA from MMM to MHA‑Zebra and Beyond
Architecture Digest
Architecture Digest
Jun 19, 2017 · Databases

Tera: Baidu’s Large‑Scale Distributed Table System and Its Role in Real‑Time Search

The article explains how Baidu’s Tera distributed table storage system underpins the search engine’s trillion‑scale real‑time data processing, detailing its architecture, data model, high‑availability mechanisms, and performance optimizations that enable rapid link storage, index filtering, and user‑behavior analysis.

BaiduDatabase ArchitectureTera
0 likes · 9 min read
Tera: Baidu’s Large‑Scale Distributed Table System and Its Role in Real‑Time Search
Architecture Digest
Architecture Digest
Jun 16, 2017 · Databases

Redis High‑Availability Architecture and Best Practices

This article explains Redis fundamentals, details the Sentinel mechanism, compares several high‑availability deployment patterns—including Sentinel with DNS or VIP, client‑direct connections, Keepalived/Haproxy, Redis Cluster, Twemproxy, and Codis—provides their advantages and drawbacks, and offers practical best‑practice recommendations for reliable production use.

Database Architecturebest practicesfailover
0 likes · 12 min read
Redis High‑Availability Architecture and Best Practices
dbaplus Community
dbaplus Community
May 24, 2017 · Databases

Inside Amazon Aurora: Cloud‑Native Architecture, Write/Read Path, and Recovery

This article provides an in‑depth technical analysis of Amazon Aurora’s cloud‑native relational database design, covering its architectural models, log‑as‑database philosophy, optimized write and read paths, fault‑tolerant replication, group commit, and fast recovery mechanisms compared with traditional DBMS.

AuroraDatabase ArchitectureRecovery
0 likes · 27 min read
Inside Amazon Aurora: Cloud‑Native Architecture, Write/Read Path, and Recovery
Alibaba Cloud Developer
Alibaba Cloud Developer
May 24, 2017 · Databases

Rethinking Future Database Architecture: Insights from Alibaba’s Lead Engineer

In this comprehensive talk, Alibaba’s database chief Zhang Rui shares the challenges of high‑availability, cost, and elasticity in massive transaction systems, outlines innovations like AliSQL X‑Cluster, Paxos‑based consistency, X‑KV, dual‑engine storage, and discusses the evolving role of DBAs toward automation and intelligent optimization.

AliSQLDBA automationDatabase Architecture
0 likes · 23 min read
Rethinking Future Database Architecture: Insights from Alibaba’s Lead Engineer
Architecture Digest
Architecture Digest
May 6, 2017 · Databases

MongoDB Architecture and Practical Usage at the MamaBang Platform

The talk outlines MamaBang's evolution from MySQL to a multi‑zone MongoDB cluster, compares MongoDB with relational databases, discusses data‑model design, sharding, replication, transaction handling, operational challenges, and offers practical advice for teams considering MongoDB adoption.

Database ArchitectureMongoDBdata modeling
0 likes · 19 min read
MongoDB Architecture and Practical Usage at the MamaBang Platform
Architects' Tech Alliance
Architects' Tech Alliance
Feb 18, 2017 · Databases

Oracle TimesTen In-Memory Database: Architecture, Features, and Replication

Oracle TimesTen In-Memory Database, acquired by Oracle, offers a memory-optimized relational database with shared libraries, checkpointing, logging, and advanced replication options such as synchronous and asynchronous data replication, cache integration, and broad OS/CPU compatibility, positioning it as a high‑performance alternative to traditional RDBMS.

Cache ConnectDatabase ArchitectureIn-Memory Database
0 likes · 11 min read
Oracle TimesTen In-Memory Database: Architecture, Features, and Replication
dbaplus Community
dbaplus Community
Jan 3, 2017 · Databases

Implementing Parallel Stored Procedures in Oracle 10g with DBMS_SCHEDULER

This guide explains how to design and deploy a parallel execution framework for large Oracle stored procedures using DBMS_SCHEDULER, covering architecture principles, component details, development and user interfaces, database schema, view definitions, security grants, and remaining challenges such as RAC support.

DBMS_SCHEDULERDatabase ArchitectureOracle
0 likes · 12 min read
Implementing Parallel Stored Procedures in Oracle 10g with DBMS_SCHEDULER
dbaplus Community
dbaplus Community
Nov 7, 2016 · Databases

Master‑Slave MySQL Replication: Multi‑Source and Parallel Techniques Explained

This article explains MySQL replication fundamentals, explores multi‑source master‑slave architectures, details step‑by‑step configuration for both basic 1‑master‑1‑slave and multi‑source setups, introduces parallel replication to boost performance, and presents Sysbench‑based testing results that demonstrate the efficiency gains.

Database ArchitecturePerformance TestingReplication
0 likes · 13 min read
Master‑Slave MySQL Replication: Multi‑Source and Parallel Techniques Explained
ITPUB
ITPUB
Sep 2, 2016 · Databases

Comparing Popular MySQL Cluster Architectures: MHA, MySQL Cluster, and Cobar

This article reviews three mainstream MySQL clustering solutions—MHA master‑slave replication, Oracle's MySQL Cluster, and Alibaba's open‑source Cobar—detailing their architectures, advantages, drawbacks, and practical deployment considerations for high availability and scalability.

ClusterCobarDatabase Architecture
0 likes · 7 min read
Comparing Popular MySQL Cluster Architectures: MHA, MySQL Cluster, and Cobar
dbaplus Community
dbaplus Community
Aug 24, 2016 · Databases

Choosing the Right MySQL HA Architecture: Master‑Slave, Dual‑Master, Heartbeat+DRBD, and GTID

This article examines common MySQL high‑availability designs—including single master‑slave, dual‑master with multiple slaves, Heartbeat + DRBD, MySQL Cluster, semi‑synchronous replication, and GTID—explaining their benefits, drawbacks, and practical considerations for reliable failover and scalability.

DRBDDatabase ArchitectureGTID
0 likes · 9 min read
Choosing the Right MySQL HA Architecture: Master‑Slave, Dual‑Master, Heartbeat+DRBD, and GTID
ITPUB
ITPUB
Aug 23, 2016 · Databases

Designing a Zookeeper‑MHA MySQL High‑Availability Architecture: Key Insights

This talk explains how Lianjia redesigned its MySQL high‑availability setup by replacing VIP‑based failover with a Zookeeper‑driven naming service, detailing the original MHA architecture, its shortcomings, the new components, workflow, operational challenges, and a DNS‑based refinement.

DNSDatabase ArchitectureMHA
0 likes · 14 min read
Designing a Zookeeper‑MHA MySQL High‑Availability Architecture: Key Insights
Architecture Digest
Architecture Digest
Jun 25, 2016 · Databases

Understanding MySQL Logical Architecture and the Pluggable Storage Engine API

This article explains MySQL's overall logical architecture, details each component such as connectors, connection management, parser, optimizer, caches, and the pluggable storage engine framework, and provides examples of the storage engine API functions for creating, opening, scanning, indexing, and handling transactions, plus guidance on building a custom engine.

APIDatabase ArchitecturePluggable Engine
0 likes · 10 min read
Understanding MySQL Logical Architecture and the Pluggable Storage Engine API
dbaplus Community
dbaplus Community
Jun 22, 2016 · Databases

Why MySQL Outperforms NoSQL for High‑Throughput Key‑Value Storage

This article explains how MySQL can serve as a fast, reliable key‑value store, presents Wix's multi‑region deployment data showing sub‑millisecond latency and high throughput, and offers practical modeling and query guidelines to avoid typical relational bottlenecks.

Database ArchitectureNoSQLWix
0 likes · 10 min read
Why MySQL Outperforms NoSQL for High‑Throughput Key‑Value Storage
Architect
Architect
May 19, 2016 · Databases

Physical Replication in MySQL: Architecture, Log Management, and Performance Evaluation

This article explains the design and implementation of InnoDB‑based physical replication for MySQL, covering background concepts, advantages over native binlog replication, high‑level architecture, log file handling, instance roles, MVCC handling, failover procedures, and performance test results.

Database ArchitectureInnoDBPhysical Replication
0 likes · 25 min read
Physical Replication in MySQL: Architecture, Log Management, and Performance Evaluation
ITPUB
ITPUB
Apr 28, 2016 · Databases

Master Oracle Database Architecture: Instance, SGA & Key Background Processes

The article explains Oracle's database architecture, detailing how the server comprises an instance and a database, the structure and functions of the SGA memory components, and the roles of key background processes such as PMON, SMON, DBWn, LGWR, CKPT, and ARCn.

Database ArchitectureInstanceOracle
0 likes · 7 min read
Master Oracle Database Architecture: Instance, SGA & Key Background Processes
Architect
Architect
Apr 6, 2016 · Databases

MongoDB MMAPv1 Storage Engine: Data Organization and Record Management

This article explains how MongoDB's MMAPv1 storage engine organizes databases, namespaces, data files, extents, and records, detailing the structures, write, delete, update, and query processes, and how space reclamation and fragmentation are handled.

Database ArchitectureMMAPv1MongoDB
0 likes · 6 min read
MongoDB MMAPv1 Storage Engine: Data Organization and Record Management
Architecture Digest
Architecture Digest
Mar 9, 2016 · Databases

Overview of Distributed Database Systems: Concepts, Classification, Features, and Data Sharding

This article provides a comprehensive overview of distributed database systems, covering their evolution from centralized architectures, classifications, key characteristics, advantages and disadvantages, data sharding methods, allocation strategies, architectural models, and management considerations, highlighting the benefits and challenges of distributed data management.

DDBMSDatabase Architecturedata allocation
0 likes · 9 min read
Overview of Distributed Database Systems: Concepts, Classification, Features, and Data Sharding
High Availability Architecture
High Availability Architecture
Feb 26, 2016 · Databases

Weibo Database Architecture: Evolution, Optimization, and Design Practices

This article details the evolution of Weibo's database platform—from its early single‑master design through rapid scaling, vertical and horizontal sharding, automation, Redis enhancements, custom middleware, and future plans—offering practical insights into high‑availability, high‑performance data engineering for large‑scale social media services.

Database ArchitectureWeiboautomation
0 likes · 23 min read
Weibo Database Architecture: Evolution, Optimization, and Design Practices
Qunar Tech Salon
Qunar Tech Salon
Feb 25, 2016 · Databases

Scaling MySQL Master‑Slave Replication with Binlog Server: Architecture, Benefits, and Use Cases

This article explains how Booking.com solved MySQL master‑to‑hundreds‑of‑slaves bandwidth limits by introducing a Binlog Server component, detailing its design, advantages over traditional relay‑master setups, and multiple deployment scenarios for high‑availability and cross‑region replication.

Binlog ServerDatabase ArchitectureReplication
0 likes · 9 min read
Scaling MySQL Master‑Slave Replication with Binlog Server: Architecture, Benefits, and Use Cases
MaGe Linux Operations
MaGe Linux Operations
Dec 16, 2015 · Databases

Mastering MySQL Replication: Concepts, Architectures, and Advanced Strategies

This article explains MySQL replication fundamentals, detailing master‑slave and multi‑master architectures, thread roles, configuration parameters, read‑write splitting, multi‑source setups, and advanced scenarios such as multi‑level and circular replication, while highlighting common pitfalls and performance considerations.

Database ArchitectureMaster‑SlaveReplication
0 likes · 7 min read
Mastering MySQL Replication: Concepts, Architectures, and Advanced Strategies
ITPUB
ITPUB
Nov 10, 2015 · Databases

Inside PostgreSQL: How Its Three‑Layer Transaction Model Works

PostgreSQL implements transactions through a three‑layer architecture—top, middle, and bottom—where the top layer handles user‑visible commands, the middle layer processes statement‑level actions, and the bottom layer manages low‑level atomic operations, each with specific functions and state handling.

ACIDDatabase ArchitectureTransactions
0 likes · 7 min read
Inside PostgreSQL: How Its Three‑Layer Transaction Model Works
21CTO
21CTO
Nov 4, 2015 · Databases

How MySQL Architecture Scales from a Single Instance to Cloud‑Native SaaS

This article explains the evolution of MySQL architecture—from a simple single‑instance setup to vertical and horizontal scaling, sharding strategies, and cloud‑native SaaS solutions—highlighting scalability challenges, ideal states, and practical implementation steps for high‑concurrency web applications.

Database Architecturecloud SaaSmysql
0 likes · 12 min read
How MySQL Architecture Scales from a Single Instance to Cloud‑Native SaaS
21CTO
21CTO
Sep 8, 2015 · Databases

Designing Resilient MySQL Architectures for 24/7 Online Services

To ensure 24/7 availability for e‑commerce and gaming platforms, this article examines MySQL architecture from business analysis to common patterns, including read‑write ratios, consistency models, sharding strategies, historical data migration, and cluster scaling, highlighting practical designs for disaster‑tolerant, high‑performance systems.

Database Architecturemysqlread/write splitting
0 likes · 18 min read
Designing Resilient MySQL Architectures for 24/7 Online Services
Java High-Performance Architecture
Java High-Performance Architecture
Sep 1, 2015 · Databases

How a Database Server Starts, Handles, and Completes Client Requests

The article outlines the step‑by‑step lifecycle of a database server—from system initialization and buffer allocation, through connection and thread management, request parsing, optimization, storage‑engine interaction, to final response delivery and cleanup—illustrated with diagrams of each stage.

Database ArchitectureQuery ProcessingRequest Handling
0 likes · 4 min read
How a Database Server Starts, Handles, and Completes Client Requests
Architect
Architect
Jul 29, 2015 · Databases

Google App Engine Datastore: Usage, Architecture, and Implementation

This article explains how Google App Engine Datastore works from a programmer's perspective, covering its entity‑based data model, hierarchical structure, query capabilities, comparison with relational databases, and the underlying implementation built on BigTable including entities, indexes, transactions, and backup mechanisms.

BigtableDataStoreDatabase Architecture
0 likes · 10 min read
Google App Engine Datastore: Usage, Architecture, and Implementation
Architect
Architect
Jul 27, 2015 · Databases

Evolution of MySQL Architecture for Different Concurrency Levels

This article describes how MySQL architectures evolve from a single instance to vertical splitting, master‑slave replication, horizontal sharding, and cloud‑based SaaS solutions to handle increasing traffic, data size, and operational requirements while maintaining scalability and availability.

Database ArchitectureScalabilitycloud SaaS
0 likes · 13 min read
Evolution of MySQL Architecture for Different Concurrency Levels
Architect
Architect
Jul 18, 2015 · Databases

Qihoo 360’s Use of MongoDB: Architecture, Practices, and Lessons Learned

The article details how Qihoo 360 adopted MongoDB since 2011, scaling to over 100 applications, 1,500 instances and 20 billion daily queries, and shares their architectural choices, backup strategies, best‑practice recommendations, and advice for teams considering MongoDB in large‑scale, cloud‑native environments.

Backup StrategiesBig DataDatabase Architecture
0 likes · 12 min read
Qihoo 360’s Use of MongoDB: Architecture, Practices, and Lessons Learned
Architect
Architect
Jul 8, 2015 · Databases

MySQL Architecture Design: Business Analysis, Common Deployment Patterns, Sharding Strategies, and High‑Availability Practices

This article explains MySQL architecture design for 24/7 online services, covering business analysis of read‑write patterns, common deployment models, consistency levels, data migration, sharding strategies (vertical, horizontal, and business‑level), and cluster scaling for high availability.

Data MigrationDatabase Architecturemysql
0 likes · 17 min read
MySQL Architecture Design: Business Analysis, Common Deployment Patterns, Sharding Strategies, and High‑Availability Practices
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
MaGe Linux Operations
MaGe Linux Operations
Jun 23, 2014 · Databases

Scaling MySQL: From Single Instance to Cloud‑Native Sharding Architecture

This article traces MySQL’s architectural evolution—from a single‑instance setup to vertical partitioning, master‑slave replication, horizontal sharding, and finally cloud‑native SaaS—highlighting scalability strategies, sharding routing methods, consistency challenges, and automated scaling techniques for high‑concurrency web applications.

Database Architecturemysqlsharding
0 likes · 13 min read
Scaling MySQL: From Single Instance to Cloud‑Native Sharding Architecture