When MySQL QPS reaches 10,000, common bottlenecks include CPU saturation, low buffer pool hit rate, connection limits, and lock contention, which can be mitigated through internal tuning, cache interception, read‑write splitting, and horizontal sharding.
Learn how to use GORM's DBResolver plugin in Go to achieve efficient read/write separation and load balancing across master and replica databases, with detailed code examples, configuration tips, production best practices, and strategies for connection pooling, transaction consistency, and handling replication lag.
This guide walks through building a three‑node lab, installing MariaDB, configuring master‑slave binary‑log replication, creating a test database, and then deploying MySQL‑Proxy on an application server to achieve transparent read/write splitting between the master and slave.
The article demonstrates how MySQL Router 8.2 enables transparent read/write splitting for an InnoDB ReplicaSet, showing the architecture, configuration steps, connection behavior, and the generated routing settings that improve database performance without modifying application code.
The article explains how MySQL Router 8.2 automatically splits read and write traffic in an InnoDB ReplicaSet, routing reads to asynchronous replicas and writes to the primary, providing performance, scalability, and simplified management without any application‑level changes.
This article explains how MySQL Router 8.2 enables read/write splitting for an InnoDB ReplicaSet, showing configuration steps, routing behavior, sample code, and the resulting performance and management benefits without requiring application changes.
This tutorial demonstrates how to enable and use MySQL 8.2 read/write splitting with MySQL‑Connector/Python in an InnoDB Cluster, covering cluster status inspection, autocommit configuration, routing attributes, DML testing, and transaction handling.
This tutorial demonstrates how to enable MySQL 8.2's transparent read/write splitting with InnoDB Cluster, configure MySQL Router, use MySQL Connector/Python for read‑only and read‑write queries, test DML statements, and manage transactions across primary and secondary nodes.
MySQL 8.2 introduces transparent read/write splitting via MySQL Router, allowing automatic routing of read traffic to replica instances and write traffic to the primary source without any changes to the application, demonstrated with a simple InnoDB ReplicaSet deployment and configuration examples.
This article explains how to achieve database read‑write separation in high‑concurrency scenarios using Spring Boot, Druid connection pool, dynamic DataSource routing, a ThreadLocal context holder, custom annotations, and AOP, providing complete configuration code and usage examples for both read and write operations.
This tutorial demonstrates how to set up MySQL master‑slave replication using Docker, configure MyBatisPlus and ShardingSphereJDBC for read/write splitting, and integrate the setup into a Spring Boot application with Druid, code generation, and REST endpoints for testing.
This tutorial explains why read/write splitting is useful, shows step‑by‑step how to build a MySQL master‑slave cluster with Docker, configure the master and slave instances, and then use Sharding‑JDBC to transparently route writes to the master and reads to the slave.
This article explains the basics of MySQL master‑slave replication, illustrates how read/write splitting works to alleviate performance bottlenecks, and shares practical test results showing reduced latency on the master and improved overall throughput when directing reads to replica servers.
This article explains ProxySQL's built‑in databases, key configuration tables such as mysql_servers, mysql_users, mysql_replication_hostgroups, mysql_group_replication_hostgroups, and mysql_query_rules, and demonstrates how to set up read/write splitting and automatic failover for MySQL primary‑replica and group replication environments.
This tutorial explains two approaches to achieve MySQL read/write splitting—first by manually implementing routing logic in Spring Boot with MyBatis interceptors and dynamic data sources, and second by configuring the MyCat middleware for automatic load balancing, fault‑tolerance, and multi‑node support, complete with code samples and configuration files.
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.
This tutorial explains how to set up two MySQL servers—one as master for writes and one as slave for reads—by configuring replication accounts, binary logging, server IDs, firewall rules, and then demonstrates read/write separation using a lightweight PHP framework.
