BestHub
Sign in
Tagged articles

Read-Write Splitting

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

CachingRead-Write Splittingconsistency
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 SourceIsolation LevelRead-Write Splitting
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.

InfobrightMySQLPerformance Optimization
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.

Database ScalingMySQLPerformance 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.

BackendCDNCaching
0 likes · 6 min read
Techniques for Achieving High Concurrency: Optimistic Lock, Read‑Write Splitting, CDN, Caching, and Load Balancing
Java Backend Technology
Java Backend Technology
Dec 29, 2016 · Backend Development

Mastering Database Read/Write Splitting with Spring AOP: A Practical Demo

This article explains the concept of read/write splitting in distributed databases, outlines two implementation methods—static dual data sources and dynamic AOP-based switching—provides a complete Spring‑MyBatis demo with configuration files, code snippets, and guidance on setting up master and slave connections.

Database ReplicationJavaMaster‑Slave
0 likes · 7 min read
Mastering Database Read/Write Splitting with Spring AOP: A Practical Demo
21CTO
21CTO
Apr 21, 2016 · Databases

How to Set Up MySQL Read/Write Splitting with MySQLProxy

Learn the fundamentals of MySQL read/write splitting, why it boosts performance, and step‑by‑step instructions to configure master‑slave replication, create users, set up MySQLProxy, and verify the split‑read behavior using command‑line examples on a test environment.

Master-Slave ReplicationMySQLMySQLProxy
0 likes · 9 min read
How to Set Up MySQL Read/Write Splitting with MySQLProxy
21CTO
21CTO
Feb 23, 2016 · Databases

Master Database Load Balancing, Read/Write Splitting, and Sharding Techniques

This article explains how large‑scale internet applications can overcome database bottlenecks by using load‑balancing clusters, implementing read/write separation, and applying vertical or horizontal sharding, while outlining each method's principles, implementation steps, advantages, and drawbacks.

Database ClusteringRead-Write Splittingdatabase load balancing
0 likes · 11 min read
Master Database Load Balancing, Read/Write Splitting, and Sharding Techniques
Qunar Tech Salon
Qunar Tech Salon
Feb 17, 2016 · Databases

Understanding 503 Errors and Database Bottlenecks: From Read‑Write Splitting to Caching, Vertical and Horizontal Sharding

The article explains that 503 errors under high concurrency are usually caused by database bottlenecks and outlines a systematic approach—including read‑write separation, caching with memcached, consistent hashing, vertical partitioning, and horizontal sharding—to improve website scalability and reliability.

503 errorCachingMemcached
0 likes · 11 min read
Understanding 503 Errors and Database Bottlenecks: From Read‑Write Splitting to Caching, Vertical and Horizontal Sharding
MaGe Linux Operations
MaGe Linux Operations
Dec 16, 2015 · Databases

Mastering MySQL Replication: Concepts, Architectures, and Advanced Strategies

This article explains MySQL replication fundamentals, detailing master‑slave and multi‑master architectures, thread roles, configuration parameters, read‑write splitting, multi‑source setups, and advanced scenarios such as multi‑level and circular replication, while highlighting common pitfalls and performance considerations.

Master‑SlaveMySQLRead-Write Splitting
0 likes · 7 min read
Mastering MySQL Replication: Concepts, Architectures, and Advanced Strategies
21CTO
21CTO
Sep 8, 2015 · Databases

Designing Resilient MySQL Architectures for 24/7 Online Services

To ensure 24/7 availability for e‑commerce and gaming platforms, this article examines MySQL architecture from business analysis to common patterns, including read‑write ratios, consistency models, sharding strategies, historical data migration, and cluster scaling, highlighting practical designs for disaster‑tolerant, high‑performance systems.

MySQLRead-Write Splittingdatabase architecture
0 likes · 18 min read
Designing Resilient MySQL Architectures for 24/7 Online Services
Architect
Architect
Jul 8, 2015 · Databases

MySQL Architecture Design: Business Analysis, Common Deployment Patterns, Sharding Strategies, and High‑Availability Practices

This article explains MySQL architecture design for 24/7 online services, covering business analysis of read‑write patterns, common deployment models, consistency levels, data migration, sharding strategies (vertical, horizontal, and business‑level), and cluster scaling for high availability.

MySQLRead-Write Splittingdata migration
0 likes · 17 min read
MySQL Architecture Design: Business Analysis, Common Deployment Patterns, Sharding Strategies, and High‑Availability Practices