BestHub
Sign in
Tagged articles
45 articles
Page 1 of 1
Machine Learning Algorithms & Natural Language Processing
Machine Learning Algorithms & Natural Language Processing
Mar 24, 2026 · Artificial Intelligence

A Comprehensive Guide to Major Attention Mechanisms: From MHA and GQA to MLA, Sparse and Hybrid Architectures

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.

Hybrid ArchitectureLLMMHA
0 likes · 29 min read
A Comprehensive Guide to Major Attention Mechanisms: From MHA and GQA to MLA, Sparse and Hybrid Architectures
Raymond Ops
Raymond Ops
Oct 27, 2025 · Databases

Choosing the Right MySQL HA Solution: MHA, Percona XtraDB Cluster, and Galera

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
Choosing the Right MySQL HA Solution: MHA, Percona XtraDB Cluster, and Galera
Liangxu Linux
Liangxu Linux
Jun 5, 2025 · Databases

Choosing the Right MySQL HA Solution: MHA, Percona XtraDB Cluster, and Galera

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 ReplicationGaleraMHA
0 likes · 10 min read
Choosing the Right MySQL HA Solution: MHA, Percona XtraDB Cluster, and Galera
MaGe Linux Operations
MaGe Linux Operations
May 25, 2025 · Databases

Choosing the Right MySQL HA Solution: MHA, PXC or Galera Cluster

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.

GaleraMHAPercona XtraDB Cluster
0 likes · 10 min read
Choosing the Right MySQL HA Solution: MHA, PXC or Galera Cluster
IT Architects Alliance
IT Architects Alliance
Sep 4, 2022 · Databases

Mastering MySQL: From Replication to High Availability and Sharding Strategies

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 ArchitectureMGRMHA
0 likes · 13 min read
Mastering MySQL: From Replication to High Availability and Sharding Strategies
HomeTech
HomeTech
Apr 6, 2022 · Databases

MySQL High Availability Architecture and Practices at AutoHome

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.

KubernetesMGRMHA
0 likes · 11 min read
MySQL High Availability Architecture and Practices at AutoHome
dbaplus Community
dbaplus Community
Mar 1, 2022 · Databases

MHA Re-Edition: Modern MySQL HA with GTID Failover and Auto Switch

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.

GTIDMHAdatabase
0 likes · 11 min read
MHA Re-Edition: Modern MySQL HA with GTID Failover and Auto Switch
Practical DevOps Architecture
Practical DevOps Architecture
Dec 5, 2021 · Databases

Deploying MHA for MySQL High Availability – Part 1

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.

LinuxMHAdatabase
0 likes · 6 min read
Deploying MHA for MySQL High Availability – Part 1
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 19, 2021 · Databases

Understanding MHA Master Selection Logic and Cross‑Version Switching Issues

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-VersionMHAmaster selection
0 likes · 12 min read
Understanding MHA Master Selection Logic and Cross‑Version Switching Issues
Qingyun Technology Community
Qingyun Technology Community
Jun 7, 2021 · Databases

Why Xenon Is the Modern MySQL HA Alternative to MHA

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.

GTIDMHARaft
0 likes · 7 min read
Why Xenon Is the Modern MySQL HA Alternative to MHA
Aikesheng Open Source Community
Aikesheng Open Source Community
May 8, 2021 · Databases

Analysis of MHA Master Crash Failover Process and Source Code

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.

MHAmaster crashmysql
0 likes · 9 min read
Analysis of MHA Master Crash Failover Process and Source Code
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 22, 2021 · Databases

Understanding and Testing the MHA masterha_secondary_check Script for MySQL Network Fault Tolerance

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.

MHAmasterha_secondary_checkmysql
0 likes · 6 min read
Understanding and Testing the MHA masterha_secondary_check Script for MySQL Network Fault Tolerance
JavaEdge
JavaEdge
Mar 21, 2021 · Databases

From Single MySQL to Cluster: Master‑Slave Replication, High Availability, and Scaling Strategies

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 ReplicationMHAOrchestrator
0 likes · 18 min read
From Single MySQL to Cluster: Master‑Slave Replication, High Availability, and Scaling Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 15, 2021 · Databases

Improving MHA Network Tolerance: Testing ping_interval and secondary_check_script

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.

Database operationsMHANetwork Tolerance
0 likes · 16 min read
Improving MHA Network Tolerance: Testing ping_interval and secondary_check_script
iQIYI Technical Product Team
iQIYI Technical Product Team
Aug 28, 2020 · Databases

iQIYI's Custom MySQL High‑Availability Architecture

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 ArchitectureMHAReplication
0 likes · 10 min read
iQIYI's Custom MySQL High‑Availability Architecture
Architect's Alchemy Furnace
Architect's Alchemy Furnace
Jul 6, 2020 · Databases

Mastering MySQL HA: Step‑by‑Step MHA Setup and Failover Guide

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.

Database operationsGTIDMHA
0 likes · 24 min read
Mastering MySQL HA: Step‑by‑Step MHA Setup and Failover Guide
58 Tech
58 Tech
Jul 8, 2019 · Databases

Design and Implementation of WMHA: A Modified MySQL High‑Availability Solution

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.

Database operationsMHAWMHA
0 likes · 9 min read
Design and Implementation of WMHA: A Modified MySQL High‑Availability Solution
Ctrip Technology
Ctrip Technology
Nov 8, 2018 · Databases

Evolution of Ctrip's Database High‑Availability and Disaster‑Recovery Architecture (1999‑2018)

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
Evolution of Ctrip's Database High‑Availability and Disaster‑Recovery Architecture (1999‑2018)
ITPUB
ITPUB
Jul 15, 2018 · Databases

How Meituan Dianping Evolved MySQL HA: From MMM to MHA+Zebra and Beyond

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.

Distributed SystemsMHAZebra
0 likes · 12 min read
How Meituan Dianping Evolved MySQL HA: From MMM to MHA+Zebra and Beyond
Qunar Tech Salon
Qunar Tech Salon
Aug 17, 2017 · Databases

Evolution of Meituan-Dianping MySQL High‑Availability Architecture: From MMM to MHA+Zebra and Beyond

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 ReplicationDistributed SystemsMHA
0 likes · 11 min read
Evolution of Meituan-Dianping MySQL High‑Availability Architecture: From MMM to MHA+Zebra and Beyond
dbaplus Community
dbaplus Community
Aug 14, 2017 · Databases

How Meituan‑Dianping Evolved MySQL HA: From MMM to MHA+Zebra and Beyond

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 ArchitectureDistributed SystemsMHA
0 likes · 13 min read
How Meituan‑Dianping Evolved MySQL HA: From MMM to MHA+Zebra and Beyond
Meituan Technology Team
Meituan Technology Team
Jun 30, 2017 · Operations

How Meituan‑Dianping Evolved MySQL HA from MMM to MHA‑Zebra and Beyond

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 ArchitectureDistributed SystemsMHA
0 likes · 12 min read
How Meituan‑Dianping Evolved MySQL HA from MMM to MHA‑Zebra and Beyond
MaGe Linux Operations
MaGe Linux Operations
Dec 26, 2016 · Databases

Mastering MySQL High Availability with MHA: Step‑By‑Step Setup Guide

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 ReplicationLinuxMHA
0 likes · 8 min read
Mastering MySQL High Availability with MHA: Step‑By‑Step Setup Guide
dbaplus Community
dbaplus Community
Dec 12, 2016 · Databases

Mastering MySQL GTID: From Basics to Advanced Replication and Recovery

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.

BackupCrash SafetyGTID
0 likes · 24 min read
Mastering MySQL GTID: From Basics to Advanced Replication and Recovery
ITPUB
ITPUB
Sep 2, 2016 · Databases

Comparing Popular MySQL Cluster Architectures: MHA, MySQL Cluster, and Cobar

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
Comparing Popular MySQL Cluster Architectures: MHA, MySQL Cluster, and Cobar
ITPUB
ITPUB
Aug 23, 2016 · Databases

Designing a Zookeeper‑MHA MySQL High‑Availability Architecture: Key Insights

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 ArchitectureMHA
0 likes · 14 min read
Designing a Zookeeper‑MHA MySQL High‑Availability Architecture: Key Insights
ITPUB
ITPUB
Aug 16, 2016 · Databases

Achieving Seamless MySQL HA with Pacemaker and MHA: Lessons from DTCC 2016

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.

MHAOperationsPacemaker
0 likes · 16 min read
Achieving Seamless MySQL HA with Pacemaker and MHA: Lessons from DTCC 2016
dbaplus Community
dbaplus Community
Aug 9, 2016 · Databases

Step-by-Step Guide to Deploying MHA for MySQL High Availability

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.

Database AdministrationLinuxMHA
0 likes · 6 min read
Step-by-Step Guide to Deploying MHA for MySQL High Availability
MaGe Linux Operations
MaGe Linux Operations
Aug 1, 2016 · Operations

Mastering MHA Core Parameters: Complete Guide to MySQL HA Configuration

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.

ConfigurationMHAOperations
0 likes · 11 min read
Mastering MHA Core Parameters: Complete Guide to MySQL HA Configuration
dbaplus Community
dbaplus Community
Jul 21, 2016 · Databases

How MHA Delivers Fast, Zero‑Data‑Loss MySQL High Availability

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.

MHAfailoverhigh availability
0 likes · 9 min read
How MHA Delivers Fast, Zero‑Data‑Loss MySQL High Availability
dbaplus Community
dbaplus Community
Dec 3, 2015 · Cloud Native

Build a MySQL MHA Cluster with Docker: Complete Step‑by‑Step Guide

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.

Cloud NativeClusterDevOps
0 likes · 14 min read
Build a MySQL MHA Cluster with Docker: Complete Step‑by‑Step Guide
Architect
Architect
Sep 14, 2015 · Databases

MySQL High Availability Solutions: Selection Guide

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.

GaleraMHAReplication
0 likes · 9 min read
MySQL High Availability Solutions: Selection Guide