Tag: Sharding
7 articles
MySQL Database Sharding: Vertical vs Horizontal Partitioning
Database sharding explained: vertical partitioning, horizontal partitioning, vertical sharding, vertical table splitting, horizontal table splitting. This article analyzes principles and practical ...
MySQL Sharding Technologies Compared: Range, Hash, Consis...
Sharding is the core technology for horizontal scaling in distributed databases. This article provides a comprehensive analysis of range-based, hash-based, and consistent hash sharding strategies w...
MySQL Sharding-JDBC: Physical Tables, Logical Tables & Bi...
In distributed databases, sharding is implemented through physical tables, logical tables, data nodes and binding tables. Binding tables ensure master and child tables use the same sharding rules, ...
MySQL ShardingSphere: SQL Parse, Route, Rewrite & Execute...
Deep dive into ShardingSphere's sharding flow including SQL parsing, query optimization, SQL routing, SQL rewriting, SQL execution and result merging six major stages with detailed technical analysis.
MySQL ShardingSphere: SQL Support, Limitations & Optimiza...
Deep dive into ShardingSphere's SQL support scope, limitations, and optimization practices in sharding scenarios. Learn about supported SQL types, pagination subquery restrictions, and best practices.
MySQL Sharding-JDBC: Physical, Logical & Binding Tables E...
In distributed databases, sharding uses physical tables, logical tables, data nodes and binding tables for efficient data storage and queries. Binding tables ensure master and child tables use same...
MongoDB Sharding: Shard, Config Server, Mongos Complete G...
MongoDB sharded cluster detailed explanation: sharding consists of Shard, Config Server, Mongos. Shard key selection includes range sharding, hashed sharding, zone sharding. Includes minimal runnab...