horizontal sharding

Architect

Sep 18, 2023 · Databases

Database Sharding: Data Partitioning Strategies, Challenges, and Practical Solutions

The article explains why relational databases become performance bottlenecks at large scales, introduces vertical and horizontal sharding techniques, discusses their advantages and drawbacks, and provides detailed guidance on handling distributed transactions, joins, pagination, global primary keys, and ID generation strategies.

ID generationShardingdatabase partitioning

0 likes · 24 min read

Database Sharding: Data Partitioning Strategies, Challenges, and Practical Solutions

Aikesheng Open Source Community

Oct 13, 2021 · Databases

MySQL Native Horizontal Sharding with MERGE Tables

This article explains MySQL's native horizontal sharding using MERGE tables, covering the concepts of horizontal versus vertical splitting, table‑level sharding and partitioning, practical examples, advantages, limitations, and suitable use cases for MERGE tables.

MERGE TableMySQLSQL

0 likes · 11 min read

MySQL Native Horizontal Sharding with MERGE Tables

Qunar Tech Salon

Feb 18, 2016 · Databases

Challenges and Strategies for Database Vertical and Horizontal Sharding

The article examines the increasing storage bottleneck in large-scale web systems, explains vertical and horizontal database sharding, discusses the technical difficulties they introduce—including join rewrites, transaction handling, and ORM integration—and proposes practical approaches to minimize service impact and manage distributed transactions.

ORMdatabase shardingdistributed transactions

0 likes · 15 min read

Challenges and Strategies for Database Vertical and Horizontal Sharding

Qunar Tech Salon

Feb 17, 2016 · Databases

Understanding 503 Errors and Database Bottlenecks: From Read‑Write Splitting to Caching, Vertical and Horizontal Sharding

The article explains that 503 errors under high concurrency are usually caused by database bottlenecks and outlines a systematic approach—including read‑write separation, caching with memcached, consistent hashing, vertical partitioning, and horizontal sharding—to improve website scalability and reliability.

503 errorMemcachedRead-Write Splitting

0 likes · 11 min read

Understanding 503 Errors and Database Bottlenecks: From Read‑Write Splitting to Caching, Vertical and Horizontal Sharding