BestHub
Sign in
Tagged articles
11 articles
Page 1 of 1
Su San Talks Tech
Su San Talks Tech
Apr 29, 2025 · Databases

Why Split Databases? Master Sharding Concepts, Strategies, and Practical SQL Routing

This article explains the fundamental concepts of database sharding—including data nodes, logical and broadcast tables, sharding keys, strategies, algorithms, SQL parsing, routing, rewriting, execution, result merging, distributed primary keys, data masking, distributed transactions, data migration, and shadow databases—providing clear examples and code snippets for real‑world implementation.

Data MigrationDistributed TransactionsSQL Routing
0 likes · 21 min read
Why Split Databases? Master Sharding Concepts, Strategies, and Practical SQL Routing
macrozheng
macrozheng
Dec 28, 2023 · Databases

Mastering Sharding: 21 Core Concepts for Scalable Database Design

This article introduces the essential concepts of sharding architecture—including data partitioning, logical and physical tables, sharding keys, routing strategies, SQL rewriting, distributed primary keys, data masking, transactions, migration, and shadow databases—providing a comprehensive guide for building high‑performance, horizontally scaled database systems.

Broadcast TableDistributed SystemsSQL Routing
0 likes · 21 min read
Mastering Sharding: 21 Core Concepts for Scalable Database Design
Wukong Talks Architecture
Wukong Talks Architecture
May 16, 2023 · Databases

Understanding Sharding: 21 Common Concepts of Database Partitioning

This article introduces the fundamental concepts of database sharding, including data fragmentation, nodes, logical and physical tables, broadcast and single tables, sharding keys, strategies, algorithms, binding tables, SQL parsing, routing, rewriting, execution, result merging, distributed primary keys, data masking, distributed transactions, migration, and shadow databases, providing a comprehensive guide for designing and operating a sharded architecture.

Broadcast TableSQL Routingbinding tables
0 likes · 19 min read
Understanding Sharding: 21 Common Concepts of Database Partitioning
360 Tech Engineering
360 Tech Engineering
Apr 19, 2023 · Databases

ProxySQL Overview: Core Features, Configuration Layers, and Practical Use Cases

This article introduces ProxySQL as a high‑performance MySQL proxy, explains its request flow, multi‑layer configuration system, key tables, and demonstrates practical scenarios such as read‑write splitting, hostgroup weight tuning, replication‑lag handling, blacklist/whitelist rules, and firewall protection.

Database ProxyProxySQLSQL Routing
0 likes · 26 min read
ProxySQL Overview: Core Features, Configuration Layers, and Practical Use Cases
Huolala Tech
Huolala Tech
Apr 17, 2023 · Big Data

How HuoLala Accelerated Ad‑hoc Queries with a Hybrid Offline Engine

This article describes how HuoLala identified slow ad‑hoc query performance in its Hive‑on‑Tez stack, surveyed comparable industry solutions, and built a multi‑engine hybrid offline service that dramatically improves query latency, outlines its architecture, key design decisions, production impact, and future roadmap.

Big DataDistributed SystemsSQL Routing
0 likes · 12 min read
How HuoLala Accelerated Ad‑hoc Queries with a Hybrid Offline Engine
ITPUB
ITPUB
Feb 14, 2023 · Databases

Mastering Database Read‑Write Splitting: Techniques, Use‑Cases, and Top Tools

This article provides a comprehensive overview of database read‑write splitting, detailing its benefits, core technical implementations, practical best‑practice guidelines, and a comparison of popular open‑source and commercial products that enable efficient read‑write traffic distribution.

ConsistencyDatabase OptimizationRead‑Write Splitting
0 likes · 21 min read
Mastering Database Read‑Write Splitting: Techniques, Use‑Cases, and Top Tools
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 23, 2022 · Databases

DBLE Cache Mechanism: Primary‑Key Routing Issue, Diagnosis and Resolution

This article examines the DBLE distributed database middleware cache, reproduces a primary‑key update query that returns incomplete results due to stale routing cache, analyzes cache contents via the management console, explains the cache’s behavior and limitations, and shows how disabling the primary‑key cache restores correct query routing.

CacheDBLESQL Routing
0 likes · 10 min read
DBLE Cache Mechanism: Primary‑Key Routing Issue, Diagnosis and Resolution
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 13, 2020 · Databases

Sharding-JDBC: Basic Usage and Core Principles

This article introduces Sharding-JDBC, explaining its basic usage, core concepts, sharding strategies, SQL processing workflow, configuration examples, and code snippets, while emphasizing the importance of understanding its underlying principles for effective database horizontal partitioning in Java applications.

JavaSQL RoutingSharding-JDBC
0 likes · 70 min read
Sharding-JDBC: Basic Usage and Core Principles
dbaplus Community
dbaplus Community
Dec 10, 2019 · Databases

Unveiling Sharding-Proxy: Transparent Database Sharding in Apache ShardingSphere

This talk walks through Sharding-Proxy’s role within Apache ShardingSphere, detailing its architecture, SQL lifecycle from protocol decoding to routing, rewriting, execution, and result merging, while highlighting core principles, performance bottlenecks, and practical optimization techniques for high‑throughput, low‑latency database proxying.

Distributed TracingNettySQL Routing
0 likes · 17 min read
Unveiling Sharding-Proxy: Transparent Database Sharding in Apache ShardingSphere
dbaplus Community
dbaplus Community
Jul 27, 2017 · Databases

How Sharding-JDBC Transforms Relational Databases for Scalable Cloud‑Native Applications

This article explains the core functions of relational‑database middleware, dives into Sharding-JDBC’s architecture, performance characteristics, and implementation details such as sharding rules, SQL parsing, routing, rewrite, execution, result merging, and distributed primary‑key generation, and outlines its future roadmap.

Database MiddlewareDistributed TransactionsJava
0 likes · 21 min read
How Sharding-JDBC Transforms Relational Databases for Scalable Cloud‑Native Applications
Architecture Digest
Architecture Digest
May 21, 2016 · Databases

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

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

Database MiddlewareMycatSQL Routing
0 likes · 9 min read
An Overview of MyCat: Open‑Source Distributed Database Middleware and Its Technical Features