Tagged articles
InnoDB Cluster
14 articles · Page 1 of 1
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 ClusterMySQL
0 likes · 8 min read

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.
Fault RecoveryHigh AvailabilityInnoDB Cluster
0 likes · 26 min read

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

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

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.
High AvailabilityInnoDB ClusterMySQL
0 likes · 17 min read

This article demonstrates how to use MySQL Shell's DBA component to deploy multiple MySQL sandbox instances of different versions, customize their deployment directories, and configure instance parameters through command‑line options and MySQL configuration files.
ConfigurationDBAInnoDB Cluster
0 likes · 8 min read

This article explains the components of MySQL InnoDB Cluster, introduces the InnoDB Cluster Set (MICS) for disaster‑recovery, outlines its limitations, and provides a step‑by‑step demonstration with code on how to create, monitor, and fail over a MICS deployment.
ClusterSetHigh AvailabilityInnoDB Cluster
0 likes · 10 min read

This article provides a detailed, online, in‑place upgrade procedure for MySQL InnoDB Cluster (MGR) from version 5.7.25 single‑primary mode to version 8.0.26, covering preparation, backup, node‑by‑node upgrade, configuration changes, and communication‑protocol updates.
Database MigrationGroup ReplicationInnoDB Cluster
0 likes · 7 min read

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

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

This tutorial demonstrates how to replace the traditional VIP‑based MySQL Router deployment with DNS SRV and Consul service discovery, enabling automatic failover and load balancing for MySQL InnoDB Cluster using supported MySQL Connectors and a Python client.
DNS SRVInnoDB ClusterMySQL
0 likes · 7 min read

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.
Database ClusteringInnoDB ClusterMySQL
0 likes · 10 min read

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

This guide walks through installing MySQL Shell and Router, deploying three local MySQL instances, creating an InnoDB cluster, adding the instances, configuring MySQL Router, and testing failover to demonstrate a simplified high‑availability setup.
High AvailabilityInnoDB ClusterMySQL
0 likes · 7 min read
