Database Architecture

Sohu Tech Products

Jun 11, 2025 · Databases

Unlocking MySQL InnoDB: Deep Dive into Tablespaces, Undo Logs, and Indexes

This article explains MySQL InnoDB's dual memory and on‑disk architecture, detailing the various tablespace types (system, file‑per‑table, general, undo, temporary), their internal structures (segments, extents, pages), configuration tips, and how tables, row formats, primary keys, auto‑increment lock modes, and B+Tree indexes are organized and managed.

Database ArchitectureIndexesInnoDB

0 likes · 18 min read

Unlocking MySQL InnoDB: Deep Dive into Tablespaces, Undo Logs, and Indexes

Sanyou's Java Diary

Jun 9, 2025 · Databases

Inside InnoDB: How Buffer Pool, Change Buffer, and Adaptive Hash Index Boost MySQL Performance

This article explores the inner workings of InnoDB's architecture—including the Buffer Pool, Change Buffer, Adaptive Hash Index, and Log Buffer—detailing their designs, configuration parameters, performance impacts, and best‑practice recommendations for high‑throughput MySQL deployments.

Adaptive Hash IndexBuffer PoolChange Buffer

0 likes · 15 min read

Inside InnoDB: How Buffer Pool, Change Buffer, and Adaptive Hash Index Boost MySQL Performance

Baidu Geek Talk

Jun 9, 2025 · Databases

How BaikalDB Tackles OLAP Challenges with Vectorized and MPP Engines

BaikalDB, Baidu's distributed storage system, evolves from an OLTP‑focused engine to a hybrid HTAP architecture by introducing a vectorized query engine and a massively parallel processing (MPP) layer, addressing compute and resource bottlenecks for large‑scale analytical workloads while preserving transactional guarantees.

BaikalDBDatabase ArchitectureHTAP

0 likes · 18 min read

How BaikalDB Tackles OLAP Challenges with Vectorized and MPP Engines

Java Captain

Apr 17, 2025 · Databases

Choosing Between Sharding Middleware and NewSQL Distributed Databases: An Objective Comparison

This article objectively compares middleware‑based sharding with NewSQL distributed databases, examining their architectural differences, transaction models, high‑availability mechanisms, scaling, 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

Choosing Between Sharding Middleware and NewSQL Distributed Databases: An Objective Comparison

Aikesheng Open Source Community

Mar 31, 2025 · Databases

Smarter Query Routing with MySQL Routing Guidelines

The article explains how MySQL Shell and MySQL Router 9.2 introduce Routing Guidelines, a declarative, context‑aware query routing feature that lets administrators define fine‑grained rules based on server roles, session attributes, and network information to improve latency, load‑balancing, and fault‑tolerance in complex MySQL topologies.

AdminAPIDatabase ArchitectureMySQL

0 likes · 14 min read

Smarter Query Routing with MySQL Routing Guidelines

Java Architect Essentials

Mar 14, 2025 · Databases

Comparing NewSQL Databases with Middleware‑Based Sharding: Advantages, Trade‑offs, and Selection Guidance

This article objectively compares NewSQL distributed databases with traditional middleware‑based sharding solutions, examining their architectures, distributed transaction handling, high‑availability, scaling, storage engines, and ecosystem maturity, and provides guidance on selecting the appropriate approach based on consistency, growth, operational capacity, and performance requirements.

Database ArchitectureHigh AvailabilityNewSQL

0 likes · 19 min read

Comparing NewSQL Databases with Middleware‑Based Sharding: Advantages, Trade‑offs, and Selection Guidance

Zhuanzhuan Tech

Dec 13, 2024 · Databases

Understanding MySQL Architecture and Log Mechanisms for ACID Transactions

This article provides a comprehensive overview of MySQL's layered architecture, the functions and core components of the server layer, and detailed explanations of Undo Log, Redo Log, and Binlog mechanisms that together ensure the ACID properties of transactions, including practical execution flows for queries and updates.

ACIDDatabase ArchitectureMySQL

0 likes · 29 min read

Understanding MySQL Architecture and Log Mechanisms for ACID Transactions

IT Services Circle

Dec 5, 2024 · Databases

Understanding High-Concurrency Connection Issues in PostgreSQL and the Benefits of Using pgBouncer

The article explains how thousands of simultaneous client connections to a single PostgreSQL primary can cause severe write‑performance degradation, how introducing a connection pool such as pgBouncer reduces active backend processes dramatically, and why external pooling is preferred over built‑in solutions, illustrated with real‑world examples and a reference to the open‑source Pigsty distribution.

Database ArchitecturePerformancePigsty

0 likes · 7 min read

Understanding High-Concurrency Connection Issues in PostgreSQL and the Benefits of Using pgBouncer

58 Tech

Oct 28, 2024 · Databases

Design and Practices of Multi‑Tenant Database Management in the QiaoFang SaaS System

This article examines the QiaoFang SaaS platform’s multi‑tenant database architecture, tenant data governance, multi‑partition service design, and operational practices such as database operations, cleanup, and monitoring, highlighting the challenges and solutions for large‑scale real‑estate brokerage services.

Data GovernanceDatabase ArchitectureSaaS

0 likes · 17 min read

Design and Practices of Multi‑Tenant Database Management in the QiaoFang SaaS System

Baidu Tech Salon

Oct 22, 2024 · Big Data

TDE-ClickHouse: Baidu MEG's High-Performance Big Data Analytics Engine

TDE‑ClickHouse, the core engine of Baidu MEG’s Turing 3.0 ecosystem, delivers sub‑second, self‑service analytics on petabyte‑scale data by decoupling compute, adding multi‑level aggregation, high‑cardinality and rule‑based optimizations, a two‑phase bulk‑load pipeline, cloud‑native deployment, and a lightweight meta service, now powering over 350 000 cores, 10 PB storage and more than 150 000 daily BI queries with average response times under three seconds.

ClickHouseCloud NativeDatabase Architecture

0 likes · 19 min read

TDE-ClickHouse: Baidu MEG's High-Performance Big Data Analytics Engine

Full-Stack Internet Architecture

Oct 17, 2024 · Databases

Understanding MySQL Architecture: A Comprehensive Overview of Its Logical Layers

This article explains MySQL's logical architecture, detailing the four main layers—connection, core service, storage engine, and data storage—while providing code examples and insights into each component's role in the widely used open‑source relational database.

Connection LayerDatabase ArchitectureMySQL

0 likes · 9 min read

Understanding MySQL Architecture: A Comprehensive Overview of Its Logical Layers

Java Tech Enthusiast

Oct 3, 2024 · Databases

Understanding MySQL Architecture and SQL Execution Flow

The article outlines MySQL’s layered architecture—connector, parser, optimizer, executor, and binary log in the server layer and pluggable storage engines like InnoDB—then walks through the step‑by‑step processing of SELECT and UPDATE statements, highlighting permission checks, caching, plan selection, redo and binlog handling for crash‑safe durability.

Database ArchitectureInnoDBMySQL

0 likes · 11 min read

Understanding MySQL Architecture and SQL Execution Flow

Architect's Guide

Sep 29, 2024 · Databases

Advantages of NewSQL Databases Over Middleware‑Based Sharding: Architecture, Transactions, HA, and Scaling

This article objectively compares NewSQL distributed databases with traditional middleware‑based sharding, examining their architectural advantages, distributed transaction handling, high‑availability mechanisms, scaling and sharding strategies, storage engine differences, ecosystem maturity, and provides guidance on selecting the appropriate solution for various workloads.

Database ArchitectureHigh AvailabilityNewSQL

0 likes · 21 min read

Advantages of NewSQL Databases Over Middleware‑Based Sharding: Architecture, Transactions, HA, and Scaling

IT Services Circle

Sep 15, 2024 · Databases

The Story Behind SQLite: From Naval Software to the World's Most Popular Embedded Database

This article recounts how SQLite was created by Richard Hipp to solve reliability issues on a U.S. Navy destroyer, evolved from a simple file‑based engine into an open‑source, B‑Tree powered embedded database that now powers billions of devices, smartphones, browsers, and applications worldwide.

B+ TreeDatabase ArchitectureEmbedded Database

0 likes · 7 min read

The Story Behind SQLite: From Naval Software to the World's Most Popular Embedded Database

Architecture & Thinking

Aug 15, 2024 · Databases

How to Evolve Your Database Architecture for Massive Scale: From Monolith to Sharding

This article outlines the progressive evolution of database architectures—from simple monolithic designs to cold‑hot separation, read‑write splitting, and horizontal sharding—explaining each pattern, its components, and the performance and scalability benefits they bring to large‑scale systems.

Cold-Hot SeparationDatabase ArchitectureMySQL

0 likes · 8 min read

How to Evolve Your Database Architecture for Massive Scale: From Monolith to Sharding

DevOps

Jul 28, 2024 · Databases

Redis: Features, Use Cases, Architecture, Data Types, Commands, and Tencent Cloud Redis Overview

Redis, an open-source in-memory NoSQL database, is explored in depth covering its high-performance features, typical use cases, evolution, architecture, data types and commands, followed by an overview of Tencent Cloud Redis services and a brief advertisement for a DevOps certification program.

CachingDatabase ArchitectureIn-Memory Database

0 likes · 8 min read

Redis: Features, Use Cases, Architecture, Data Types, Commands, and Tencent Cloud Redis Overview

Practical DevOps Architecture

Jun 4, 2024 · Databases

Causes and Solutions for MySQL Master‑Slave Replication Lag

This article explains why MySQL master‑slave replication can become delayed—including single‑threaded binlog processing, high load, network latency, and configuration issues—and provides detailed troubleshooting steps and practical solutions such as semi‑synchronous replication, hardware upgrades, and configuration tuning.

Database ArchitectureMySQLPerformance Tuning

0 likes · 8 min read

Causes and Solutions for MySQL Master‑Slave Replication Lag

Efficient Ops

Jun 3, 2024 · Databases

How Does MySQL Execute a Query? Inside the Server Architecture

This article walks through how MySQL processes a SELECT query, detailing the server and storage engine layers, the roles of the connector, query cache, parser, optimizer, and executor, and provides practical command‑line examples to illustrate each step.

ConnectorDatabase ArchitectureExecutor

0 likes · 11 min read

How Does MySQL Execute a Query? Inside the Server Architecture

Java Architect Essentials

May 19, 2024 · Databases

Choosing Between NewSQL Databases and Middleware‑Based Sharding: A Comparative Analysis

This article objectively compares NewSQL distributed databases with traditional middleware‑based sharding solutions, examining their architectures, distributed transaction support, high availability, scaling, storage engines, SQL capabilities, maturity, and suitability for various workloads, to help architects decide which approach best fits their needs.

Database ArchitectureNewSQLdistributed transactions

0 likes · 20 min read

Choosing Between NewSQL Databases and Middleware‑Based Sharding: A Comparative Analysis

Selected Java Interview Questions

May 10, 2024 · Databases

Comparing NewSQL Databases with Middleware‑Based Sharding: Advantages, Limitations, and Practical Guidance

This article objectively compares NewSQL databases and middleware‑plus‑sharding architectures, examining their core principles, distributed transaction handling, high‑availability mechanisms, scaling and sharding strategies, SQL support, storage engines, and maturity to help engineers decide which solution fits their workload.

Database ArchitectureHigh AvailabilityNewSQL

0 likes · 18 min read

Comparing NewSQL Databases with Middleware‑Based Sharding: Advantages, Limitations, and Practical Guidance