Freaks City

Standard Operational Inspections Storage capacity is a critical focus during proactive inspections. While standard alerts might trigger at 80% utilization, inspections should flag instances exceeding 70%. This buffer ensures there is enough capacity to handle data growth over extended holidays, preventing emergency interventions during off-hour ...

Prerequisites: Three servers, MySQL 5.7-glibc installation, master-slave configuration using GTID mode. MySQL Installation Prepare installation package Download MySQL from: https://pan.baidu.com/s/14w-oNT-oeTUujhFAnqjkSAExtract code: g8tk [root@db-node1 install]# ll mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz -rw-r--r-- 1 root root 661214270 ...

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 ...

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 ...

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 ...