BestHub
Sign in
Tagged articles
7 articles
Page 1 of 1
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 31, 2025 · Databases

Smarter Query Routing with MySQL Routing Guidelines

The article explains how MySQL Shell and MySQL Router 9.2 introduce Routing Guidelines, a declarative, context‑aware query routing feature that lets administrators define fine‑grained rules based on server roles, session attributes, and network information to improve latency, load‑balancing, and fault‑tolerance in complex MySQL topologies.

AdminAPIDatabase ArchitectureMySQL Router
0 likes · 14 min read
Smarter Query Routing with MySQL Routing Guidelines
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 Router
0 likes · 6 min read
How MySQL 8.2 Router Enables Seamless Read/Write Splitting
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 28, 2023 · Databases

MySQL InnoDB Cluster Read Replicas: Adding, Configuring, and Managing Read‑Only Nodes

This article explains how MySQL InnoDB Cluster 8.1 introduces read‑only replica instances, shows step‑by‑step commands to create and configure them, describes their failover behavior, routing options with MySQL Router, health‑check isolation, replication‑lag handling, and how to hide replicas from traffic.

InnoDB ClusterMySQL RouterReplication
0 likes · 17 min read
MySQL InnoDB Cluster Read Replicas: Adding, Configuring, and Managing Read‑Only Nodes
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 4, 2022 · Databases

Analysis of MySQL Router “Too Many Connections” Error in Versions 8.0.29/8.0.30 and Work‑around

The article investigates why MySQL Router 8.0.29/8.0.30 reports “ERROR 1040 (HY000): Too many connections to MySQL Router” even when the backend MySQL server has only a few connections, reproduces the issue, analyzes packet traces, and concludes that the problem exists in those versions but not in 8.0.28 or 8.0.21, likely due to a new connection‑pooling feature.

Connection PoolingMySQL RouterTCP connection
0 likes · 7 min read
Analysis of MySQL Router “Too Many Connections” Error in Versions 8.0.29/8.0.30 and Work‑around
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 24, 2020 · Databases

How to Build and Manage MySQL InnoDB Replica Sets with MySQL Shell & Router

This guide walks through preparing the environment, configuring MySQL instances, creating an InnoDB ReplicaSet using MySQL Shell, adding replicas, setting up MySQL Router for read/write splitting, testing connections, and performing common management tasks such as promoting a primary and removing or re‑adding nodes.

Database AdministrationInnoDB ReplicaSetMySQL Router
0 likes · 12 min read
How to Build and Manage MySQL InnoDB Replica Sets with MySQL Shell & Router
Java High-Performance Architecture
Java High-Performance Architecture
Apr 25, 2017 · Databases

How to Build a Multi‑Node MySQL InnoDB Cluster from Scratch

This step‑by‑step guide explains how to set up a high‑availability MySQL InnoDB Cluster across four Linux servers, covering sandbox testing, installing MySQL, MySQL Shell, and MySQL Router, configuring each node, creating the cluster, adding instances, and connecting clients via the router.

InnoDB ClusterMySQL RouterMySQL Shell
0 likes · 10 min read
How to Build a Multi‑Node MySQL InnoDB Cluster from Scratch