BestHub
Sign in
Tagged articles

InnoDB Cluster

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.

Access ControlDatabase SecurityInnoDB Cluster
0 likes · 8 min read
Enforcing Client IP‑Based Access Control in MySQL InnoDB Cluster via Router
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 25, 2025 · Databases

How to Diagnose and Recover MySQL InnoDB Cluster Failures: Real‑World Scenarios

This article walks MySQL DBAs through common MySQL InnoDB Cluster fault scenarios—node restarts, crashes, network partitions, and full‑cluster reboots—providing step‑by‑step commands, status outputs, recovery actions, and impact analysis to ensure high availability and data safety.

Database operationsHigh AvailabilityInnoDB Cluster
0 likes · 26 min read
How to Diagnose and Recover MySQL InnoDB Cluster Failures: Real‑World Scenarios
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
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 ClusterMySQLObservability
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.

DatabaseHigh AvailabilityInnoDB Cluster
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 ClusterMySQL
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 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