Promoting a slave to a master in a single master, multiple slave environment

[Ravi Malghan]

Hi: I have 3 databases in a master and 2 slave setup. I would like to shutdown master and promote one of the slaves to be the master. I have reviewed multiple sites. Instructions vary slightly depending on when the document was created. Was hoping someone can review my steps and let me know if I am missing something.

I have mysql 5.7.22

1. Shutdown database M
2. On S1 and S2, run

 STOP SLAVE IO_THREAD;

3. SHOW PROCESSLIST on S1 and S2 should say "Slave has read all relay log; waiting for more update"
4. On S1

 STOP SLAVE; 
 RESET MASTER;

5. On S2

 STOP SLAVE; 
 CHANGE MASTER TO MASTER_HOST=S2' MASTER_USER=’slave’, MASTER_PASSWORD=......'; 
 RESET SLAVE; 
 START SLAVE;