Setting Up MySQL 5.7 with MHA High Availability Cluster
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 ...
Posted on Wed, 26 Aug 2026 16:56:06 +0000 by cgrenda
Managing MySQL Replication User Password Updates
Reviewing Current Replica Configuration
To begin the process of updating replication credentials, you should first inspect the current configuration stored on the replica server. This can be done by querying the mysql.slave_master_info table to identify the host, user, and existing password metadata.
SELECT
Host,
User_name,
User_ ...
Posted on Sun, 23 Aug 2026 16:10:35 +0000 by lupes