BestHub
Sign in
Tag

Sharding-JDBC

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
政采云技术
政采云技术
Nov 7, 2023 · Databases

Sharding-JDBC Startup Optimization: Analyzing and Tuning max.connections.size.per.query

This article investigates why Sharding-JDBC takes over half of the application startup time to load metadata, explains the role of the max.connections.size.per.query setting, demonstrates how adjusting it speeds up startup, and discusses the trade‑offs and potential dead‑lock risks of increasing the value.

Connection PoolDatabase ConfigurationPerformance Tuning
0 likes · 7 min read
Sharding-JDBC Startup Optimization: Analyzing and Tuning max.connections.size.per.query
JD Tech
JD Tech
Aug 25, 2023 · Databases

Reducing Sharding-JDBC Database Connection Count: Analysis and Custom Partitioning Optimization

This article examines the high connection‑count problem of Sharding-JDBC in JD Logistics, explains sharding concepts, compares four mitigation strategies, and presents a custom table‑partitioning algorithm with configuration changes that dramatically lowers MySQL instance connections while maintaining performance.

MySQLSharding-JDBCconnection pooling
0 likes · 16 min read
Reducing Sharding-JDBC Database Connection Count: Analysis and Custom Partitioning Optimization
政采云技术
政采云技术
Nov 15, 2022 · Databases

Introduction to Sharding-JDBC and ShardingSphere: Architecture, Sharding Strategies, and Quick Integration

This article introduces Sharding-JDBC and ShardingSphere, explains their history, core architecture, vertical and horizontal sharding concepts, sharding rule configuration, SQL parsing and rewriting, routing and result merging, and provides a quick‑start guide with Maven dependencies and Spring Boot configuration for Java applications.

JavaSQLSharding-JDBC
0 likes · 12 min read
Introduction to Sharding-JDBC and ShardingSphere: Architecture, Sharding Strategies, and Quick Integration
Top Architect
Top Architect
Jun 30, 2022 · Databases

Database Sharding and Partitioning Strategies with Practical Implementation

This article explains why high‑traffic systems need database sharding, compares table‑level and database‑level partitioning methods, presents concrete MySQL table‑creation scripts and Java service code, and discusses the advantages, drawbacks, and common middleware solutions such as Sharding‑JDBC and Mycat.

MySQLMycatSharding-JDBC
0 likes · 12 min read
Database Sharding and Partitioning Strategies with Practical Implementation
Code Ape Tech Column
Code Ape Tech Column
Jun 27, 2022 · Databases

Understanding XA Distributed Transactions in MySQL and Sharding-JDBC with Atomikos

This article explains the XA specification, demonstrates MySQL XA commands, and shows how Sharding-JDBC integrates XA transactions using Atomikos, including required dependencies, configuration, annotations, and testing steps, while also providing practical code examples and deployment tips.

AtomikosDatabaseMySQL
0 likes · 8 min read
Understanding XA Distributed Transactions in MySQL and Sharding-JDBC with Atomikos
Code Ape Tech Column
Code Ape Tech Column
Jun 17, 2022 · Databases

Understanding Local Transactions in Sharding-JDBC and Their Limits for Distributed Transactions

This article explains why the @Transactional annotation in Sharding-JDBC can roll back across multiple databases in some scenarios, clarifies the cases it truly supports, details the internal rollback implementation, and outlines the situations where local transactions cannot guarantee distributed consistency.

JavaLocal TransactionSharding-JDBC
0 likes · 8 min read
Understanding Local Transactions in Sharding-JDBC and Their Limits for Distributed Transactions
Top Architect
Top Architect
May 27, 2022 · Databases

Comprehensive Guide to MySQL Master‑Slave Replication, Binlog/Redo Log, and ShardingSphere‑Jdbc/Sharding‑Jdbc Read‑Write Splitting and Sharding

This article provides a step‑by‑step tutorial on configuring MySQL master‑slave replication with Docker, explains redo log and binlog fundamentals, demonstrates two‑phase commit, and shows how to implement read‑write splitting and sharding using ShardingSphere‑Jdbc and Sharding‑Jdbc with detailed code examples.

DockerMySQLReplication
0 likes · 22 min read
Comprehensive Guide to MySQL Master‑Slave Replication, Binlog/Redo Log, and ShardingSphere‑Jdbc/Sharding‑Jdbc Read‑Write Splitting and Sharding
Code Ape Tech Column
Code Ape Tech Column
May 25, 2022 · Databases

Implementing MySQL Read/Write Splitting with Sharding-JDBC Using Docker

This tutorial explains why read/write splitting is useful, shows step‑by‑step how to build a MySQL master‑slave cluster with Docker, configure the master and slave instances, and then use Sharding‑JDBC to transparently route writes to the master and reads to the slave.

DatabaseDockerMasterSlave
0 likes · 10 min read
Implementing MySQL Read/Write Splitting with Sharding-JDBC Using Docker
Code Ape Tech Column
Code Ape Tech Column
May 16, 2022 · Information Security

Data Masking with Sharding-JDBC: Concepts, Configuration, and Custom Encryptors

This article explains how Sharding-JDBC can perform data masking at the persistence layer, detailing key concepts, configuration of data sources, encryptors, and tables, demonstrating practical examples with built‑in MD5 and AES encryptors, and showing how to implement custom encryptors and query‑assisted encryption for enhanced security.

Custom EncryptorEncryptionSharding-JDBC
0 likes · 20 min read
Data Masking with Sharding-JDBC: Concepts, Configuration, and Custom Encryptors
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
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-JDBC
0 likes · 10 min read
Understanding Database Sharding: Concepts, Strategies, Mycat and Sharding-JDBC
Top Architect
Top Architect
Nov 21, 2021 · Databases

MySQL Master‑Slave Replication and Sharding‑JDBC Sharding & Read/Write Splitting Guide

This article provides a step‑by‑step tutorial on configuring MySQL master‑slave replication using Docker, explains redo log and binlog mechanisms, and demonstrates how to implement Sharding‑JDBC read/write splitting and database sharding with Spring Boot, including code examples and configuration details.

DockerMySQLRead-Write Splitting
0 likes · 22 min read
MySQL Master‑Slave Replication and Sharding‑JDBC Sharding & Read/Write Splitting Guide
Code Ape Tech Column
Code Ape Tech Column
Sep 9, 2021 · Databases

Sharding-JDBC Introduction and Practical Guide to Database Sharding with ShardingSphere

This article introduces Sharding-JDBC (now ShardingSphere), explains core sharding concepts such as shards, data nodes, logical and physical tables, sharding keys, algorithms and strategies, shows how it extends JDBC, and provides a step‑by‑step Spring Boot + MyBatis‑Plus example for building a sharded database application.

MyBatis-PlusSharding-JDBCShardingSphere
0 likes · 30 min read
Sharding-JDBC Introduction and Practical Guide to Database Sharding with ShardingSphere
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jun 29, 2021 · Databases

Quick Integration of ShardingSphere for Database Sharding in Spring Boot

This article explains how to use Spring Boot to quickly integrate ShardingSphere for database sharding, covering the background of massive data storage challenges, the advantages of ShardingSphere, step‑by‑step project setup, configuration of data sources and sharding strategies, and a complete test example.

Inline Sharding StrategyMyBatisSharding-JDBC
0 likes · 13 min read
Quick Integration of ShardingSphere for Database Sharding in Spring Boot
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
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 28, 2020 · Databases

Read‑Write Splitting in Database Applications: Implementation Methods, Data Lag, and Routing Strategies

This article explains the concept of read‑write splitting for databases, compares client‑side and proxy implementations, discusses data lag and forced routing techniques, and provides code examples and custom load‑balancing algorithms using Sharding‑JDBC and Spring.

Database ScalingMaster‑SlaveRead-Write Splitting
0 likes · 9 min read
Read‑Write Splitting in Database Applications: Implementation Methods, Data Lag, and Routing Strategies
Java Architect Essentials
Java Architect Essentials
Oct 12, 2020 · Databases

Sharding-JDBC Demo with Spring Boot: Database and Table Sharding Guide

This article provides a step‑by‑step tutorial on using Sharding-JDBC with Spring Boot to implement horizontal database and table sharding across multiple MySQL instances, including project setup, Maven dependencies, entity and controller code, sharding configuration, and testing via Postman.

JavaMyBatis-PlusMySQL
0 likes · 12 min read
Sharding-JDBC Demo with Spring Boot: Database and Table Sharding Guide
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 28, 2020 · Databases

Understanding Master/Slave Read‑Write Splitting and Data Consistency with Sharding‑JDBC

This article explains the data‑delay problem inherent in asynchronous MySQL master‑slave replication, demonstrates how Sharding‑JDBC provides read‑write splitting and forced‑master routing via HintManager, and offers configuration and code examples as well as alternative async‑query strategies for real‑time consistency.

HintManagerJavaMaster‑Slave
0 likes · 8 min read
Understanding Master/Slave Read‑Write Splitting and Data Consistency with Sharding‑JDBC