BestHub
Sign in
Tag

MERGE Engine

0 views collected around this technical thread.

vivo Internet Technology
vivo Internet Technology
Mar 6, 2024 · Databases

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
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 EngineMySQLSQL
0 likes · 6 min read
MySQL Table Splitting and Pagination Using the MERGE Engine
Selected Java Interview Questions
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 EngineMySQLSQL
0 likes · 5 min read
MySQL Table Splitting and Pagination Using the MERGE Engine
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