BestHub
Sign in
Tagged articles
13 articles
Page 1 of 1
Architect's Guide
Architect's Guide
Jul 7, 2025 · Backend Development

Dynamic Data Source Switching in Spring Boot Using ThreadLocal & AbstractRoutingDataSource

This tutorial explains how to implement dynamic data source switching in Spring Boot by combining ThreadLocal with AbstractRoutingDataSource, covering custom context holders, configuration, annotation‑driven switching, dynamic addition of data sources, and complete code examples with test results.

Dynamic Data SourceSpring BootThreadLocal
0 likes · 16 min read
Dynamic Data Source Switching in Spring Boot Using ThreadLocal & AbstractRoutingDataSource
macrozheng
macrozheng
Feb 17, 2025 · Backend Development

Master Dynamic MySQL Master‑Slave Switching in Spring Boot with AOP

This guide explains how to use Spring Boot, AOP, and custom annotations to implement dynamic MySQL master‑slave data source switching, automatically falling back to the master when a slave fails, covering configuration, Maven dependencies, enum definitions, data source beans, routing logic, and usage examples.

Dynamic Data SourceSpring Bootaop
0 likes · 16 min read
Master Dynamic MySQL Master‑Slave Switching in Spring Boot with AOP
Java High-Performance Architecture
Java High-Performance Architecture
Dec 14, 2023 · Backend Development

Master Dynamic Data Source Switching with ThreadLocal in SpringBoot

This guide explains how to implement dynamic data source switching in SpringBoot by leveraging ThreadLocal and AbstractRoutingDataSource, covering basic concepts, code examples for context holder, routing datasource, configuration, annotation‑driven switching, and runtime addition of new data sources with practical testing steps.

Dynamic Data SourceJavaSpringBoot
0 likes · 18 min read
Master Dynamic Data Source Switching with ThreadLocal in SpringBoot
IT Architects Alliance
IT Architects Alliance
Apr 14, 2023 · Databases

Comprehensive Guide to Database Horizontal Scaling, Smooth 2N Expansion, and Keepalived High‑Availability Configuration

This technical guide explains how to scale a sharded database horizontally by introducing five expansion schemes—including shutdown, write‑stop, log‑based, dual‑write, and smooth 2N approaches—covers MariaDB installation, master‑master replication setup, dynamic data‑source configuration with ShardingJDBC, and detailed Keepalived high‑availability configuration for seamless service continuity.

Dual WriteDynamic Data SourceMariaDB
0 likes · 31 min read
Comprehensive Guide to Database Horizontal Scaling, Smooth 2N Expansion, and Keepalived High‑Availability Configuration
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Aug 18, 2022 · Backend Development

Mastering SaaS Tenant Data Routing: Design, Implementation, and Best Practices

This session explains why SaaS applications need tenant data routing, compares multi‑tenant sharing models, details dynamic data source architecture, routing plugin design, tenant identifier propagation, and future sidecar solutions, helping developers choose appropriate isolation strategies, configure flexible data sources, and avoid cross‑tenant data contamination.

Backend DevelopmentDynamic Data SourceSaaS
0 likes · 11 min read
Mastering SaaS Tenant Data Routing: Design, Implementation, and Best Practices
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.

Backward CompatibilityDynamic Data SourceRainbow Bridge DAL
0 likes · 7 min read
Smooth Migration from Client-Side to Proxy-Side Sharding in Database Architecture
Code Ape Tech Column
Code Ape Tech Column
Oct 21, 2020 · Backend Development

Mastering Spring Boot: How to Integrate Multiple Data Sources with MyBatis

This tutorial explains how to configure Spring Boot with a single Druid data source, extend it to multiple dynamic data sources using AbstractRoutingDataSource, and seamlessly integrate MyBatis, including custom annotations, AOP switching, thread‑local isolation, and transaction management for robust multi‑database applications.

Dynamic Data SourceJavaMultiple Data Sources
0 likes · 18 min read
Mastering Spring Boot: How to Integrate Multiple Data Sources with MyBatis
JD Tech
JD Tech
Feb 22, 2019 · Databases

Issues When Using Transactions with Database Read/Write Splitting

This article examines the challenges of using transactions with database read/write splitting, including potential master‑slave switching errors, connection‑pool deadlocks caused by isolation levels and propagation, and presents Spring‑based dynamic data source and transaction management solutions.

Dynamic Data SourceIsolation Levelread/write splitting
0 likes · 6 min read
Issues When Using Transactions with Database Read/Write Splitting
Qunar Tech Salon
Qunar Tech Salon
Sep 20, 2017 · Backend Development

Design and Implementation of a One‑Stop Fund Processing Platform

This article describes the design and implementation of a five‑layer one‑stop fund processing platform, covering architecture, rapid business support, hotspot data handling, storage optimization, and query improvements, including sharding, asynchronous processing, and dynamic data source strategies to ensure scalability and reliability.

Database OptimizationDynamic Data SourceScalability
0 likes · 13 min read
Design and Implementation of a One‑Stop Fund Processing Platform
Meituan Technology Team
Meituan Technology Team
Dec 19, 2016 · Databases

MTDDL: Meituan Distributed Data Layer Middleware Overview

MTDDL, Meituan’s in‑house client‑side sharding middleware, was created to address rapid product‑database growth by offering dynamic data‑source routing, read‑write separation, distributed ID generation, configurable database‑and‑table sharding, connection‑pool management, SQL monitoring, and live configuration updates via annotations and extensible strategies.

Dynamic Data SourceJavaSQL Monitoring
0 likes · 12 min read
MTDDL: Meituan Distributed Data Layer Middleware Overview