Tagged articles
117 articles
Page 2 of 2
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 ArchitectureMessage Queuecaching
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.

Distributed Transactionsdatabase scalingprimary 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 MigrationOracledatabase scaling
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 MigrationMongoDB
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.

OperationsPartitioningdatabase scaling
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.

Read-Write SeparationReplicationbinary log
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.

NoSQLRelational Databasedata modeling
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.

Read-Write SeparationSession Managementcaching
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.

MongoDBReplicationSecurity
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.

PartitioningRedis ClusterTwemproxy
0 likes · 11 min read
Redis Partitioning: How to Store Data Across Multiple Redis Instances

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 RDSMySQL replication
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 QueriesPartitioningReplication
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.

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