BestHub
Sign in
Tagged articles

Database Scaling

123 articles · Page 2 of 2
Architecture Digest
Architecture Digest
Nov 3, 2017 · Databases

Understanding Database Sharding: Why It Matters and How to Implement It

Database sharding, or splitting databases into multiple instances and tables, is essential for scaling backend systems; this article explains its importance, historical context, core concepts, storage stretching techniques, index and consistency handling, and provides a practical design example for transaction systems.

Backend ArchitectureDatabase ScalingIndexing
0 likes · 11 min read
Understanding Database Sharding: Why It Matters and How to Implement It
21CTO
21CTO
Aug 24, 2017 · Databases

How JD.com Guarantees Database Performance During Billion‑Scale Sales Events

This article details JD.com’s comprehensive strategies—including architecture design, pre‑event preparation, real‑time safeguards, and post‑event analysis—to ensure MySQL databases remain high‑performance and highly available during massive traffic spikes like 618 and Double‑11 sales.

AutomationDatabase ScalingMySQL
0 likes · 23 min read
How JD.com Guarantees Database Performance During Billion‑Scale Sales Events
Architecture Digest
Architecture Digest
Aug 8, 2017 · Backend Development

Scalability Design of Website Systems: Architecture and Load‑Balancing Strategies

This article explains how website systems achieve scalability through architectural designs such as physical function separation, server clustering, various load‑balancing techniques, distributed cache mechanisms, and both relational and NoSQL database scaling methods, providing practical guidance for large‑scale web deployments.

Backend ArchitectureDatabase ScalingLoad Balancing
0 likes · 13 min read
Scalability Design of Website Systems: Architecture and Load‑Balancing Strategies
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Jul 28, 2017 · Databases

Sharding Mastery: Strategies, Key Generation & Seamless Scaling

This article presents a comprehensive guide to database sharding, covering implementation strategies, vertical and horizontal partitioning, global primary key generation techniques, framework versus custom solutions, multi‑data‑source transaction handling, and a novel, migration‑free scaling approach that combines incremental range and hash‑based routing.

Database Scalingbackend developmentdistributed transactions
0 likes · 31 min read
Sharding Mastery: Strategies, Key Generation & Seamless Scaling
21CTO
21CTO
Apr 22, 2017 · Backend Development

How to Build a High‑Performance Flash Sale (Seckill) System: Architecture, Challenges & Solutions

This article analyzes the business flow, technical challenges, and architectural design of a flash‑sale (seckill) system, offering practical solutions for isolation, high‑concurrency handling, database sharding, caching, cheating prevention, and data consistency to ensure reliable high‑traffic e‑commerce operations.

Database ScalingFlash Salebackend
0 likes · 33 min read
How to Build a High‑Performance Flash Sale (Seckill) System: Architecture, Challenges & Solutions
Architecture Digest
Architecture Digest
Nov 24, 2016 · Backend Development

High Concurrency Architecture and Practical Solutions for E‑commerce Applications

This article outlines the challenges of high‑traffic scenarios such as flash sales and timed red‑packet distribution, and presents a comprehensive backend architecture—including load balancing, database clustering, NoSQL caching, CDN, concurrency testing, message queues, first‑level caching, and static data strategies—to ensure smooth operation and optimal user experience.

Backend ArchitectureDatabase ScalingLoad Balancing
0 likes · 11 min read
High Concurrency Architecture and Practical Solutions for E‑commerce Applications
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Nov 4, 2016 · Databases

Mastering Sharding: Strategies, Key Generation, and Seamless Scaling

This article explains practical sharding implementation strategies, global primary‑key generation techniques, framework versus custom solutions, distributed transaction models, and a flexible expansion scheme that avoids data migration while maintaining performance and scalability.

Database Scalingdistributed transactionsprimary key generation
0 likes · 31 min read
Mastering Sharding: Strategies, Key Generation, and Seamless Scaling
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Oct 13, 2016 · Databases

How to Scale Order Systems with Horizontal Database Sharding: A Real‑World Case Study

This article presents a comprehensive, practice‑driven analysis of horizontal database sharding for a high‑traffic e‑commerce order system, covering sharding dimensions, strategies, quantity planning, transparent routing, pagination challenges, lookup mapping, overall architecture, deployment steps, and the measurable performance and cost benefits achieved.

Data MigrationDatabase ScalingHorizontal Sharding
0 likes · 14 min read
How to Scale Order Systems with Horizontal Database Sharding: A Real‑World Case Study
ITPUB
ITPUB
Sep 26, 2016 · Databases

When and How MongoDB Balancer Migrates Chunks in a Sharded Cluster

This article explains the three scenarios that trigger MongoDB chunk migration, describes the Balancer's lock‑based operation, and walks through the six detailed steps—including tag‑based splits, draining shard handling, and load‑balancing thresholds—that ensure data is evenly distributed across shards.

BalancerChunk MigrationDatabase Scaling
0 likes · 8 min read
When and How MongoDB Balancer Migrates Chunks in a Sharded Cluster
Qunar Tech Salon
Qunar Tech Salon
Sep 7, 2016 · Databases

Principles and Practices of MySQL Database Sharding

The article explains when MySQL sharding is needed, outlines five practical principles for deciding to split databases or tables, provides real‑world examples, and shares operational tips for implementing horizontal partitioning to improve performance, availability, and manageability.

Database ScalingMySQLOperations
0 likes · 8 min read
Principles and Practices of MySQL Database Sharding
dbaplus Community
dbaplus Community
Jun 1, 2016 · Databases

Unlocking MySQL Replication: What, Why, and How Explained

This article uses the Golden Circle framework to explore MySQL replication, detailing its definition, benefits such as scaling and fault tolerance, the underlying mechanisms involving binary logs and IO/SQL threads, and addressing common practical questions through a self‑Q&A format.

Binary LogDatabase ScalingMySQL
0 likes · 13 min read
Unlocking MySQL Replication: What, Why, and How Explained
21CTO
21CTO
May 15, 2016 · Databases

Why MySQL Still Matters and When to Choose NoSQL Alternatives

The article compares relational databases like MySQL—highlighting their consistency, transaction support, and join capabilities—with NoSQL alternatives, explaining each type’s strengths and limitations in handling massive writes, schema changes, variable fields, and simple queries, and guides developers on when to choose each.

Data ModelingDatabase ScalingMySQL
0 likes · 10 min read
Why MySQL Still Matters and When to Choose NoSQL Alternatives
Qunar Tech Salon
Qunar Tech Salon
Feb 16, 2016 · Backend Development

Evolution and Scaling Strategies for Large Websites: Architecture, Session Management, and Database Optimization

The article reviews the evolution of large‑scale website architecture, explaining how business complexity, multi‑server deployment, session handling, load balancing, database read/write separation, caching, and search indexing together address availability, concurrency, and performance challenges in modern web systems.

Database ScalingLoad BalancingRead-Write Separation
0 likes · 16 min read
Evolution and Scaling Strategies for Large Websites: Architecture, Session Management, and Database Optimization
21CTO
21CTO
Dec 14, 2015 · Databases

MongoDB Master Russell Smith’s Essential Best‑Practice Checklist

This article compiles Russell Smith’s comprehensive MongoDB best‑practice guide, covering architecture choices, file limits, write safety, schema design, replication, sharding, security, and performance tuning to help engineers avoid common pitfalls and optimize production deployments.

Database ScalingMongoDBSharding
0 likes · 16 min read
MongoDB Master Russell Smith’s Essential Best‑Practice Checklist
Architect
Architect
Dec 13, 2015 · Databases

Redis Partitioning: How to Store Data Across Multiple Redis Instances

This article explains the concept, benefits, methods, and practical considerations of partitioning data across multiple Redis instances, covering range and hash partitioning, consistent hashing, implementation options, drawbacks, and recommended tools such as Redis Cluster and Twemproxy.

Database ScalingPartitioningRedis
0 likes · 11 min read
Redis Partitioning: How to Store Data Across Multiple Redis Instances
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Nov 6, 2015 · Databases

Airbnb’s Database Scaling Using MySQL Replication and Vertical Sharding

Airbnb tackled rapid data growth by vertically partitioning tables across multiple MySQL databases using Amazon RDS replication, minimizing downtime through read‑replica promotion, and implementing a staged migration that reduced primary database writes by 33%, cut size by 20%, and improved stability and scalability.

AirbnbAmazon RDSDatabase Scaling
0 likes · 12 min read
Airbnb’s Database Scaling Using MySQL Replication and Vertical Sharding
Qunar Tech Salon
Qunar Tech Salon
Apr 20, 2015 · Databases

Practical MySQL Scaling and Sharding Strategies at 58.com under Big Data Loads

This article presents 58.com’s experience with MySQL under massive data volumes, covering core concepts such as single‑instance, sharding, replication and grouping, common availability and read‑write challenges, detailed sharding implementations for user, post, friend and order tables, and post‑sharding business practices including IN queries, non‑partition key queries, and cross‑database pagination.

Cross‑Shard QueriesDatabase ScalingMySQL
0 likes · 10 min read
Practical MySQL Scaling and Sharding Strategies at 58.com under Big Data Loads
ITPUB
ITPUB
Dec 5, 2014 · Databases

From DBA to Architecture Lead: MySQL Scaling Secrets from BabyTree’s Ops Director

In this interview, Liu Qiuqi shares his journey from a DBA at Sogou to Architecture Operations Director at BabyTree, revealing how MySQL powers massive e‑commerce and community sites, the high‑availability designs, storage strategies, and performance tuning techniques that keep services running smoothly.

DBADatabase ScalingMySQL
0 likes · 16 min read
From DBA to Architecture Lead: MySQL Scaling Secrets from BabyTree’s Ops Director