BestHub
Sign in
Tagged articles

Read‑Write Splitting

112 articles · Page 1 of 2
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.

Automatic FailoverHigh AvailabilityMySQL
0 likes · 14 min read
Advanced SpringBoot Read‑Write Splitting: Master‑Slave Switching and Automatic Failover
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Jun 4, 2026 · Backend Development

5 Advanced Spring Boot Patterns for Millisecond API Responses

This article presents five advanced Spring Boot 3.5.0 patterns—ETag with conditional requests, read‑write separation, virtual threads, HTTP client connection reuse, and asynchronous processing—to achieve sub‑millisecond API response times, complete with code examples, configuration steps, and performance benefits.

ETagPerformanceRead‑Write Splitting
0 likes · 15 min read
5 Advanced Spring Boot Patterns for Millisecond API Responses
Top Architect
Top Architect
Mar 22, 2026 · Databases

How to Enable Read/Write Splitting with MySQL Router 8.2 and InnoDB ReplicaSet

Discover how to set up MySQL InnoDB ReplicaSet and configure MySQL Router 8.2 for automatic read/write splitting, enabling reads to be routed to replicas and writes to the primary without code changes, complete with step-by-step commands, configuration snippets, and visual verification.

Database PerformanceInnoDB ReplicaSetMySQL
0 likes · 6 min read
How to Enable Read/Write Splitting with MySQL Router 8.2 and InnoDB ReplicaSet
Java Architect Handbook
Java Architect Handbook
Feb 27, 2026 · Databases

Enable MySQL Read/Write Splitting with Router 8.2 and InnoDB ReplicaSet

MySQL 8.2 introduces native read/write splitting via MySQL Router, allowing automatic routing of reads to replicas and writes to the primary source; this guide shows how to set up a simple InnoDB ReplicaSet, configure Router, verify traffic flow, and leverage access mode commands for fine‑grained control.

Database ConfigurationInnoDB ReplicaSetMySQL
0 likes · 6 min read
Enable MySQL Read/Write Splitting with Router 8.2 and InnoDB ReplicaSet
Senior Xiao Ying
Senior Xiao Ying
Feb 23, 2026 · Databases

MySQL Practical Guide #17: Building a High‑Availability Service with Master‑Slave Replication, Read‑Write Splitting, and Load Balancing

By configuring master‑slave replication, implementing read‑write splitting with ProxySQL, and selecting appropriate load‑balancing strategies, you can significantly improve MySQL’s scalability and availability while addressing replication lag through parallel or semi‑synchronous replication, hardware tuning, and monitoring.

High AvailabilityMySQLProxySQL
0 likes · 12 min read
MySQL Practical Guide #17: Building a High‑Availability Service with Master‑Slave Replication, Read‑Write Splitting, and Load Balancing
LuTiao Programming
LuTiao Programming
Feb 18, 2026 · Backend Development

5 Advanced Spring Boot Database Configurations to Make Your Code Reviews Shine

This article explains why basic Spring Boot datasource settings are insufficient for production and walks through five advanced configurations—HikariCP tuning, transaction timeout and isolation, read‑write splitting, slow‑SQL monitoring, and security hardening—each illustrated with concrete code snippets and rationale.

Database SecurityHikariCPRead‑Write Splitting
0 likes · 8 min read
5 Advanced Spring Boot Database Configurations to Make Your Code Reviews Shine
macrozheng
macrozheng
Feb 11, 2026 · Databases

Enable MySQL Router 8.2 Read/Write Splitting with InnoDB ReplicaSet

This guide demonstrates how MySQL Router 8.2 can automatically route read and write traffic using an InnoDB ReplicaSet, showing the minimal architecture, configuration steps, command examples, and the resulting read‑write split behavior without requiring application changes.

Database PerformanceInnoDB ReplicaSetMySQL
0 likes · 4 min read
Enable MySQL Router 8.2 Read/Write Splitting with InnoDB ReplicaSet
Top Architect
Top Architect
Jan 27, 2026 · Databases

How MySQL Router 8.2 Enables Seamless Read/Write Splitting with InnoDB ReplicaSet

This article demonstrates how MySQL Router 8.2 can automatically route read traffic to replica instances and write traffic to the primary instance in an InnoDB ReplicaSet, providing configuration steps, command examples, and observed behavior without requiring any changes to the application.

Database ConfigurationInnoDB ReplicaSetRead‑Write Splitting
0 likes · 6 min read
How MySQL Router 8.2 Enables Seamless Read/Write Splitting with InnoDB ReplicaSet
java1234
java1234
Jan 10, 2026 · Databases

MySQL 8.2 Finally Supports Read/Write Splitting

MySQL 8.2 introduces native read/write splitting via MySQL Router, allowing automatic routing of reads to replicas and writes to the primary in an InnoDB ReplicaSet without any application changes.

InnoDB ReplicaSetMySQLRead‑Write Splitting
0 likes · 4 min read
MySQL 8.2 Finally Supports Read/Write Splitting
IT Services Circle
IT Services Circle
Dec 29, 2025 · Backend Development

Mastering Sharding: When, How, and How Much to Split Your Database

This guide walks senior backend engineers through the strategic reasoning, capacity estimation, and step‑by‑step migration techniques for sharding databases, covering when to split, choosing between partitioning, read/write splitting, or full sharding, and how to plan safe expansions.

Data MigrationRead‑Write Splittingcapacity planning
0 likes · 19 min read
Mastering Sharding: When, How, and How Much to Split Your Database
Code Wrench
Code Wrench
Dec 21, 2025 · Backend Development

Building a High‑Performance Go Database Access Layer for Microservices

This article dissects a production‑grade Go database access framework for microservices, covering unified interface abstraction, factory pattern for multi‑DB support, PostgreSQL array handling, read‑write splitting with load balancing, Redis cache protection, monitoring, and deployment considerations, with full code examples and open‑source links.

GORMGoMicroservices
0 likes · 11 min read
Building a High‑Performance Go Database Access Layer for Microservices
Ray's Galactic Tech
Ray's Galactic Tech
Nov 14, 2025 · Databases

Mastering MySQL Master‑Slave Read/Write Splitting: 4 Strategies and Real‑World Practices

This article explains MySQL master‑slave replication, why read/write splitting is essential, four practical read‑distribution strategies, the main causes of replication lag, four solutions for write‑after‑read consistency, multi‑slave allocation methods, replication modes, and a real‑world e‑commerce decision matrix, ending with a golden architecture recommendation.

Database ArchitectureMySQLRead‑Write Splitting
0 likes · 11 min read
Mastering MySQL Master‑Slave Read/Write Splitting: 4 Strategies and Real‑World Practices
Architect's Guide
Architect's Guide
Oct 13, 2025 · Backend Development

Mastering Read‑Write Splitting in Spring Boot: A Complete Guide

This article explains why read‑write separation is essential for high‑concurrency applications, discusses its limitations, and provides a step‑by‑step Spring Boot implementation—including datasource configuration, routing logic, context management, custom annotations, AOP handling, and usage examples—complete with code snippets and diagrams.

AOPBackend DevelopmentDataSource Routing
0 likes · 11 min read
Mastering Read‑Write Splitting in Spring Boot: A Complete Guide
Ops Community
Ops Community
Aug 20, 2025 · Databases

How MySQL Master‑Slave Replication and Read‑Write Splitting Turn a Single Server into a High‑Availability Architecture

This article walks through why a single MySQL instance often fails under load, explains the fundamentals of asynchronous master‑slave replication and read‑write splitting, provides step‑by‑step configuration scripts, highlights common pitfalls with solutions, and shows advanced optimization and monitoring techniques for building a scalable, high‑availability MySQL architecture.

High AvailabilityMySQLProxySQL
0 likes · 16 min read
How MySQL Master‑Slave Replication and Read‑Write Splitting Turn a Single Server into a High‑Availability Architecture
Java Captain
Java Captain
Jul 8, 2025 · Databases

Integrating MyBatis-Plus Dynamic DataSource with ShardingSphere-JDBC and Custom Load Balancing

This guide shows how to combine MyBatis-Plus dynamic data source routing with ShardingSphere-JDBC for horizontal sharding and read‑write splitting, including Maven dependencies, YAML configuration, Spring bean setup, and a custom load‑balancing algorithm to keep @DS annotations functional.

Custom Load BalancerRead‑Write SplittingShardingSphere
0 likes · 14 min read
Integrating MyBatis-Plus Dynamic DataSource with ShardingSphere-JDBC and Custom Load Balancing
Architect's Guide
Architect's Guide
Jun 15, 2025 · Backend Development

Mastering Read‑Write Splitting in Spring Boot: A Complete Guide

This article explains how to implement database read‑write separation in a Spring Boot application by configuring master and slave data sources, creating a routing datasource, managing thread‑local context, and using an AOP‑based annotation to switch between read and write operations.

AOPDataSource RoutingDatabase
0 likes · 10 min read
Mastering Read‑Write Splitting in Spring Boot: A Complete Guide
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
Cognitive Technology Team
Cognitive Technology Team
May 1, 2025 · Databases

MySQL Optimization Strategies for Read‑Heavy and Write‑Heavy Scenarios

This article systematically examines MySQL optimization techniques for both read‑many/write‑few and write‑many/read‑few business scenarios, covering architecture design, caching, sharding, asynchronous processing, monitoring, and emerging NewSQL/HTAP solutions to achieve high performance, consistency, and scalability.

CachingMySQLPerformance Tuning
0 likes · 9 min read
MySQL Optimization Strategies for Read‑Heavy and Write‑Heavy Scenarios
macrozheng
macrozheng
Oct 17, 2024 · Databases

How MySQL Router 8.2 Enables Seamless Read/Write Splitting

MySQL Router 8.2 now supports automatic read/write splitting for InnoDB ReplicaSets, allowing reads to be routed to replicas and writes to the primary without any application changes, thereby improving performance and scalability.

InnoDB ReplicaSetRead‑Write Splittingrouter
0 likes · 5 min read
How MySQL Router 8.2 Enables Seamless Read/Write Splitting
Top Architect
Top Architect
Jul 22, 2024 · Databases

MySQL Router 8.2 Read/Write Splitting with InnoDB ReplicaSet

This article demonstrates how MySQL Router 8.2 can perform automatic read/write splitting using an InnoDB ReplicaSet, shows the required configuration, explains the behavior of read and write connections, and concludes with the benefits of the feature while also containing promotional material for unrelated services.

InnoDBRead‑Write SplittingReplicaSet
0 likes · 7 min read
MySQL Router 8.2 Read/Write Splitting with InnoDB ReplicaSet
Zhuanzhuan Tech
Zhuanzhuan Tech
Jun 12, 2024 · Databases

Designing a Scalable Persistence Layer: Sharding, Query Optimization, and Read/Write Splitting

This article shares a practical case study on how a coupon‑distribution system evolved from a single‑table design to a sharded, multi‑database architecture with query optimization, ElasticSearch integration, and read/write splitting to handle growing data volume, complex queries, and increasing request traffic.

DatabasesElasticsearchRead‑Write Splitting
0 likes · 12 min read
Designing a Scalable Persistence Layer: Sharding, Query Optimization, and Read/Write Splitting
Programmer DD
Programmer DD
May 23, 2024 · Backend Development

Mastering High‑Concurrency Architecture: From Metrics to Read/Write Splitting and Caching

This article explains the essential elements of high‑concurrency system design—performance, availability, scalability—introduces quantitative metrics, classifies read‑heavy and write‑heavy scenarios, and details practical solutions such as database read/write separation, local and distributed caching, cache‑penetration and avalanche mitigation, and CQRS implementation for billion‑user applications.

CQRSCachingHigh concurrency
0 likes · 22 min read
Mastering High‑Concurrency Architecture: From Metrics to Read/Write Splitting and Caching
Laravel Tech Community
Laravel Tech Community
May 22, 2024 · Databases

Laravel Read/Write Database Separation Configuration Guide

This article explains how to set up read/write database separation in Laravel by configuring multiple database connections in the config/database.php file, covering both identical and distinct credentials for read and write servers, and describing the purpose of the sticky option to ensure data consistency during a request.

Database ConfigurationLaravelPHP
0 likes · 4 min read
Laravel Read/Write Database Separation Configuration Guide
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
Open Source Tech Hub
Open Source Tech Hub
Dec 11, 2023 · Databases

How MySQL 8.2 Router Enables Seamless Read/Write Splitting

Oracle’s MySQL 8.2 introduces built‑in read/write splitting via MySQL Router, allowing write traffic to target primary instances while reads are automatically routed to secondary replicas, with configuration examples, command‑line bootstrap, routing settings, and practical observations on transaction behavior.

Database PerformanceInnoDB ClusterMySQL
0 likes · 6 min read
How MySQL 8.2 Router Enables Seamless Read/Write Splitting
dbaplus Community
dbaplus Community
Nov 2, 2023 · Databases

Scaling a Ride‑Hailing Order System: From Single SQLServer to Sharded MySQL

This article recounts the step‑by‑step evolution of a ride‑hailing order service’s data layer—from a single SQLServer database through SQL optimization, read‑write splitting, business‑domain sharding, caching and MQ integration, to a custom sharding component and smooth migration to MySQL—highlighting challenges, solutions, and lessons learned.

CachingData MigrationMessage Queue
0 likes · 15 min read
Scaling a Ride‑Hailing Order System: From Single SQLServer to Sharded MySQL
JD Cloud Developers
JD Cloud Developers
Oct 12, 2023 · Databases

How to Handle MySQL Replication Lag in Read/Write Splitting Architectures

This article explains the reasons for read/write splitting, compares direct‑client and proxy‑based master‑slave setups, and presents five practical strategies—including forcing reads to the master, sleep delays, lag checks, master‑position waiting, and GTID waiting—to mitigate stale reads caused by MySQL replication lag.

Database ArchitectureLag MitigationMaster‑Slave
0 likes · 15 min read
How to Handle MySQL Replication Lag in Read/Write Splitting Architectures
Architect's Guide
Architect's Guide
Aug 3, 2023 · Backend Development

Robustdb: A Lightweight Client‑Side Read‑Write Splitting Solution for MySQL

This article introduces Robustdb, a compact Java library that implements client‑side read‑write splitting and method‑level routing for MySQL databases, explains its architecture, core code components, dynamic read‑pool allocation strategy, and performance comparison with Atlas, while providing practical implementation details and configuration guidance.

JavaRead‑Write SplittingSpring
0 likes · 15 min read
Robustdb: A Lightweight Client‑Side Read‑Write Splitting Solution for MySQL
IT Xianyu
IT Xianyu
Apr 19, 2023 · Databases

Robustdb: A Lightweight Read‑Write Splitting Solution for Java Applications

This article introduces Robustdb, a compact open‑source read‑write separation framework built with about ten classes and two thousand lines of code, explains its architecture, routing logic, method‑level transaction handling, dynamic data‑source management, and performance advantages over existing solutions like Atlas.

DataSourceJavaPerformance
0 likes · 15 min read
Robustdb: A Lightweight Read‑Write Splitting Solution for Java Applications
ITPUB
ITPUB
Mar 18, 2023 · Databases

How to Keep MySQL Slave Nodes Alive with Keepalived and Read/Write Splitting

This guide walks through the background of MySQL read/write splitting, records troubleshooting steps for an unexpected slave crash, explains the two splitting models, and provides detailed commands and configuration examples for using Keepalived to ensure high availability of the slave node.

DatabaseDockerKeepalived
0 likes · 9 min read
How to Keep MySQL Slave Nodes Alive with Keepalived and Read/Write Splitting
macrozheng
macrozheng
Nov 25, 2022 · Databases

How We Scaled a Ride‑Hailing Order System: From Single DB to Sharded MySQL

This article chronicles the step‑by‑step evolution of a ride‑hailing order service's data layer, covering the shift from a single SQLServer database to read‑write separation, business‑domain sharding, caching, message queues, a self‑built sharding component, and a data exchange platform for smooth migration and ongoing scalability.

MySQL MigrationRead‑Write Splittingdatabase sharding
0 likes · 14 min read
How We Scaled a Ride‑Hailing Order System: From Single DB to Sharded MySQL
IT Architects Alliance
IT Architects Alliance
Nov 16, 2022 · Backend Development

How to Transform a Simple Blog into a Scalable High‑Traffic System

This article walks through turning a basic personal‑blog architecture—single server, MySQL, and Node.js—into a high‑concurrency system by adding Redis caching, Nginx load balancing, horizontal scaling, read‑write splitting, sharding, NewSQL databases, and message‑queue techniques.

CachingNewSQLRead‑Write Splitting
0 likes · 15 min read
How to Transform a Simple Blog into a Scalable High‑Traffic System
Top Architect
Top Architect
Nov 15, 2022 · Backend Development

Scaling a Personal Blog: Caching, Load Balancing, Read/Write Splitting, Sharding, and NewSQL

This article explains how to transform a simple personal‑blog backend into a high‑performance, horizontally scalable system by introducing caching with Redis, load balancing with Nginx/LVS, read/write separation, database sharding, and modern NewSQL solutions such as TiDB, while also discussing related challenges like cache consistency and data migration.

MySQLNewSQLRead‑Write Splitting
0 likes · 14 min read
Scaling a Personal Blog: Caching, Load Balancing, Read/Write Splitting, Sharding, and NewSQL
Architect's Guide
Architect's Guide
Oct 31, 2022 · Databases

Robustdb: A Client‑Side Read‑Write Splitting Solution for MySQL

This article introduces Robustdb, a lightweight client‑side read‑write splitting framework built with only a dozen classes, explains its architecture, routing logic, method‑level transaction handling, dynamic data‑source management, and presents performance comparisons with the legacy Atlas proxy.

JavaRead‑Write SplittingSpring
0 likes · 17 min read
Robustdb: A Client‑Side Read‑Write Splitting Solution for MySQL
ITPUB
ITPUB
Oct 29, 2022 · Databases

When and How to Implement Master‑Slave Read/Write Splitting in MySQL

This article explains when read/write splitting is needed, details MySQL master‑slave replication mechanics, outlines middleware design choices, and provides practical monitoring and mitigation strategies for replication lag, helping developers decide and implement effective database scaling.

MySQLRead‑Write Splittingmaster‑slave replication
0 likes · 13 min read
When and How to Implement Master‑Slave Read/Write Splitting in MySQL
Top Architect
Top Architect
Oct 26, 2022 · Backend Development

Implementing Database Read‑Write Splitting with Spring Boot and Dynamic DataSource Routing

This article explains how to achieve database read‑write separation in high‑concurrency Java applications by configuring master and slave data sources, implementing a routing DataSource, managing context with ThreadLocal, defining a custom @DataSourceSwitcher annotation, and applying AOP to switch between read and write operations.

AOPDataSource RoutingJava
0 likes · 11 min read
Implementing Database Read‑Write Splitting with Spring Boot and Dynamic DataSource Routing
Java Backend Technology
Java Backend Technology
Sep 29, 2022 · Databases

How Robustdb Enables Client‑Side Read/Write Splitting Beyond Atlas

This article explains how a company built Robustdb, a lightweight client‑side read/write splitting solution to replace Atlas, detailing its background, routing core, method‑level control, dynamic data source management, performance gains, and providing code examples for implementation.

ATLASRead‑Write SplittingRobustdb
0 likes · 17 min read
How Robustdb Enables Client‑Side Read/Write Splitting Beyond Atlas
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 15, 2022 · Databases

DBLE 3.22.07.0 Release Notes and Feature Overview

The article introduces the DBLE distributed middleware, outlines the main updates in version 3.22.07.0—including read‑write splitting local read, OpenSSL support, hint‑based query plan improvements—and provides the complete release notes, bug fixes, acknowledgments, and related learning resources.

DBLEOpenSSLRead‑Write Splitting
0 likes · 6 min read
DBLE 3.22.07.0 Release Notes and Feature Overview
Java High-Performance Architecture
Java High-Performance Architecture
Sep 8, 2022 · Backend Development

Mastering Java Read‑Write Splitting: Configure Master‑Slave DataSources with Spring

This article explains the concept of database read‑write splitting, discusses its limitations, and provides a step‑by‑step guide with Spring Boot code to configure master‑slave data sources, implement dynamic routing, context handling, custom annotations, and AOP for seamless switching.

DataSource RoutingJavaMaster‑Slave
0 likes · 11 min read
Mastering Java Read‑Write Splitting: Configure Master‑Slave DataSources with Spring
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.

DockerRead‑Write SplittingShardingSphere
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.

MySQLRead‑Write SplittingShardingSphere
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
dbaplus Community
dbaplus Community
Apr 24, 2022 · Databases

Eight Practical Strategies to Tackle Database Performance Bottlenecks

This article outlines a systematic approach for backend engineers to identify root causes of database slowness and presents eight concrete optimization techniques—ranging from data reduction and space‑for‑performance trade‑offs to appropriate storage system selection—while explaining when each method is most effective and what trade‑offs to consider.

CQRSCachingDatabase Performance
0 likes · 18 min read
Eight Practical Strategies to Tackle Database Performance Bottlenecks
dbaplus Community
dbaplus Community
Apr 20, 2022 · Backend Development

How to Build a Robust E‑Commerce Backend: Idempotency, Snapshots, and Sharding

This article explores common e‑commerce backend challenges such as duplicate orders, order snapshots, cart storage, inventory oversell, logistics updates, account balance consistency, read‑write splitting, hot‑cold data separation, and sharding, and provides concrete design patterns and SQL examples to solve them.

Read‑Write SplittingShardingTransaction
0 likes · 17 min read
How to Build a Robust E‑Commerce Backend: Idempotency, Snapshots, and Sharding
Architecture & Thinking
Architecture & Thinking
Feb 10, 2022 · Databases

Mastering MySQL Master‑Slave Replication: Principles, Challenges & Solutions

This article explains MySQL master‑slave replication fundamentals, why it’s used, the replication workflow, causes of lag, and presents multiple practical solutions—including system tuning, partitioning, caching, multi‑threaded relay log replay, and read‑from‑master strategies—to improve performance and reliability.

Database PerformanceMySQLRead‑Write Splitting
0 likes · 12 min read
Mastering MySQL Master‑Slave Replication: Principles, Challenges & Solutions
macrozheng
macrozheng
Nov 11, 2021 · Backend Development

Mastering Spring Boot Read/Write Splitting with Custom Routing DataSource

This tutorial explains how to implement read/write splitting in Spring Boot by configuring multiple data sources, creating a custom AbstractRoutingDataSource, and using AOP to dynamically route queries to master or slave databases based on method patterns and annotations.

AOPMyBatisRead‑Write Splitting
0 likes · 17 min read
Mastering Spring Boot Read/Write Splitting with Custom Routing DataSource
Programmer DD
Programmer DD
Oct 19, 2021 · Backend Development

Mastering Read/Write Splitting in Spring Boot with Custom Routing DataSource

This article explains how to implement read/write separation in a Spring Boot application by configuring multiple data sources, creating a custom AbstractRoutingDataSource, using AOP to switch between master and slave databases, and demonstrates the setup with Maven, MyBatis, and JUnit tests.

AOPMulti-DataSourceMyBatis
0 likes · 16 min read
Mastering Read/Write Splitting in Spring Boot with Custom Routing DataSource
Java Architect Essentials
Java Architect Essentials
Sep 25, 2021 · Backend Development

Implementing Read‑Write Splitting in Spring Boot with AbstractRoutingDataSource and AOP

This article explains how to achieve read‑write splitting in a Spring Boot application by configuring multiple data sources, creating a custom AbstractRoutingDataSource, managing routing keys with ThreadLocal, and using AOP to automatically switch between master and slave databases for different CRUD operations.

AOPDataSource RoutingJava
0 likes · 12 min read
Implementing Read‑Write Splitting in Spring Boot with AbstractRoutingDataSource and AOP
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
Java Interview Crash Guide
Java Interview Crash Guide
Jul 16, 2021 · Databases

Master‑Slave MySQL Replication: Core Principles, Common Pitfalls, and Advanced Strategies

This article explains MySQL master‑slave replication fundamentals, including basic synchronization, circular replication issues, lag handling, failover strategies, parallel replication techniques, GTID usage, and read‑write splitting, providing practical guidance for reliable high‑availability database deployments.

GTIDMaster‑SlaveMySQL
0 likes · 33 min read
Master‑Slave MySQL Replication: Core Principles, Common Pitfalls, and Advanced Strategies
Selected Java Interview Questions
Selected Java Interview Questions
Jul 15, 2021 · Databases

Fundamentals and Advanced Strategies of MySQL Master‑Slave Replication

This article explains the basic principles of MySQL master‑slave architecture, the role of read‑only replicas, loop‑replication problems, master‑slave delay measurement, various failover strategies, parallel replication mechanisms across MySQL versions and MariaDB, GTID usage, and read‑write splitting techniques, providing practical commands and diagrams for each concept.

Database LagGTIDMaster‑Slave
0 likes · 31 min read
Fundamentals and Advanced Strategies of MySQL Master‑Slave Replication
Efficient Ops
Efficient Ops
Jun 9, 2021 · Databases

Why MySQL Queries Go Slow and How to Fix Them with Indexes, ES, and HBase

This article explains why MySQL queries become slow, explores index-related pitfalls and optimization techniques, and then compares ElasticSearch and HBase as complementary solutions for large‑scale data and search scenarios, offering practical tips and code examples.

Database PerformanceHBaseIndexing
0 likes · 21 min read
Why MySQL Queries Go Slow and How to Fix Them with Indexes, ES, and HBase
IT Architects Alliance
IT Architects Alliance
May 26, 2021 · Databases

Understanding MySQL Slow Queries, Elasticsearch, and HBase: Causes and Practical Solutions

This article explains why MySQL queries become slow, how indexes work and fail, the impact of MDL locks, large‑table challenges, sharding and read‑write splitting strategies, then introduces Elasticsearch’s search capabilities and HBase’s column‑family storage, offering practical guidance for each technology.

Database PerformanceElasticsearchHBase
0 likes · 17 min read
Understanding MySQL Slow Queries, Elasticsearch, and HBase: Causes and Practical Solutions
Code Ape Tech Column
Code Ape Tech Column
May 21, 2021 · Databases

Why Your MySQL Queries Are Slow and How ElasticSearch & HBase Can Help

This article analyzes common causes of slow MySQL queries such as index misuse, MDL locks, and large‑table bottlenecks, then presents practical solutions like proper indexing, sharding, read/write splitting, and evaluates when to complement MySQL with ElasticSearch or HBase for better performance.

Database PerformanceElasticsearchHBase
0 likes · 19 min read
Why Your MySQL Queries Are Slow and How ElasticSearch & HBase Can Help
JavaEdge
JavaEdge
Mar 21, 2021 · Databases

From Single MySQL to Cluster: Master‑Slave Replication, High Availability, and Scaling Strategies

This article explains why growing MySQL workloads require moving from a single instance to a clustered architecture, details the mechanics of master‑slave replication, asynchronous, semi‑synchronous and group replication, and evaluates various high‑availability solutions and read‑write splitting techniques.

Group ReplicationHigh AvailabilityMHA
0 likes · 18 min read
From Single MySQL to Cluster: Master‑Slave Replication, High Availability, and Scaling Strategies
Top Architect
Top Architect
Mar 19, 2021 · Backend Development

Implementing Database Read‑Write Splitting with Spring Boot

This article explains how to implement database read‑write splitting in a Spring Boot application by configuring master and slave data sources, creating a dynamic routing datasource, using a ThreadLocal context holder, defining a custom annotation with AOP for automatic switching, and demonstrates usage with sample code.

AOPDataSource RoutingJava
0 likes · 11 min read
Implementing Database Read‑Write Splitting with Spring Boot
Architecture Digest
Architecture Digest
Feb 9, 2021 · Backend Development

Implementing Database Read‑Write Splitting with Spring Boot

This article explains how to achieve database read‑write separation in high‑concurrency Java applications by configuring master‑slave data sources, implementing a routing data source, managing context with ThreadLocal, defining a custom @DataSourceSwitcher annotation, and applying AOP to dynamically switch between read and write databases.

AOPDataSource RoutingDatabase
0 likes · 10 min read
Implementing Database Read‑Write Splitting with Spring Boot
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
php Courses
php Courses
Nov 13, 2020 · Backend Development

Understanding ThinkPHP Query Method and Database Connection Initialization

The article explains how ThinkPHP’s query method works with raw SQL, distinguishes between execute for writes and query for reads, details MySQL master‑slave replication considerations, and describes the framework’s database connection initialization, including read/write separation logic and related code examples.

DatabasePHPRead‑Write Splitting
0 likes · 6 min read
Understanding ThinkPHP Query Method and Database Connection Initialization
Java Architect Essentials
Java Architect Essentials
Oct 28, 2020 · Backend Development

Implementing Read/Write Splitting with Spring's AbstractRoutingDataSource

This article demonstrates how to implement read/write splitting in a Spring Boot application by configuring multiple data sources, using AbstractRoutingDataSource for dynamic routing, and applying AOP and custom annotations to direct read operations to slave databases and write operations to the master, with full Maven and MyBatis setup.

AOPDataSource RoutingMyBatis
0 likes · 17 min read
Implementing Read/Write Splitting with Spring's AbstractRoutingDataSource
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 9, 2020 · Databases

MySQL Passive Performance Optimization Principles and Practices

This article explains the principles of MySQL performance optimization, distinguishes active and passive approaches, and provides concrete solutions for slow single queries, partially slow queries, and overall slow queries through proper indexing, data partitioning, slow‑query‑log configuration, and read‑write splitting.

Data PartitioningMySQLPerformance Optimization
0 likes · 12 min read
MySQL Passive Performance Optimization Principles and Practices
Laravel Tech Community
Laravel Tech Community
May 4, 2020 · Backend Development

How to Implement Laravel Read/Write Splitting with Nginx Load Balancing

This guide explains how to configure Laravel for read/write database separation and set up Nginx load balancing, covering hardware requirements, Laravel config/database.php adjustments, Nginx upstream strategies, detailed server blocks, and essential parameter explanations for a scalable web architecture.

Backend DevelopmentLaravelNGINX
0 likes · 6 min read
How to Implement Laravel Read/Write Splitting with Nginx Load Balancing
Architecture Digest
Architecture Digest
Feb 29, 2020 · Backend Development

Implementing Read‑Write Splitting in Spring Boot with AbstractRoutingDataSource

This article demonstrates how to achieve read‑write splitting in a Spring Boot application by configuring multiple data sources, creating a custom AbstractRoutingDataSource, using AOP to switch between master and slave databases, and integrating the routing data source with MyBatis for transparent database operations.

AOPDataSource RoutingMyBatis
0 likes · 15 min read
Implementing Read‑Write Splitting in Spring Boot with AbstractRoutingDataSource
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 4, 2019 · Databases

Interview with Yan Huqing on Quickly Getting Started with Distributed Middleware Dble

The article presents a detailed interview with Yan Huqing, the lead of the open‑source DBLE project, covering his background, the upcoming Shanghai 3306π meetup agenda, and practical advice on using Dble for sharding, read‑write splitting, and advanced monitoring in distributed database environments.

DBMSRead‑Write Splittingdatabase sharding
0 likes · 6 min read
Interview with Yan Huqing on Quickly Getting Started with Distributed Middleware Dble
Architect's Tech Stack
Architect's Tech Stack
Feb 26, 2019 · Databases

Database Architecture: Primary‑Backup, Master‑Slave, Read‑Write Splitting, and Consistency Solutions

This article explains fundamental database architecture principles, compares four common deployment patterns—including primary‑backup, dual‑primary, master‑slave with read‑write separation, and a hybrid dual‑primary/master‑slave design—analyzes their high‑availability, performance, consistency, and scalability characteristics, and presents practical consistency‑resolution techniques and personal insights.

CachingDatabase ArchitectureHigh Availability
0 likes · 10 min read
Database Architecture: Primary‑Backup, Master‑Slave, Read‑Write Splitting, and Consistency Solutions
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 SourceRead‑Write SplittingSpring
0 likes · 6 min read
Issues When Using Transactions with Database Read/Write Splitting
Sohu Tech Products
Sohu Tech Products
Dec 12, 2018 · Databases

Optimizing MySQL Performance with Read/Write Splitting, Columnar Storage, and Dynamic Scheduling

The article details a real‑world MySQL performance case where a sudden 100‑fold load increase was mitigated through read/write splitting, replica‑based statistics, limited index tuning, middleware‑driven sharding, and finally a columnar storage layer (Infobright) with scripted dynamic data synchronization, achieving dramatic latency reductions and scalable architecture.

Columnar StorageData WarehouseInfobright
0 likes · 12 min read
Optimizing MySQL Performance with Read/Write Splitting, Columnar Storage, and Dynamic Scheduling
dbaplus Community
dbaplus Community
Dec 9, 2018 · Databases

How Read‑Write Splitting and Columnar Storage Rescued a 100× MySQL Load Spike

A MySQL‑based receipt‑tracking service suffered a sudden 100‑fold load increase, prompting a step‑by‑step optimization that combined read‑write splitting, middleware‑less data routing, columnar storage with Infobright, and dynamic scheduling to dramatically lower CPU/IO pressure and restore performance.

Columnar StorageMySQLPerformance Optimization
0 likes · 13 min read
How Read‑Write Splitting and Columnar Storage Rescued a 100× MySQL Load Spike
Architecture Digest
Architecture Digest
Jun 14, 2017 · Backend Development

Techniques for Achieving High Concurrency: Optimistic Lock, Read‑Write Splitting, CDN, Caching, and Load Balancing

The article explains how high‑concurrency systems can be built by decomposing workloads through optimistic locking, read‑write database splitting, resource separation with CDN acceleration, dynamic‑to‑static conversion, caching, and load‑balancing strategies, providing practical code examples for each technique.

CDNCachingHigh concurrency
0 likes · 6 min read
Techniques for Achieving High Concurrency: Optimistic Lock, Read‑Write Splitting, CDN, Caching, and Load Balancing