BestHub
Sign in
Tag

horizontal partitioning

0 views collected around this technical thread.

Top Architect
Top Architect
Jun 10, 2024 · Databases

Understanding Database Sharding: When and How to Split Databases and Tables

The article explains why and when to apply database sharding and table partitioning, illustrates real‑world growth scenarios, compares horizontal and vertical splitting methods, reviews common sharding middleware such as Cobar, TDDL, Atlas, Sharding‑jdbc (ShardingSphere) and Mycat, and offers practical recommendations for different company sizes.

MySQLdatabase shardinghorizontal partitioning
0 likes · 14 min read
Understanding Database Sharding: When and How to Split Databases and Tables
Top Architect
Top Architect
Mar 14, 2023 · Databases

Why and How to Implement Database Sharding: Strategies, Middleware, and Best Practices

This article explains the need for database sharding as applications scale, describes horizontal and vertical partitioning techniques, compares popular sharding middleware, and offers practical guidance on choosing and deploying sharding solutions for different workloads.

MySQLdatabase shardinghorizontal partitioning
0 likes · 13 min read
Why and How to Implement Database Sharding: Strategies, Middleware, and Best Practices
Python Programming Learning Circle
Python Programming Learning Circle
Sep 30, 2022 · Databases

Understanding Database Sharding: Reasons, Methods, and Common Challenges

This article explains why database sharding (both vertical and horizontal) is needed to overcome performance bottlenecks, outlines practical thresholds for splitting tables, describes vertical and horizontal partitioning techniques, and discusses key issues such as distributed transactions, cross‑node queries, global primary keys, and scaling strategies.

Global IDdatabase shardingdistributed transactions
0 likes · 9 min read
Understanding Database Sharding: Reasons, Methods, and Common Challenges
Architecture & Thinking
Architecture & Thinking
Jun 25, 2022 · Databases

Why and How to Split Databases: Vertical & Horizontal Sharding Explained

This article explains the reasons for database sharding, compares vertical (scale‑up) and horizontal (scale‑out) partitioning methods, illustrates vertical database/table splits and horizontal partition strategies such as HASH, RANGE, LIST, KEY and composite, and discusses the challenges like distributed transactions, cross‑database joins and increased management overhead.

MySQLdatabase shardinghorizontal partitioning
0 likes · 14 min read
Why and How to Split Databases: Vertical & Horizontal Sharding Explained
macrozheng
macrozheng
May 11, 2022 · Databases

Mastering Database Sharding: When and How to Split Databases and Tables

This article explains the concepts of database and table sharding, why they are needed, various vertical and horizontal splitting strategies, range and hash partitioning methods, their advantages and drawbacks, timing considerations, common challenges such as transactions and distributed IDs, and introduces popular sharding middleware.

database shardingdistributed transactionshash partition
0 likes · 12 min read
Mastering Database Sharding: When and How to Split Databases and Tables
Code Ape Tech Column
Code Ape Tech Column
May 9, 2022 · Databases

Sharding-JDBC Advanced Guide: Configuration and Practical Implementation

This article provides a comprehensive guide to Sharding-JDBC, covering the challenges of database sharding such as distributed transactions, cross‑node joins, pagination, global key collisions, and demonstrates practical configuration and code examples for vertical and horizontal partitioning using Spring Boot.

Sharding-JDBCSpring Bootdatabase sharding
0 likes · 18 min read
Sharding-JDBC Advanced Guide: Configuration and Practical Implementation
HelloTech
HelloTech
Feb 21, 2022 · Databases

Database Sharding: Partitioning Strategies, Consistent Hashing, SQL Rewrite, and Merge Engine

Database sharding improves performance by partitioning tables vertically or horizontally and routing rows with consistent hashing, while ShardingJDBC rewrites SQL for physical tables, adds missing columns, corrects pagination, splits batch inserts, and merges results using sorting, grouping, aggregation, and pagination engines.

MERGE EngineSQL Rewriteconsistent hashing
0 likes · 15 min read
Database Sharding: Partitioning Strategies, Consistent Hashing, SQL Rewrite, and Merge Engine
Selected Java Interview Questions
Selected Java Interview Questions
Dec 28, 2021 · Databases

Understanding Database Sharding: Concepts, Strategies, Mycat and Sharding-JDBC

This article explains what database sharding (horizontal and vertical partitioning) is, why it is needed, the implementation strategies, and compares two popular solutions—Mycat middleware and Sharding-JDBC—highlighting their advantages, drawbacks, and typical use cases.

DatabaseMycatSharding
0 likes · 10 min read
Understanding Database Sharding: Concepts, Strategies, Mycat and Sharding-JDBC
Wukong Talks Architecture
Wukong Talks Architecture
Nov 10, 2021 · Databases

Understanding Database Sharding: Vertical and Horizontal Partitioning Strategies

This article explains why and how to apply vertical (business‑oriented) and horizontal (data‑oriented) sharding, covering single‑database, table splitting, database splitting, combined sharding, read‑write separation, routing algorithms, and real‑world case studies to improve scalability and performance.

Read-Write Separationdatabase shardinghorizontal partitioning
0 likes · 14 min read
Understanding Database Sharding: Vertical and Horizontal Partitioning Strategies
Top Architect
Top Architect
Nov 6, 2021 · Databases

Understanding Database Sharding: Partitioning Strategies and When to Use Them

This article explains the concepts, characteristics, and practical scenarios of database sharding—including vertical and horizontal table partitioning as well as vertical and horizontal database partitioning—helping developers decide when and how to apply each strategy to improve scalability and performance.

MySQLShardingdatabase partitioning
0 likes · 10 min read
Understanding Database Sharding: Partitioning Strategies and When to Use Them
High Availability Architecture
High Availability Architecture
Oct 26, 2021 · Databases

Practical Guide to Horizontal Database Sharding: Design Principles, Common Schemes, and Expansion Strategies

This article explains the background, design criteria, and practical implementations of horizontal database sharding—including range, hash, gene, routing‑table, and consistent‑hash methods—while discussing common pitfalls, data‑skew mitigation, and both doubling and consistent‑hash expansion techniques for MySQL clusters.

Database ScalingMySQLSharding
0 likes · 24 min read
Practical Guide to Horizontal Database Sharding: Design Principles, Common Schemes, and Expansion Strategies
Java Captain
Java Captain
Oct 6, 2021 · Databases

Understanding MySQL Sharding: Vertical/Horizontal Table and Database Partitioning Strategies

This article explains the concepts, characteristics, and practical scenarios of vertical and horizontal table partitioning as well as vertical and horizontal database sharding in MySQL, helping developers decide when and how to apply each strategy for large‑scale applications.

MySQLShardingdatabase partitioning
0 likes · 8 min read
Understanding MySQL Sharding: Vertical/Horizontal Table and Database Partitioning Strategies
Architect
Architect
Sep 28, 2021 · Databases

Database Sharding Strategies: When to Use Vertical, Horizontal, and Range Partitioning

This article explains how to decide between database and table sharding, describes vertical, horizontal, and range partitioning techniques, discusses their trade‑offs and implementation details, and offers practical guidance for solving query challenges in high‑traffic, write‑intensive systems.

Range Shardingdatabase shardinghorizontal partitioning
0 likes · 10 min read
Database Sharding Strategies: When to Use Vertical, Horizontal, and Range Partitioning
Top Architect
Top Architect
Jun 22, 2021 · Databases

Database Sharding: Strategies, Bottlenecks, and Best Practices

This article explains the performance bottlenecks of relational databases, introduces sharding concepts such as horizontal, vertical, and table partitioning, discusses associated challenges like distributed transactions and global primary keys, and provides practical solutions and tool recommendations for implementing effective database partitioning.

Global ID Generationdatabase shardingdistributed transactions
0 likes · 18 min read
Database Sharding: Strategies, Bottlenecks, and Best Practices
Code Ape Tech Column
Code Ape Tech Column
Mar 22, 2021 · Databases

Database Sharding: Horizontal Partitioning, Hash Modulo and Range Schemes, and a Hybrid Design

The article explains vertical and horizontal database sharding, compares hash-modulo and range partitioning schemes with their advantages and drawbacks, and proposes a hybrid group‑based design that balances load, avoids hotspots, and simplifies scaling without costly data migrations.

database shardinghash modulohorizontal partitioning
0 likes · 12 min read
Database Sharding: Horizontal Partitioning, Hash Modulo and Range Schemes, and a Hybrid Design
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
Architect
Architect
Oct 27, 2020 · Databases

Database Bottlenecks and Sharding: Strategies for Horizontal and Vertical Partitioning

This article examines common database performance bottlenecks such as I/O and CPU limits, explains the concepts, results, and scenarios of horizontal and vertical sharding—including database and table partitioning—and outlines tools, steps, and challenges for implementing effective sharding solutions.

Shardingdatabaseshorizontal partitioning
0 likes · 11 min read
Database Bottlenecks and Sharding: Strategies for Horizontal and Vertical Partitioning
Top Architect
Top Architect
Oct 20, 2020 · Databases

Database Bottlenecks and Sharding Strategies

This article analyzes common database performance bottlenecks such as I/O and CPU limits, explains how horizontal and vertical sharding (including database and table partitioning) can alleviate these issues, introduces practical tools and step‑by‑step implementation guidance, and discusses related challenges like non‑partition key queries and scaling.

Shardingdatabaseshorizontal partitioning
0 likes · 8 min read
Database Bottlenecks and Sharding Strategies
Laravel Tech Community
Laravel Tech Community
May 23, 2020 · Databases

Database Sharding: Principles, Methods, and Tools

The article explains why and when to apply database sharding, describes horizontal and vertical partitioning methods, lists common sharding tools, and discusses challenges such as distributed transactions, join avoidance, pagination, and global primary key generation.

database shardingdistributed transactionsglobal primary key
0 likes · 14 min read
Database Sharding: Principles, Methods, and Tools
Java Captain
Java Captain
Mar 22, 2020 · Databases

Database Bottlenecks and Sharding Strategies: Horizontal/Vertical Partitioning, Tools, and Best Practices

This article analyzes common database I/O and CPU bottlenecks, explains horizontal and vertical sharding concepts, presents practical sharding rules, discusses tooling such as Sharding‑Sphere, TDDL and Mycat, and outlines step‑by‑step procedures and common pitfalls for scaling relational databases.

Shardingdatabaseshorizontal partitioning
0 likes · 11 min read
Database Bottlenecks and Sharding Strategies: Horizontal/Vertical Partitioning, Tools, and Best Practices