BestHub
Sign in
Tagged articles
14 articles
Page 1 of 1
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 13, 2026 · Databases

Enforcing Client IP‑Based Access Control in MySQL InnoDB Cluster via Router

This article explains how to overcome MySQL InnoDB Cluster’s IP‑address loss and lack of Proxy Protocol by injecting real client IPs through MySQL Router connection attributes, configuring init_connect, creating a monitoring database and stored procedure, and testing access control for specific user‑IP ranges.

Database SecurityInnoDB ClusterRouter
0 likes · 8 min read
Enforcing Client IP‑Based Access Control in MySQL InnoDB Cluster via Router
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
Sep 4, 2023 · Databases

Observability of MySQL 8 Replication Using Performance Schema and Sys Schema Views

The article explains how MySQL 8 enhances replication observability by exposing detailed metrics through Performance Schema tables and sys schema views, providing DBAs with richer information such as per‑channel lag, worker thread states, and full replication status beyond the traditional SHOW REPLICA STATUS output.

InnoDB ClusterPerformance SchemaReplication
0 likes · 14 min read
Observability of MySQL 8 Replication Using Performance Schema and Sys Schema Views
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
dbaplus Community
dbaplus Community
Feb 17, 2021 · Databases

Choosing the Right MySQL HA Architecture: From Replication to InnoDB Cluster

This article reviews MySQL's evolution of high‑availability solutions—from classic master‑slave replication to InnoDB Cluster and InnoDB Replica Set—explaining each component, their features, deployment steps, and how to select the appropriate architecture based on business requirements such as RTO, RPO, and regional scope.

Database ArchitectureHA DesignInnoDB Cluster
0 likes · 10 min read
Choosing the Right MySQL HA Architecture: From Replication to InnoDB Cluster
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 20, 2020 · Databases

InnoDB Cluster Built-in Functions: A Practical Guide for MySQL Group Replication Management

This tutorial walks through the test environment and demonstrates how InnoDB Cluster's built‑in functions—such as get_cluster, describe, list_routers, set_option, options, set_instance_option, set_primary_instance, switch_to_multi_primary_mode, switch_to_single_primary_mode, status, and dissolve—simplify the deployment, monitoring, and administration of MySQL group replication, complete with code snippets and visual results.

Group ReplicationInnoDB ClusterPython
0 likes · 10 min read
InnoDB Cluster Built-in Functions: A Practical Guide for MySQL Group Replication Management
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
Java High-Performance Architecture
Java High-Performance Architecture
Apr 15, 2017 · Databases

Unlocking MySQL InnoDB Cluster: Full-Stack High Availability Explained

This article introduces MySQL's newly released InnoDB Cluster GA version, outlines its three core components—Group Replication‑enabled servers, MySQL Shell with AdminAPI, and MySQL Router—and explains how they together provide fault‑tolerant, automatically failover‑capable, and scalable high‑availability database solutions.

Group ReplicationInnoDB Clustermysql
0 likes · 3 min read
Unlocking MySQL InnoDB Cluster: Full-Stack High Availability Explained