BestHub
Sign in
Tagged articles

ShardingSphere

98 articles · Page 1 of 1
Architect's Tech Stack
Architect's Tech Stack
Sep 26, 2026 · Databases

Why Database Sharding Is No Longer the Default Choice

The article argues that manual database sharding is shifting from a default scaling strategy to a fallback option, as native distributed databases like TiDB and OceanBase internalize sharding, routing, and distributed transactions, reducing application complexity, though they introduce higher latency, operational overhead, and cost, making single-node MySQL with proper indexing preferable for smaller datasets.

OceanBaseShardingSphereTiDB
0 likes · 8 min read
Why Database Sharding Is No Longer the Default Choice
samdeepthink
samdeepthink
Aug 18, 2026 · Databases

When a Single Database Hits Its Limits: Sharding Principles and Migration Path

The article explains why sharding should be a last‑resort scaling option, describes vertical and horizontal partitioning, compares hash, range and directory sharding schemes, discusses hotspots, routing, data colocation, migration steps and tool choices, and warns about the operational complexity involved.

Data ConsistencyDatabase ScalingHorizontal Partitioning
0 likes · 16 min read
When a Single Database Hits Its Limits: Sharding Principles and Migration Path
Xiaolin Talks Programming
Xiaolin Talks Programming
Aug 7, 2026 · Backend Development

Spring Boot ShardingSphere Integration: Sharding Strategies, Global IDs & Cross-Shard Query Pitfalls

A production-ready guide to integrating Spring Boot 3.x with ShardingSphere 5.5.0, covering sharding algorithms (hash, range, time-based), global ID generation (Snowflake, segment mode), read-write splitting consistency traps, cross-shard query optimization, connection pool tuning, and a deployment checklist.

Cross-Shard QueriesGlobal ID GenerationRead-Write Splitting
0 likes · 18 min read
Spring Boot ShardingSphere Integration: Sharding Strategies, Global IDs & Cross-Shard Query Pitfalls
Java Architect Handbook
Java Architect Handbook
Jul 24, 2026 · Databases

What Are Database Sharding, Table Sharding, and Combined Sharding? – Xianyu Interview Guide

The article explains the differences between database sharding, table sharding, and combined sharding, outlines interview expectations, details vertical and horizontal splitting strategies, discusses when to apply each technique, and reviews practical tools such as ShardingSphere and MyCat for Java projects.

BackendInterview PreparationMySQL
0 likes · 10 min read
What Are Database Sharding, Table Sharding, and Combined Sharding? – Xianyu Interview Guide
Linyb Geek Road
Linyb Geek Road
Jun 30, 2026 · Databases

Implementing Efficient Pagination Across Sharded Databases

The article analyzes why traditional LIMIT/OFFSET pagination fails when data is split across multiple databases, presents a global query approach with its trade‑offs, and proposes an optimized "no‑skip" method plus practical tips using ShardingSphere and Elasticsearch.

ElasticsearchShardingSpheredatabase
0 likes · 7 min read
Implementing Efficient Pagination Across Sharded Databases
Java Tech Workshop
Java Tech Workshop
Jun 8, 2026 · Databases

Advanced SpringBoot Read‑Write Splitting: Master‑Slave Switching and Automatic Failover

In high‑concurrency internet architectures, a MySQL master‑slave setup with read‑write splitting is the baseline for high availability, but static routing suffers from node failures and lag; this article explains how ShardingSphere provides health checks, auto‑failover, load‑balancing, and degradation to achieve resilient read‑write separation.

MySQLRead-Write SplittingShardingSphere
0 likes · 14 min read
Advanced SpringBoot Read‑Write Splitting: Master‑Slave Switching and Automatic Failover
Java Tech Workshop
Java Tech Workshop
Jun 6, 2026 · Backend Development

Advanced SpringBoot Database Sharding with ShardingSphere

This article explains why single‑database, single‑table architectures hit performance limits at millions of rows, introduces ShardingSphere as the preferred zero‑deployment sharding solution for SpringBoot, and walks through vertical and horizontal splitting, configuration, custom algorithms, read/write splitting, and distributed transactions with practical code examples.

Custom Sharding AlgorithmReadWrite SplittingSeata
0 likes · 14 min read
Advanced SpringBoot Database Sharding with ShardingSphere
Cloud Architecture
Cloud Architecture
Apr 7, 2026 · Databases

MySQL Read‑Write Splitting: From Replication Basics to Production‑Ready Architecture

The article explains why simple SQL routing is insufficient for MySQL read‑write separation, details replication mechanisms, consistency challenges, and presents a comprehensive upgrade path—including static, dynamic, middleware, and hybrid routing strategies, configuration guidelines, monitoring, and high‑availability practices—to build a production‑grade, high‑concurrency architecture.

High ConcurrencyMySQLRead-Write Splitting
0 likes · 44 min read
MySQL Read‑Write Splitting: From Replication Basics to Production‑Ready Architecture
Senior Xiao Ying
Senior Xiao Ying
Feb 26, 2026 · Databases

Vertical vs Horizontal Sharding in MySQL: Strategy Selection and Middleware Guide

The article explains vertical and horizontal sharding concepts, compares their advantages and drawbacks, evaluates popular sharding middleware such as ShardingSphere, details distributed ID generation with Snowflake, offers cross‑database query solutions, and provides practical guidance on when and how to apply sharding in MySQL.

Cross-Database QueriesHorizontal ShardingMySQL
0 likes · 13 min read
Vertical vs Horizontal Sharding in MySQL: Strategy Selection and Middleware Guide
Tech Freedom Circle
Tech Freedom Circle
Nov 28, 2025 · Databases

How to Achieve MySQL Sub‑Second Scaling for 100M‑10B Rows (Interview Scenario)

The article analyzes a JD interview question on scaling a MySQL order table from 100 million to billions of rows, detailing four practical expansion strategies—stop‑service migration, double‑write migration, ShardingSphere middleware, and dual‑VIP routing—each with step‑by‑step procedures, code samples, risk assessments, and validation methods to enable near‑instant capacity growth without service interruption.

Database ScalingHorizontal ShardingMySQL
0 likes · 42 min read
How to Achieve MySQL Sub‑Second Scaling for 100M‑10B Rows (Interview Scenario)
Selected Java Interview Questions
Selected Java Interview Questions
Nov 6, 2025 · Databases

Master Spring Boot ShardingSphere: Step-by-Step MySQL Sharding Guide

This article walks through building a Spring Boot project with ShardingSphere‑JDBC, covering Maven dependencies, YAML configuration, database setup, sharding rules, distributed ID generation, binding tables, and testing, providing a complete, hands‑on guide to implementing MySQL horizontal partitioning in a real‑world application.

MySQLShardingSphereSpring Boot
0 likes · 18 min read
Master Spring Boot ShardingSphere: Step-by-Step MySQL Sharding Guide
Cognitive Technology Team
Cognitive Technology Team
Sep 21, 2025 · Databases

How Druid’s PreparedStatement Cache Breaks ShardingSphere Routing and Fixes

An unexpected data loss issue in a ShardingSphere‑JDBC setup was traced to Druid’s poolPreparedStatements cache, which reuses PreparedStatement objects across different shards, bypassing dynamic routing; disabling the cache or switching to HikariCP restores correct sharding behavior with minimal performance impact.

DruidPreparedStatementShardingSphere
0 likes · 12 min read
How Druid’s PreparedStatement Cache Breaks ShardingSphere Routing and Fixes
Architect
Architect
Aug 17, 2025 · Databases

Mastering Database Sharding in Spring Boot: A Complete Guide with ShardingSphere

This comprehensive tutorial explains database sharding concepts, types, strategies, and implementation in Spring Boot using ShardingSphere, covering configuration, entity and repository code, service and controller layers, integration with pagination, Swagger, ActiveMQ, security, batch processing, FreeMarker, WebSockets, AOP, performance testing, FAQs, real‑world cases, and future trends.

JavaShardingSphereSpring Boot
0 likes · 32 min read
Mastering Database Sharding in Spring Boot: A Complete Guide with ShardingSphere
Top Architect
Top Architect
Jul 24, 2025 · Databases

How to Efficiently Shard Billion‑Row Tables with ShardingSphere and Spring Boot

This article walks through the end‑to‑end design, configuration, and implementation of splitting massive loan and repayment tables into 50 sharded MySQL tables using ShardingSphere, Spring Boot, and a custom suffix algorithm, while covering data migration, DBA coordination, dynamic switches, and scheduled consistency checks.

MySQLShardingSphereSpring Boot
0 likes · 19 min read
How to Efficiently Shard Billion‑Row Tables with ShardingSphere and Spring Boot
Top Architect
Top Architect
Jun 27, 2025 · Databases

How to Implement High‑Performance Database Sharding with ShardingSphere and SpringBoot

This article walks through the complete process of designing, configuring, and coding a sharding solution for loan and repayment tables—including database basics, historical data migration, backend query refactoring, a three‑write strategy, scheduled consistency checks, and full SpringBoot/ShardingSphere implementation details.

MyBatisPerformanceShardingSphere
0 likes · 20 min read
How to Implement High‑Performance Database Sharding with ShardingSphere and SpringBoot
Java Captain
Java Captain
May 14, 2025 · Databases

Guide to Setting Up ShardingSphere with Docker for Database Sharding, Read‑Write Splitting, and SpringBoot Integration

This guide demonstrates how to set up Docker‑based MySQL instances, configure ShardingSphere‑Proxy for database sharding and read‑write splitting, and integrate ShardingSphere‑JDBC with SpringBoot 2.x using YAML configurations and Maven dependencies, providing complete code snippets and default connection details.

DockerMySQLRead-Write Splitting
0 likes · 11 min read
Guide to Setting Up ShardingSphere with Docker for Database Sharding, Read‑Write Splitting, and SpringBoot Integration
Selected Java Interview Questions
Selected Java Interview Questions
Feb 14, 2025 · Databases

ShardingSphere Overview and Spring Boot Integration for Database Sharding, Proxy, and Sidecar

This article introduces ShardingSphere's three components—Sharding-JDBC, Sharding-Proxy, and the upcoming Sharding-Sidecar—explains why sharding is needed for relational databases, demonstrates horizontal data sharding concepts, and provides a complete Spring Boot example with configuration, code, and asynchronous batch insertion.

Async ProcessingMySQLShardingSphere
0 likes · 17 min read
ShardingSphere Overview and Spring Boot Integration for Database Sharding, Proxy, and Sidecar
Su San Talks Tech
Su San Talks Tech
Feb 13, 2025 · Databases

Master ShardingSphere: 12 Sharding Strategies & Algorithms Explained

This comprehensive guide walks through ShardingSphere's core sharding strategies and the twelve built‑in sharding algorithms, showing how to configure each with YAML, illustrating their behavior with code examples, and highlighting practical tips for choosing the right approach in real‑world database partitioning scenarios.

Sharding AlgorithmsShardingSphereSpring Boot
0 likes · 29 min read
Master ShardingSphere: 12 Sharding Strategies & Algorithms Explained
Top Architect
Top Architect
Nov 12, 2024 · Databases

Design and Implementation of Table Sharding for Loan Repayment Applications Using ShardingSphere and Spring Boot

This article describes how a senior architect designed, configured, and implemented a 50‑table sharding solution for loan and repayment request data using ShardingSphere, Spring Boot 3, MySQL, and custom synchronization scripts, while also addressing historical data migration, backend query changes, and operational safeguards.

MySQLShardingSphereSpringBoot
0 likes · 23 min read
Design and Implementation of Table Sharding for Loan Repayment Applications Using ShardingSphere and Spring Boot
Top Architect
Top Architect
Nov 7, 2024 · Databases

Database Sharding Design and Implementation for Loan & Repayment Tables Using ShardingSphere and Spring Boot

This article describes how a senior architect designed and implemented a sharding solution for loan and repayment tables, covering database design, table naming, sharding algorithms, historical data migration, three‑write synchronization, dynamic switches, and the necessary Spring Boot, MyBatis‑Plus, and ShardingSphere configurations with code examples.

DataMigrationMySQLShardingSphere
0 likes · 22 min read
Database Sharding Design and Implementation for Loan & Repayment Tables Using ShardingSphere and Spring Boot
IT Services Circle
IT Services Circle
Oct 25, 2024 · Databases

Database Management Challenges in the Cloud Era and How Apache ShardingSphere Addresses Them

The article outlines the growing difficulties of managing diverse databases in cloud-native environments, introduces Apache ShardingSphere as a comprehensive open‑source solution with three core capabilities—connectivity, enhancement, and pluggability—and guides readers through a three‑step learning path from fundamentals to deployment and testing.

Database ManagementDatabase MiddlewareSQL
0 likes · 9 min read
Database Management Challenges in the Cloud Era and How Apache ShardingSphere Addresses Them
Top Architect
Top Architect
Oct 4, 2024 · Databases

Design and Implementation of Table Sharding for Loan and Repayment Applications Using ShardingSphere and Spring Boot

The article describes a year‑long development experience where a senior architect designs, plans, and implements a sharding solution for loan and repayment tables using ShardingSphere, Spring Boot 3, MySQL, and custom synchronization code to migrate billions of rows while ensuring data consistency and operational continuity.

JavaMySQLShardingSphere
0 likes · 25 min read
Design and Implementation of Table Sharding for Loan and Repayment Applications Using ShardingSphere and Spring Boot
Top Architect
Top Architect
Aug 18, 2024 · Databases

Design and Implementation of Database Table Partitioning for Loan and Repayment Systems

This article details the design, planning, and step‑by‑step implementation of a database table‑partitioning solution for loan and repayment request tables, covering schema decisions, sharding strategy, historical data migration, dynamic synchronization, code examples with ShardingSphere, SpringBoot, and operational considerations for seamless migration.

ShardingSphereSpringBootdata migration
0 likes · 18 min read
Design and Implementation of Database Table Partitioning for Loan and Repayment Systems
Architect
Architect
Jul 17, 2024 · Databases

Design and Implementation of Table Sharding for Cash Repayment System Using ShardingSphere and SpringBoot

The article describes how a one‑year‑old loan/repayment service was refactored by introducing a 50‑table sharding scheme with ShardingSphere, detailing the design decisions, historical data migration, code changes, configuration files, pitfalls, and runtime synchronization strategies to achieve efficient query performance on billions of rows.

MySQLShardingSpherebackend development
0 likes · 23 min read
Design and Implementation of Table Sharding for Cash Repayment System Using ShardingSphere and SpringBoot
Selected Java Interview Questions
Selected Java Interview Questions
Jun 25, 2024 · Databases

Design and Implementation of Table Sharding for Cash Repayment Applications Using ShardingSphere and Spring Boot

This article details the end‑to‑end design, configuration, and code implementation of a 50‑table sharding solution for cash repayment and loan application data, covering database schema planning, historical data migration, backend query adaptation, dynamic switches, scheduled consistency checks, and practical pitfalls encountered with Spring Boot 3 and ShardingSphere.

JavaMySQLShardingSphere
0 likes · 22 min read
Design and Implementation of Table Sharding for Cash Repayment Applications Using ShardingSphere and Spring Boot
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
May 27, 2024 · Databases

Database Sharding (分库分表): Concepts, Strategies, and Implementation with ShardingSphere

This article explains database sharding concepts, reasons for using it, various sharding strategies, and demonstrates implementation with ShardingSphere, including configuration and Java code examples, while also offering additional resources for advanced architecture and interview preparation.

PerformanceShardingSpherescalability
0 likes · 6 min read
Database Sharding (分库分表): Concepts, Strategies, and Implementation with ShardingSphere
JavaEdge
JavaEdge
May 21, 2024 · Backend Development

How to Integrate ShardingSphere with Spring and Spring Boot

This guide explains the two integration mechanisms ShardingSphere provides for Spring—namespace‑based XML schema extension and custom starter for Spring Boot—detailing the required classes, configuration files, bean definitions, and annotations to enable sharding, read‑write splitting, and encryption in a Java backend.

AutoConfigurationJava backendShardingSphere
0 likes · 14 min read
How to Integrate ShardingSphere with Spring and Spring Boot
Su San Talks Tech
Su San Talks Tech
Apr 19, 2024 · Backend Development

Distributed Primary Keys in ShardingSphere: Strategies & Custom Implementations

This article explores why distributed primary keys are essential for sharding, compares built‑in ShardingSphere ID generation strategies such as UUID, NanoID, Snowflake, CosId and custom algorithms, details their configuration, performance trade‑offs, and provides code examples for implementing and registering custom key generators.

ShardingSphereSnowflakeUUID
0 likes · 17 min read
Distributed Primary Keys in ShardingSphere: Strategies & Custom Implementations
Architect
Architect
Mar 29, 2024 · Databases

Understanding Database Sharding and Partitioning with ShardingSphere

This article explains the fundamentals of database sharding and partitioning, why they are needed for massive data volumes, various vertical and horizontal splitting strategies, routing algorithms, client vs. proxy deployment models, and the practical challenges and solutions when using ShardingSphere 5.x.

MySQLPartitioningShardingSphere
0 likes · 17 min read
Understanding Database Sharding and Partitioning with ShardingSphere
Su San Talks Tech
Su San Talks Tech
Mar 29, 2024 · Databases

Master ShardingSphere: Hands‑On Sharding‑JDBC Sharding & Partitioning Guide

This article provides a comprehensive, step‑by‑step tutorial on using Apache ShardingSphere and Sharding‑JDBC to implement horizontal, vertical, and broadcast sharding, covering core concepts, sharding strategies, configuration examples, and practical code snippets for real‑world database partitioning.

Broadcast TableHorizontal PartitioningRead-Write Splitting
0 likes · 22 min read
Master ShardingSphere: Hands‑On Sharding‑JDBC Sharding & Partitioning Guide
The Dominant Programmer
The Dominant Programmer
Sep 21, 2023 · Backend Development

Essential SpringBoot Tricks: Flyway, JetCache, Netty, and More (Part 2)

This article compiles a set of practical SpringBoot techniques, including Flyway-based SQL version control, JetCache declarative caching, Netty WebSocket service customization, jasypt configuration encryption, ShardingSphere data masking, Jackson response desensitization, read‑write splitting, idempotent request handling, MockMvc testing, and Prometheus‑Grafana monitoring.

FlywayJetCacheNetty
0 likes · 3 min read
Essential SpringBoot Tricks: Flyway, JetCache, Netty, and More (Part 2)
JD Cloud Developers
JD Cloud Developers
Jul 27, 2023 · Databases

Scaling MySQL at JD Logistics with ShardingSphere: Refactoring Sharding-JDBC

This article examines how JD Logistics tackled MySQL connection limits by redesigning its sharding strategy using ShardingSphere's Sharding-JDBC, detailing the background, concepts of database and table sharding, analysis of bottlenecks, and step‑by‑step refactoring to reduce connections and improve scalability.

MySQLSharding-JDBCShardingSphere
0 likes · 16 min read
Scaling MySQL at JD Logistics with ShardingSphere: Refactoring Sharding-JDBC
Su San Talks Tech
Su San Talks Tech
Jul 6, 2023 · Databases

Master ShardingSphere: Quick Sharding with Spring Boot and YML

This tutorial walks through the fundamentals and architecture of ShardingSphere, compares it with other sharding tools, and demonstrates how to implement database sharding in a Spring Boot project using both YML configuration and pure Java code, including detailed code snippets and deployment tips.

JavaShardingSphereSpring Boot
0 likes · 22 min read
Master ShardingSphere: Quick Sharding with Spring Boot and YML
Wukong Talks Architecture
Wukong Talks Architecture
Jun 20, 2023 · Databases

Evolution of JD Baitiao’s Data Architecture: From MySQL to Apache ShardingSphere

This article chronicles JD Baitiao’s journey from early MySQL and NoSQL solutions through DBRep to the adoption of Apache ShardingSphere, highlighting the technical motivations, decoupling strategies, performance comparisons, and the broader Database Plus vision for scalable, stable financial‑grade data architectures.

JD BaitiaoShardingSpherearchitecture
0 likes · 14 min read
Evolution of JD Baitiao’s Data Architecture: From MySQL to Apache ShardingSphere
Top Architect
Top Architect
Jan 12, 2023 · Databases

MySQL Master‑Slave Replication, Binlog/Redo Log Basics, and Sharding‑JDBC Read‑Write Splitting & Sharding Implementation

This article provides a comprehensive tutorial on configuring MySQL master‑slave replication with Docker, explains the roles of binlog and redo log, describes two‑phase commit, and demonstrates how to use Sharding‑JDBC (ShardingSphere) for read‑write splitting and horizontal sharding in a Spring Boot application, complete with configuration files and code examples.

JavaMySQLReplication
0 likes · 24 min read
MySQL Master‑Slave Replication, Binlog/Redo Log Basics, and Sharding‑JDBC Read‑Write Splitting & Sharding Implementation
iQIYI Technical Product Team
iQIYI Technical Product Team
Dec 16, 2022 · Databases

Database Mesh 2.0 and Pisanix: Cloud‑Native Database Governance at iQIYI

iQIYI adopts SphereEx’s Database Mesh 2.0 by extending ShardingSphere‑JDBC and integrating the cloud‑native Pisanix proxy, creating a unified, encrypted configuration center that enables dynamic sharding, load‑balancing, read‑write separation, hot‑updates and observability, dramatically simplifying database governance and cloud migration.

Database MeshMySQLPisanix
0 likes · 14 min read
Database Mesh 2.0 and Pisanix: Cloud‑Native Database Governance at iQIYI
ITPUB
ITPUB
Dec 9, 2022 · Databases

Mastering Sharding: When and How to Split Databases and Tables with ShardingSphere

This article explains the fundamentals of database sharding, why and when to apply it, various vertical and horizontal splitting strategies, routing algorithms, common pitfalls such as pagination and distributed transactions, and compares client‑side and proxy‑based ShardingSphere deployment patterns.

MySQLShardingSpheredatabase partitioning
0 likes · 19 min read
Mastering Sharding: When and How to Split Databases and Tables with ShardingSphere
政采云技术
政采云技术
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
Alibaba Cloud Native
Alibaba Cloud Native
Nov 10, 2022 · Cloud Native

How OpenSergo Unifies Microservice and Database Governance Across Languages

The article explains why microservice governance is essential, introduces the OpenSergo project and its collaboration with ShardingSphere to create a unified, language‑agnostic standard for database governance, and provides concrete abstractions and YAML examples for implementing traffic, fault‑tolerance, and security policies.

Database GovernanceOpenSergoShardingSphere
0 likes · 15 min read
How OpenSergo Unifies Microservice and Database Governance Across Languages
IT Services Circle
IT Services Circle
Oct 5, 2022 · Databases

Debugging a NullPointerException During ShardingSphere Startup Caused by TiDB View Metadata

The article details a NullPointerException that occurs when ShardingSphere starts, explains how null values in TiDB‑generated view metadata trigger the error, describes the step‑by‑step investigation and reproduction using TiUP, and discusses several possible fixes and a call for community contributions.

JavaNullPointerExceptionShardingSphere
0 likes · 4 min read
Debugging a NullPointerException During ShardingSphere Startup Caused by TiDB View Metadata
vivo Internet Technology
vivo Internet Technology
Sep 7, 2022 · Backend Development

Design and Implementation of Pickup Code System for SaaS E-commerce Platform

The article details the design and implementation of a pickup‑code system for SaaS e‑commerce platforms, covering simple single‑table approaches and a globally unique 8‑digit code scheme that embeds database and table identifiers, with strategies for sharding, conflict resolution, dynamic routing, and extensible tenant‑specific configuration.

SaaS-platformShardingSpherecode generation
0 likes · 11 min read
Design and Implementation of Pickup Code System for SaaS E-commerce Platform
Selected Java Interview Questions
Selected Java Interview Questions
Aug 15, 2022 · Backend Development

Guide to Setting Up MySQL Master‑Slave Replication with MyBatisPlus, ShardingSphereJDBC and Spring Boot for Read‑Write Splitting

This tutorial walks through the complete process of configuring MySQL master‑slave replication, preparing Docker containers, configuring MyBatisPlus and ShardingSphereJDBC for read‑write splitting, building a Spring Boot project with the necessary dependencies, generating code, and testing the setup with sample controller endpoints.

DockerMaster-Slave ReplicationRead-Write Splitting
0 likes · 15 min read
Guide to Setting Up MySQL Master‑Slave Replication with MyBatisPlus, ShardingSphereJDBC and Spring Boot for Read‑Write Splitting
Architecture Digest
Architecture Digest
Jul 29, 2022 · Databases

Guide to Setting Up MySQL Master‑Slave Replication with MyBatis‑Plus, ShardingSphereJDBC and Spring Boot for Read‑Write Splitting

This tutorial explains how to configure MySQL master‑slave replication using Docker, set up read‑write splitting with ShardingSphereJDBC, integrate MyBatis‑Plus, and build a Spring Boot application that demonstrates write operations on the master and read operations on the slave.

Database ReplicationMyBatis-PlusMySQL
0 likes · 16 min read
Guide to Setting Up MySQL Master‑Slave Replication with MyBatis‑Plus, ShardingSphereJDBC and Spring Boot for Read‑Write Splitting
DeWu Technology
DeWu Technology
Jun 22, 2022 · Databases

Rainbow Bridge: A ShardingSphere‑Based Database Middleware for Scalability and Reliability

To support the rapidly growing DeWu App, the team created Rainbow Bridge—a ShardingSphere‑based middleware that unifies horizontal sharding, read‑write separation, shadow‑DB routing, rate limiting, and active‑active traffic correction, while adding a graphical console, stability enhancements, fine‑grained observability, hybrid JDBC/Proxy switching, and ongoing open‑source contributions.

Database MiddlewarePerformance OptimizationRead-Write Splitting
0 likes · 18 min read
Rainbow Bridge: A ShardingSphere‑Based Database Middleware for Scalability and Reliability
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.

MySQLShardingSphere
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
Top Architect
Top Architect
May 18, 2022 · Databases

Evolution of JD Baitiao Backend Architecture: From MySQL to ShardingSphere

This article chronicles the architectural evolution of JD Baitiao’s backend—from early MySQL monoliths through Solr‑HBase, MongoDB, and DBRep—to the adoption of Apache ShardingSphere, highlighting the motivations, technical trade‑offs, decoupling strategies, and performance outcomes for a high‑throughput financial service.

Data PartitioningJD BaitiaoMySQL
0 likes · 15 min read
Evolution of JD Baitiao Backend Architecture: From MySQL to ShardingSphere
Top Architect
Top Architect
May 3, 2022 · Databases

ShardingSphere-JDBC Overview, MySQL Master‑Slave Replication Setup, Binlog & Redo Log Review, and Sharding‑JDBC Read/Write Splitting & Sharding Implementation

This article provides a comprehensive tutorial on using ShardingSphere‑JDBC, configuring MySQL master‑slave replication with Docker, explaining binlog and redo‑log mechanisms, demonstrating two‑phase commit, and detailing Sharding‑JDBC read/write splitting and sharding configurations with code examples.

JDBCMySQLShardingSphere
0 likes · 23 min read
ShardingSphere-JDBC Overview, MySQL Master‑Slave Replication Setup, Binlog & Redo Log Review, and Sharding‑JDBC Read/Write Splitting & Sharding Implementation
Architect's Journey
Architect's Journey
Feb 9, 2022 · Databases

Choosing the Right Database Architecture: A Practical Guide

The article walks through the challenges of growing data volumes, compares master‑slave, vertical, horizontal, and sharding‑plus‑partitioning architectures, explains their pros and cons, and provides concrete guidance on selecting and implementing a suitable database solution, including middleware options and real‑world case studies.

ShardingSpheredatabase architecturedistributed transactions
0 likes · 21 min read
Choosing the Right Database Architecture: A Practical Guide
Top Architect
Top Architect
Oct 28, 2021 · Databases

ShardingSphere-JDBC MySQL Master‑Slave Replication, Redo Log, Binlog and Sharding Implementation Guide

This article provides a step‑by‑step tutorial on configuring MySQL master‑slave replication with Docker, explains redo log and binlog mechanisms, demonstrates two‑phase commit, and shows how to use ShardingSphere‑Jdbc for read/write splitting and sharding with detailed Spring Boot examples and code snippets.

JavaMySQLReplication
0 likes · 21 min read
ShardingSphere-JDBC MySQL Master‑Slave Replication, Redo Log, Binlog and Sharding Implementation Guide
Programmer DD
Programmer DD
Oct 17, 2021 · Databases

How JD Baitiao Scaled to Billions with Apache ShardingSphere

This article chronicles JD Baitiao's data‑architecture evolution from Solr + HBase to MongoDB and finally to Apache ShardingSphere, highlighting the challenges of massive data growth, the need for decoupling, and the performance, scalability, and operational benefits achieved by adopting ShardingSphere.

ApacheJD BaitiaoShardingSphere
0 likes · 10 min read
How JD Baitiao Scaled to Billions with Apache ShardingSphere
Top Architect
Top Architect
Oct 2, 2021 · Databases

ShardingSphere-JDBC Tutorial: MySQL Master‑Slave Replication, Redo/Binlog, and Sharding Configuration

This article provides a comprehensive guide on using ShardingSphere-JDBC for read‑write splitting, configuring MySQL master‑slave replication with Docker, explaining redo log and binlog mechanisms, demonstrating two‑phase commit, and showing how to implement database sharding and distributed primary keys in a Spring Boot application.

JDBCMaster-Slave ReplicationMySQL
0 likes · 22 min read
ShardingSphere-JDBC Tutorial: MySQL Master‑Slave Replication, Redo/Binlog, and Sharding Configuration
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
Programmer DD
Programmer DD
Aug 24, 2021 · Databases

Seamless Data Encryption with ShardingSphere: A Spring Guide

This article explains why encrypting sensitive customer data in databases is essential, outlines common pain points, and demonstrates how Apache ShardingSphere’s data‑desensitization module can be quickly configured in Spring (XML and Boot) to provide transparent AES encryption and decryption without altering business code.

AESDatabase SecurityJava
0 likes · 8 min read
Seamless Data Encryption with ShardingSphere: A Spring Guide
DeWu Technology
DeWu Technology
Aug 13, 2021 · Databases

Smooth Migration from Client-Side to Proxy-Side Sharding in Database Architecture

The article explains how to transition from client‑side sharding with Sharding‑JDBC to proxy‑side sharding using Rainbow Bridge DAL by adding new, switchable data sources, employing AbstractRoutingDataSource and configuration flags for gradual migration, while addressing read‑write separation, unsupported SQL functions, and ensuring backward compatibility.

Dynamic Data SourceMigration StrategyRainbow Bridge DAL
0 likes · 7 min read
Smooth Migration from Client-Side to Proxy-Side Sharding in Database Architecture
Top Architect
Top Architect
Aug 12, 2021 · Databases

Comprehensive Guide to ShardingSphere-Jdbc, MySQL Master‑Slave Replication, and Sharding Strategies

This article provides a detailed walkthrough of ShardingSphere‑Jdbc read/write splitting, MySQL master‑slave replication setup with Docker, the differences between redo log and binlog, two‑phase commit, and practical sharding configurations using inline strategies and distributed primary keys in a Spring Boot project.

MySQL replicationRead-Write SplittingShardingSphere
0 likes · 23 min read
Comprehensive Guide to ShardingSphere-Jdbc, MySQL Master‑Slave Replication, and Sharding Strategies
Architect's Tech Stack
Architect's Tech Stack
Jul 29, 2021 · Databases

Quick Start Guide to Data Encryption (Masking) with Apache ShardingSphere in Spring and Spring Boot

This article explains how to use Apache ShardingSphere's encryption module to transparently store and query sensitive customer data such as ID numbers and bank cards by configuring encryption rules in Spring or Spring Boot, eliminating manual SQL encryption and simplifying compliance for legacy systems.

Database SecurityJavaSQL Masking
0 likes · 9 min read
Quick Start Guide to Data Encryption (Masking) with Apache ShardingSphere in Spring and Spring Boot
Programmer DD
Programmer DD
Jul 29, 2021 · Databases

Secure Sensitive Data in ShardingSphere: Quick Start Guide for Spring

This tutorial explains why encrypting sensitive fields like ID numbers and bank cards is required, outlines common pain points, and shows how to configure ShardingSphere's data‑desensitization module using Spring namespace or Spring Boot with full code examples and configuration files.

Database SecurityJavaShardingSphere
0 likes · 8 min read
Secure Sensitive Data in ShardingSphere: Quick Start Guide for Spring
Top Architect
Top Architect
Jul 27, 2021 · Databases

ShardingSphere-Jdbc Overview, MySQL Master‑Slave Replication, Binlog & Redo Log, and Sharding Implementation

This article introduces ShardingSphere‑Jdbc as a lightweight Java JDBC framework, details step‑by‑step Docker‑based MySQL master‑slave replication configuration, reviews redo log and binlog mechanisms, explains two‑phase commit, and demonstrates read‑write splitting and sharding strategies with Spring Boot examples.

JDBCMaster-Slave ReplicationMySQL
0 likes · 28 min read
ShardingSphere-Jdbc Overview, MySQL Master‑Slave Replication, Binlog & Redo Log, and Sharding Implementation
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
JD Cloud Developers
JD Cloud Developers
Jan 29, 2021 · Databases

How Apache ShardingSphere Evolved into a Distributed Database Middleware

An in‑depth interview with Zhang Liang, VP and founder of Apache ShardingSphere, explores the project’s three development phases, its graduation to a top‑level Apache project, the three‑layer plug‑in architecture, and practical lessons for building sustainable open‑source communities and enterprise‑grade database middleware.

ApacheShardingSpherecommunity
0 likes · 13 min read
How Apache ShardingSphere Evolved into a Distributed Database Middleware
JD Tech Talk
JD Tech Talk
Dec 16, 2020 · Databases

Understanding SQL Parser and Its Implementation in Apache ShardingSphere

This article explains the fundamentals of SQL parsing, covering lexer and parser mechanisms, context‑free grammar concepts, LL(1) and LR(1) parsing techniques, and demonstrates how Apache ShardingSphere implements a flexible, multi‑dialect SQL parser with features such as formatting, parameterization, and extensibility.

ASTParserSQL
0 likes · 11 min read
Understanding SQL Parser and Its Implementation in Apache ShardingSphere
Code Ape Tech Column
Code Ape Tech Column
Dec 11, 2020 · Databases

ShardingSphere Overview, Core Concepts, and Horizontal Sharding Example with Spring Boot

This article introduces Apache ShardingSphere's architecture—including ShardingSphere‑JDBC, ShardingSphere‑Proxy, and the upcoming Sidecar—explains data sharding principles, read/write splitting, and provides a complete Spring Boot example with Maven dependencies, Java source code, and configuration files for horizontal database partitioning.

JDBCRead-Write SplittingShardingSphere
0 likes · 19 min read
ShardingSphere Overview, Core Concepts, and Horizontal Sharding Example with Spring Boot
Programmer DD
Programmer DD
Nov 28, 2020 · Backend Development

Deep Dive into ShardingSphere XA Distributed Transaction Support and Atomikos Integration

This article provides a comprehensive technical analysis of ShardingSphere's XA distributed transaction capabilities, covering the CAP theory, X/Open DTP model, MySQL XA support, JTA mapping, Atomikos initialization, transaction lifecycle (begin, getConnection, commit, rollback), and the recovery mechanism with detailed code snippets and diagrams.

AtomikosJTAJava
0 likes · 34 min read
Deep Dive into ShardingSphere XA Distributed Transaction Support and Atomikos Integration
ITPUB
ITPUB
May 18, 2020 · Information Security

How Apache ShardingSphere Enables Transparent Data Masking with Encrypt‑JDBC

This article explains how Apache ShardingSphere’s Encrypt‑JDBC component provides a transparent, low‑cost data‑masking solution for both new and existing applications, detailing the architecture, configuration steps, migration process, limitations, and practical use‑case scenarios.

DataMaskingDatabaseSecurityEncryptJDBC
0 likes · 20 min read
How Apache ShardingSphere Enables Transparent Data Masking with Encrypt‑JDBC
Architecture Digest
Architecture Digest
Apr 22, 2020 · Databases

Implementing Database Sharding with ShardingSphere‑JDBC in Spring Boot

This article explains how to use ShardingSphere‑JDBC to achieve horizontal database sharding and read/write splitting in a Spring Boot application, covering ShardingSphere concepts, configuration, entity and DAO code, custom sharding algorithm, and practical testing with multiple MySQL instances.

JDBCMySQLReadWrite Splitting
0 likes · 23 min read
Implementing Database Sharding with ShardingSphere‑JDBC in Spring Boot
dbaplus Community
dbaplus Community
Dec 10, 2019 · Databases

Unveiling Sharding-Proxy: Transparent Database Sharding in Apache ShardingSphere

This talk walks through Sharding-Proxy’s role within Apache ShardingSphere, detailing its architecture, SQL lifecycle from protocol decoding to routing, rewriting, execution, and result merging, while highlighting core principles, performance bottlenecks, and practical optimization techniques for high‑throughput, low‑latency database proxying.

NettySQL RoutingSharding-Proxy
0 likes · 17 min read
Unveiling Sharding-Proxy: Transparent Database Sharding in Apache ShardingSphere
Programmer DD
Programmer DD
Oct 26, 2019 · Databases

How JDTX Redefines Distributed Transactions with ACID Guarantees

This article introduces JDTX, a novel distributed transaction middleware that combines ACID guarantees, high performance, and 1PC architecture, explains its design principles, compares two‑phase commit with flexible transactions, details its MVCC and WAL implementation, and outlines integration with Apache ShardingSphere and future roadmap.

JDTXMVCCShardingSphere
0 likes · 19 min read
How JDTX Redefines Distributed Transactions with ACID Guarantees
ITPUB
ITPUB
Oct 24, 2019 · Databases

How JDTX Achieves High‑Performance Distributed Transactions with MVCC and WAL

This article explains the design and implementation of JDTX, a distributed transaction middleware that combines MVCC, WAL, and a one‑phase commit model to provide strong ACID guarantees, high performance, and multi‑database support while outlining its challenges and future roadmap.

Database MiddlewareJDTXMVCC
0 likes · 17 min read
How JDTX Achieves High‑Performance Distributed Transactions with MVCC and WAL
JD Tech Talk
JD Tech Talk
Sep 12, 2019 · Databases

Reflections on ApacheCon 2019 in Las Vegas: ShardingSphere’s First Participation and Community Insights

The article recounts JD Digits architect Zhang Liang’s experience representing the Apache ShardingSphere community at ApacheCon 2019 in Las Vegas, describing the conference atmosphere, community interactions, ShardingSphere’s observability talk and Shark Tank showcase, and the growing Chinese contribution to the Apache ecosystem.

ApacheConShardingSpherecommunity
0 likes · 5 min read
Reflections on ApacheCon 2019 in Las Vegas: ShardingSphere’s First Participation and Community Insights
JD Tech Talk
JD Tech Talk
Sep 5, 2019 · Information Security

Comprehensive Solution for Data Masking with Apache ShardingSphere (Part 2)

This article explains how to use Apache ShardingSphere's data‑masking (encryption) features to protect both new and existing MySQL/Oracle/PostgreSQL/SQLServer workloads, providing detailed YAML configurations, migration steps, advantages, applicable scenarios, and limitations for secure database operations.

Database SecurityEncrypt-JDBCMySQL
0 likes · 12 min read
Comprehensive Solution for Data Masking with Apache ShardingSphere (Part 2)
dbaplus Community
dbaplus Community
Aug 22, 2019 · Information Security

Transparent Data Masking with Apache ShardingSphere for New and Legacy Apps

Apache ShardingSphere provides a complete, transparent, low‑cost data masking solution that lets both new and existing applications encrypt sensitive fields without modifying business SQL, using Encrypt‑JDBC or Encrypt‑Proxy, configurable encryption rules, and step‑by‑step migration guidance for seamless, secure database transformations.

Database SecurityEncrypt-JDBCShardingSphere
0 likes · 19 min read
Transparent Data Masking with Apache ShardingSphere for New and Legacy Apps
JD Tech Talk
JD Tech Talk
Aug 14, 2019 · Information Security

Apache ShardingSphere Data Masking: Architecture, Scenarios, and Implementation Details

This article explains how Apache ShardingSphere provides a comprehensive, transparent, and low‑cost data masking solution for both new and existing applications, detailing the background, use‑case scenarios, architecture, masking rules, and processing flow that enable secure encryption and decryption without modifying business logic.

ShardingSpheredata masking
0 likes · 10 min read
Apache ShardingSphere Data Masking: Architecture, Scenarios, and Implementation Details
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jun 28, 2019 · Databases

Implementing Read/Write Splitting with ShardingSphere in a Spring Boot Application

This article explains how to implement database read‑write splitting in a Spring Boot application using ShardingSphere, covering the creation of master‑slave MySQL databases, Maven dependency setup, multi‑data‑source configuration, load‑balance algorithms, and handling replication lag with HintManager.

DatabaseReplicationJdbcTemplateMySQL
0 likes · 8 min read
Implementing Read/Write Splitting with ShardingSphere in a Spring Boot Application
JD Tech
JD Tech
Mar 7, 2019 · Databases

Distributed Transaction Solutions in Apache ShardingSphere: XA, Saga, and Flexible Transactions

Apache ShardingSphere provides an integrated distributed transaction solution combining traditional ACID‑compliant two‑phase commit, flexible Saga‑based transactions, and automatic transaction management, detailing their architectures, features, trade‑offs, and usage guidelines for developers handling multi‑database microservice environments.

SAGAShardingSphereXA
0 likes · 18 min read
Distributed Transaction Solutions in Apache ShardingSphere: XA, Saga, and Flexible Transactions
dbaplus Community
dbaplus Community
Jul 31, 2018 · Databases

Mastering Distributed Transactions with ShardingSphere: From ACID to TCC

This article explains the challenges of preserving ACID properties in distributed environments, introduces CAP and BASE trade‑offs, reviews industry transaction models such as XA, 2PC, weak XA, BED, TCC and Saga, and details how ShardingSphere implements and plans to evolve support for these distributed transaction mechanisms.

BASECAPSAGA
0 likes · 19 min read
Mastering Distributed Transactions with ShardingSphere: From ACID to TCC
dbaplus Community
dbaplus Community
Jun 19, 2018 · Databases

Mastering Sharding-Proxy: Architecture, Performance Tweaks, and Best Practices

This article provides a comprehensive technical overview of Sharding-Proxy, covering its transparent MySQL‑protocol design, internal architecture, PreparedStatement optimization, HikariCP tuning, result‑set streaming, memory‑strict and connection‑strict modes, and practical configuration tips for high‑performance database proxying.

Database ProxyHikariCPJDBC
0 likes · 17 min read
Mastering Sharding-Proxy: Architecture, Performance Tweaks, and Best Practices