BestHub
Sign in
Tagged articles

ProxySQL

11 articles · Page 1 of 1
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
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
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 20, 2022 · Databases

Using ProxySQL Binlog Reader to Monitor MySQL GTID Replication

This article introduces the ProxySQL Binlog Reader component, explains its background in read/write splitting and GTID‑based consistency, demonstrates how to configure MySQL servers, create a dedicated user, start the reader on master and replica, and verify its operation through logs and session information.

Binlog ReaderGTIDMySQL
0 likes · 9 min read
Using ProxySQL Binlog Reader to Monitor MySQL GTID Replication
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 5, 2022 · Databases

Understanding ProxySQL Configuration Tables for MySQL HA (Read/Write Splitting and Failover)

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.

DatabaseProxyHAMySQL
0 likes · 14 min read
Understanding ProxySQL Configuration Tables for MySQL HA (Read/Write Splitting and Failover)
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 22, 2021 · Databases

Configuring ProxySQL with MySQL Replication and Group Replication for Read/Write Splitting and Automatic Failover

This guide demonstrates how to deploy a ProxySQL instance alongside six MySQL servers (three for traditional replication and three for MySQL Group Replication), configure users, set up read/write splitting rules, and enable automatic failover for both replication topologies.

Database HAGroup ReplicationMySQL replication
0 likes · 14 min read
Configuring ProxySQL with MySQL Replication and Group Replication for Read/Write Splitting and Automatic Failover