Tagged articles
MHA
48 articles · Page 1 of 1
This article dissects MHA, MQA, GQA, and FlashAttention across five analytical layers, revealing how structural optimizations (MQA/GQA) reduce KV Cache memory by sharing keys/values, while FlashAttention tackles memory bandwidth via tiled computation and online softmax, and why modern LLMs combine GQA with FlashAttention for 2-4x speedups without accuracy loss.
Attention MechanismFlashAttentionGQA
0 likes · 11 min read

This comprehensive guide covers MySQL read-write separation from fundamentals to production implementation, including master-slave replication principles, replication lag causes and three enterprise-grade solutions, one-master-multi-slave architecture patterns, MHA automatic failover, Sharding-JDBC middleware configuration, and five critical production pitfalls to avoid.
Database ArchitectureHigh AvailabilityMHA
0 likes · 10 min read

This article reviews and compares the most important attention variants used in modern large language models—including multi‑head attention, grouped‑query attention, multi‑head latent attention, sparse and sliding‑window attention, gated attention, and hybrid designs—detailing their motivations, memory trade‑offs, example architectures, and experimental findings.
GQALLMMHA
0 likes · 29 min read

This guide explains how to achieve uninterrupted MySQL service by using semi‑sync replication, configuring MHA for automatic failover, deploying Orchestrator for topology management, and applying VIP‑based scripts and GTID settings to guarantee zero data loss during master switches.
FailoverGTIDHigh Availability
0 likes · 10 min read

This comprehensive guide walks you through the reasons for MySQL master‑slave replication, deep technical concepts, step‑by‑step deployment, configuration tuning, monitoring, and real‑world troubleshooting to achieve a high‑availability database cluster that can survive production outages.
MHAProxySQLReplication
0 likes · 25 min read

This article examines three MySQL high‑availability solutions—MHA, Percona XtraDB Cluster, and Galera Cluster—detailing their architectures, advantages, limitations, deployment scenarios, and best‑practice recommendations to help engineers choose the most suitable approach for continuous, reliable database operations.
Cluster DeploymentDatabase ReplicationGalera
0 likes · 11 min read

An in‑depth comparison of three popular MySQL high‑availability architectures—MHA, Percona XtraDB Cluster (PXC), and Galera Cluster—covers their principles, architectures, strengths, limitations, deployment scenarios, and best‑practice recommendations to help you select the optimal solution for your production environment.
Database ReplicationGaleraHigh Availability
0 likes · 10 min read

An in‑depth guide compares three MySQL high‑availability solutions—MHA, Percona XtraDB Cluster, and Galera Cluster—detailing their architectures, pros and cons, deployment scenarios, and best‑practice recommendations to help engineers choose the optimal HA strategy for their workloads.
Database ClusteringGaleraMHA
0 likes · 10 min read

The article analyzes why a sed command freezes while modifying a MySQL MHA installation script on a CentOS 6 system, identifies the charset conversion issue caused by GBK locale and missing spaces after comment symbols, and provides a step‑by‑step debugging and fix procedure.
CharsetLinuxMHA
0 likes · 6 min read

This article examines why single-node databases no longer meet modern internet workloads, explores MySQL replication models (master‑slave, asynchronous, semi‑synchronous, group replication), discusses high‑availability solutions such as MHA, MGR and Orchestrator, and outlines vertical and horizontal sharding techniques along with their trade‑offs.
Database ArchitectureHigh AvailabilityMGR
0 likes · 13 min read

This article explains MySQL high‑availability concepts, defines HA, RPO and RTO, outlines common HA architectures such as master‑slave+VIP, MHA and MGR+Proxy, and details AutoHome's evolution from simple master‑slave setups to a container‑based MGR solution with automated failover and monitoring platforms.
High AvailabilityKubernetesMGR
0 likes · 11 min read

The MHA Re-Edition tool revives the discontinued MHA manager for MySQL, adding GTID‑based failover, password‑only SSH authentication, lightweight binaries, VIP migration, WeChat alerts, remote‑card reboot, and detailed configuration options, with step‑by‑step deployment instructions and sample app1.cnf parameters for high‑availability clusters.
FailoverGTIDHigh Availability
0 likes · 11 min read

The article explains why MHA’s default long‑connection ping cannot detect a hung MySQL instance, introduces three configurable ping_type options (select, connect, insert), shows how to modify the configuration and test the behavior with Perl code and shell scripts, and details the internal health‑check workflow.
FailoverMHAMySQL
0 likes · 12 min read

This guide walks through the step‑by‑step deployment of MHA on a MySQL cluster, covering package installation on all nodes, copying and installing the MHA RPMs, creating the required MySQL user, configuring MHA, testing SSH connectivity, and reviewing the failover script.
High AvailabilityLinuxMHA
0 likes · 6 min read

The article explains how MHA handles a crashed MySQL master by preserving binary logs, selecting the most up‑to‑date slave, applying relay logs, promoting a slave to master, and provides detailed commands for creating replication users and configuring master‑slave replication.
FailoverMHAMaster‑Slave
0 likes · 3 min read

This article analyses why MHA reports a "bad new master" error during master‑slave switches, explains the internal candidate‑master and bad‑master selection algorithms, demonstrates how MySQL version differences affect cross‑version promotion through test scenarios, and provides detailed code excerpts to illustrate the decision process.
Cross-VersionMHAMySQL
0 likes · 12 min read

This article provides a comprehensive, hands‑on guide to building a MySQL master‑slave cluster with GTID replication and configuring MHA for automatic failover, covering environment preparation, password‑less SSH, MySQL settings, MHA installation, custom scripts, testing, and the key advantages of the solution.
GTIDHigh AvailabilityLinux
0 likes · 25 min read

This article compares the legacy MHA solution with the modern open‑source Xenon tool, explaining Xenon's Raft‑based architecture, automatic leader election, GTID integration, and enterprise‑grade features that make it a superior high‑availability option for MySQL deployments.
Database ClusteringGTIDHigh Availability
0 likes · 7 min read

This article examines the MHA open‑source MySQL high‑availability solution, detailing the master‑crash failover workflow, source‑code analysis, configuration checks, binlog handling, new‑master selection, and slave recovery, and provides a concise step‑by‑step checklist for practitioners.
MHAMySQLmaster crash
0 likes · 9 min read

This article explains the purpose, usage, and return codes of the MHA masterha_secondary_check Perl script, demonstrates how to simulate network failures with iptables, and presents a series of tests that verify the script’s ability to detect master reachability and handle various error conditions.
MHAMySQLmasterha_secondary_check
0 likes · 6 min read

This article explains why growing MySQL workloads require moving from a single instance to a clustered architecture, details the mechanics of master‑slave replication, asynchronous, semi‑synchronous and group replication, and evaluates various high‑availability solutions and read‑write splitting techniques.
Group ReplicationHigh AvailabilityMHA
0 likes · 18 min read

This article analyzes how adjusting the MHA ping_interval and enabling secondary_check_script can increase MySQL high‑availability cluster tolerance to network packet loss and corruption, presenting test setups, parameter configurations, log observations, and conclusions on their impact on failover behavior.
High AvailabilityMHAMySQL
0 likes · 16 min read

iQIYI’s custom MySQL HA solution replaces the single‑point‑failure MHA manager with a Raft‑based trio of HA Masters and HA Agents that continuously monitor instances, automatically perform same‑DC, cross‑DC, or cross‑region failovers, reconcile diff binlogs, ensure data consistency, and integrate with CMDB, tracing and chaos‑engineering platforms.
HA ArchitectureHigh AvailabilityMHA
0 likes · 10 min read

This article walks through preparing a four‑node MySQL environment, configuring password‑less SSH, setting up master‑slave replication with GTID, installing and configuring MHA, testing connectivity, running the manager, verifying automatic failover, and highlighting the key advantages of using MHA for high availability.
GTIDHigh AvailabilityMHA
0 likes · 24 min read

This article explains the need for high‑availability MySQL services, critiques the original in‑house HA approach, and details how the mature MHA framework was extended into WMHA with added VIP monitoring, enhanced failover procedures, richer notifications, and a reorganized deployment structure to improve reliability and reduce DBA intervention.
FailoverHigh AvailabilityMHA
0 likes · 9 min read

This article explains the importance of high availability in distributed systems, defines MySQL high‑availability concepts such as replication, describes several HA architectures including MySQL Cluster, MMM, and MHA, and discusses design principles for building resilient database services.
Database ArchitectureMHAMMM
0 likes · 8 min read

This article chronicles Ctrip's database high‑availability and disaster‑recovery evolution—from simple SQL Server mirroring in the early years, through SAN‑based clustering and AlwaysOn, to the adoption of MySQL, Redis, MHA, and a one‑click DR automation tool—highlighting architectural decisions, challenges, and operational lessons learned.
AlwaysOnDatabase HAMHA
0 likes · 10 min read

The article describes how a DBA team at Ele.me transformed manual database management into a fully automated, platform‑driven operation covering monitoring, alarm handling, MHA automation, resource pooling, large‑scale migration, SQL review, and multi‑active DDL release using Go‑based tools and custom workflows.
DBA toolsDatabase AutomationGo
0 likes · 20 min read


ITPUBJul 15, 2018 · Databases
This article traces Meituan Dianping's MySQL high‑availability journey, detailing the legacy MMM system, its migration to MHA, integration with Zebra and Proxy middleware, and future architectural ideas such as distributed agents, semi‑sync replication, and MySQL Group Replication.
High AvailabilityMHAMySQL
0 likes · 12 min read

This article provides a detailed comparison of Oracle RAC and MySQL MHA high‑availability solutions, covering architecture overviews, network requirements, failover methods, configuration examples, disaster‑recovery options, performance trade‑offs, and practical considerations for choosing the right approach.
High AvailabilityMHAMySQL
0 likes · 16 min read

This article reviews the evolution of Meituan‑Dianping's MySQL high‑availability architecture over recent years, detailing the transition from the MMM replication manager to MHA, the integration of Zebra and Proxy middleware, and future design considerations such as distributed agents, semi‑synchronous replication, and MySQL Group Replication.
Database ReplicationMHAMySQL
0 likes · 11 min read

This article traces Meituan‑Dianping's MySQL high‑availability journey, detailing the legacy MMM system, the transition to MHA, integrations with Zebra and Proxy middleware, current challenges, and future designs such as distributed agents, semi‑sync replication, and MySQL Group Replication.
Database ArchitectureHigh AvailabilityMHA
0 likes · 13 min read

This article traces Meituan‑Dianping's MySQL high‑availability journey from the early MMM replication manager to the modern MHA‑Zebra and MHA‑Proxy solutions, compares each architecture, highlights their shortcomings, and outlines future directions such as distributed agents, semi‑sync replication, and Paxos‑based MySQL Group Replication.
Database ArchitectureHigh AvailabilityMHA
0 likes · 12 min read

This article presents a comprehensive overview of MySQL high‑availability solutions, covering classic HA architectures, synchronization tools such as MHA, MMM, HA‑JDBC, Galera and Group Replication, and shares NetEase's practical implementations using distributed databases and keepalive‑based failover.
Distributed DatabaseGaleraGroup Replication
0 likes · 16 min read

This article introduces MHA (Master High Availability) for MySQL, explains its architecture, outlines required hardware and software configurations, provides detailed commands to set up master and slave nodes, create configuration files, and demonstrates how to start and verify the high‑availability cluster.
Database ReplicationFailoverHigh Availability
0 likes · 8 min read

This comprehensive guide explains MySQL GTID fundamentals, its syntax, how to view and generate GTIDs, configure GTID‑based replication, troubleshoot replication errors, integrate GTID with backup/restore, MHA failover, and ensure crash‑safe slaves while discussing performance trade‑offs.
Crash SafetyGTIDMHA
0 likes · 24 min read


ITPUBSep 2, 2016 · Databases
This article reviews three mainstream MySQL clustering solutions—MHA master‑slave replication, Oracle's MySQL Cluster, and Alibaba's open‑source Cobar—detailing their architectures, advantages, drawbacks, and practical deployment considerations for high availability and scalability.
ClusterCobarDatabase Architecture
0 likes · 7 min read


ITPUBAug 23, 2016 · Databases
This talk explains how Lianjia redesigned its MySQL high‑availability setup by replacing VIP‑based failover with a Zookeeper‑driven naming service, detailing the original MHA architecture, its shortcomings, the new components, workflow, operational challenges, and a DNS‑based refinement.
DNSDatabase ArchitectureHigh Availability
0 likes · 14 min read

This tutorial walks through setting up a MySQL master‑slave replication cluster, configuring password‑less SSH, installing MHA‑node and MHA‑manager, creating the MHA configuration, validating the setup, and testing automatic failover when the master goes down.
Database ReplicationFailoverHigh Availability
0 likes · 7 min read


ITPUBAug 16, 2016 · Databases
This article details a MySQL high‑availability solution built on Pacemaker, Corosync and MHA, explains why earlier keepalived‑based designs suffered split‑brain issues, and walks through the architecture, quorum handling, resource agents, failover workflow, testing methodology, and practical lessons learned.
Database ClusteringHigh AvailabilityMHA
0 likes · 16 min read

MHA (Master High Availability) ensures MySQL cluster resilience by monitoring the master, automatically promoting the most up‑to‑date slave as a new master during failures, offering fast failover, strong data safety, easy extensibility, and multi‑cluster management, while noting its limitations.
Database FailoverHigh AvailabilityMHA
0 likes · 4 min read

This tutorial walks through preparing a CentOS 6.6 environment, creating MHA users and SSH keys, configuring hosts, installing MHA Node and Manager, verifying configurations, and testing master failover to achieve reliable MySQL high‑availability using MHA.
High AvailabilityLinuxMHA
0 likes · 6 min read

This article provides a detailed walkthrough of MHA's core configuration parameters—including server scopes, connection settings, candidate master rules, failover scripts, and monitoring options—explaining where each setting belongs and how to fine‑tune MySQL high‑availability behavior.
ConfigurationHigh AvailabilityMHA
0 likes · 11 min read

This article explains how MHA provides automated master monitoring, rapid failover within 10‑30 seconds, online master switching, various failover modes, extensible scripts, key commands, and best‑practice workflows to achieve high‑availability MySQL replication without performance impact.
Database ReplicationFailoverHigh Availability
0 likes · 23 min read

This guide walks through MySQL high‑availability architectures, comparing failover solutions like MMM and MHA, detailing MHA installation, configuration, and testing, and exploring MaxScale's read/write splitting, routing strategies, and integration with MHA for seamless failover.
FailoverHigh AvailabilityMHA
0 likes · 11 min read

This article explains MHA’s architecture, failover workflow, comparison with other MySQL HA solutions, and its six key advantages, showing how it can switch masters within seconds while preserving data consistency without altering MySQL settings or adding many servers.
FailoverHigh AvailabilityMHA
0 likes · 9 min read

This article walks through constructing a MySQL MHA high‑availability cluster using Docker, comparing traditional installation with two Docker‑based versions, detailing container setup, configuration steps, Dockerfile composition, pros and cons, and automation scripts for rapid, repeatable deployments.
ClusterDevOpsMHA
0 likes · 14 min read

This article reviews various MySQL high‑availability architectures—including master‑slave replication with keepalived or MHA, Galera‑based clusters, and other approaches—detailing their deployment methods, advantages, limitations, and practical considerations for selecting an appropriate HA solution.
GaleraMHAMySQL
0 likes · 9 min read
