Aikesheng Open Source Community

Jul 10, 2023 · Databases

Why SHOW SLAVE HOSTS Returns the Master’s IP Instead of the Slave’s IP in MySQL Replication

This article explains why MySQL’s show slave hosts command on a master displays the master’s own IP instead of the replica’s, by examining the report_host parameter, deprecated syntax, and configuration copying practices, and provides steps to reproduce and resolve the issue.