• Alfranio Correia's avatar
    BUG#11809016 - NO WAY TO DISCOVER AN INSTANCE IS NO LONGER A SLAVE FOLLOWING MYSQL BUG#28796 · e94de17f
    Alfranio Correia authored
    Before BUG#28796, an empty host was used to identify that an instance was no
    longer a slave. However, BUG#28796 changed this behavior and one cannot set
    an empty host. Besides, a RESET SLAVE only cleans up information on the next
    event to retrieve from the master, disables ssl and resets heartbeat period.
    So a call to SHOW SLAVE STATUS after issuing a RESET SLAVE still returns some
    valid information, such as host, port, user and password.
    
    To fix this problem, we have introduced the command RESET SLAVE ALL that does
    what a regular RESET SLAVE does and also clears host, port, user and password
    information thus allowing users to identify when an instance is no longer a
    slave.
    e94de17f
rpl_reset_slave.test 3.01 KB