Sharding-JDBC Source Code Analysis and Custom Development

The article dissects Sharding‑JDBC’s five core engines—parsing, routing, rewriting, execution, and merging—highlights production pain points, and details custom extensions such as skipping sharding for specific tables, forcing master routing, runtime configuration refresh, batch‑update handling, sharding‑condition deduplication, full‑route validation, and a simplified component wrapper to ease integration and improve performance.

Custom DevelopmentDatabase MiddlewareExecution Engine

0 likes · 55 min read

Sharding-JDBC Source Code Analysis and Custom Development

Top Architect

Aug 18, 2023 · Databases

MySQL Table Splitting and Pagination Using the MERGE Engine

This article explains how to split a massive MySQL table into smaller tables, use the MERGE engine to create a unified view, troubleshoot common errors, and implement efficient pagination across the split tables with example SQL and Java code.

MERGE engineSQLTable Partitioning

0 likes · 6 min read

MySQL Table Splitting and Pagination Using the MERGE Engine

Selected Java Interview Questions

Oct 12, 2022 · Backend Development

MySQL Table Splitting and Pagination Using the MERGE Engine

This article explains how to handle massive MySQL tables by splitting a single large table into multiple smaller tables, creating a MERGE (union) table to combine them, and using the merged view to implement efficient pagination, including necessary SQL statements and troubleshooting tips.

MERGE engineSQLTable Partitioning

0 likes · 5 min read

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 RewriteVertical Partitioning

0 likes · 15 min read

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

ITPUB

May 2, 2016 · Databases

How to Combine Multiple MyISAM Tables with MySQL’s MERGE Engine

This guide explains how to use MySQL’s MERGE storage engine to merge identically structured MyISAM tables into a single logical table, covering creation, querying, INSERT handling, adding new members, and important caveats such as avoiding primary keys.

MERGE engineSQLdatabase tables

0 likes · 5 min read

How to Combine Multiple MyISAM Tables with MySQL’s MERGE Engine