BestHub
Sign in
Tag

InnoDB Cluster

0 views collected around this technical thread.

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
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 27, 2022 · Databases

Deploying Multiple MySQL Instances with MySQL Shell DBA Component

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.

DBADeploymentInnoDB Cluster
0 likes · 8 min read
Deploying Multiple MySQL Instances with MySQL Shell DBA Component
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 20, 2022 · Databases

Building and Using MySQL InnoDB Cluster Set (MICS) for Disaster Recovery

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
Building and Using MySQL InnoDB Cluster Set (MICS) for Disaster Recovery
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 19, 2021 · Databases

Step-by-Step Guide to Upgrading MySQL Group Replication (MGR) from 5.7 to 8.0.26

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.

Group ReplicationInnoDB ClusterMySQL
0 likes · 7 min read
Step-by-Step Guide to Upgrading MySQL Group Replication (MGR) from 5.7 to 8.0.26
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.

Database AdministrationGroup ReplicationInnoDB Cluster
0 likes · 10 min read
InnoDB Cluster Built-in Functions: A Practical Guide for MySQL Group Replication Management
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 12, 2020 · Databases

Using DNS SRV and Consul for MySQL Router Failover and Load Balancing in InnoDB Cluster

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.

ConsulDNS SRVInnoDB Cluster
0 likes · 7 min read
Using DNS SRV and Consul for MySQL Router Failover and Load Balancing in InnoDB Cluster