MHA High Availability Guide
Understanding MHA Failover
MHA (Master High Availability) is a comprehensive solution for achieving high avaliability in MySQL environments. Here's how it works:
Master Monitoring:
MHA uses masterha_manager to start the monitoring process
Pre-checks include SSH connectivity validation and replication health verification
The master node is moni ...
Posted on Mon, 10 Aug 2026 16:15:07 +0000 by rayner75
Advanced MySQL Replication Techniques and MHA Environment Setup
Delayed Replication
Delayed replication introduces a lag in the SQL thread execution after data is written to the relay log. Recommended delay is typically 3-6 hours, depending on operational response time requirements.
Key benefits:
Mitigates physical corruption risks
Standard replication doesn't address logical corruption
Configuration (exe ...
Posted on Fri, 10 Jul 2026 18:03:49 +0000 by The MA
Implementing Read-Write Separation with Atlas and MHA
Atlas is a data access layer solution built on MySQL protocol, developed by the Qihoo 360 Web Platform Department infrastructure team. It enhances the mysql-proxy 0.8.2 foundation with optimizations and additional features. Within Qihoo 360, Atlas manages MySQL workloads handling billions of daily read/write operations.
Key Considerations
Atla ...
Posted on Tue, 19 May 2026 21:36:58 +0000 by whitmard