Restarting MYSQL Instances and Servers

 

Environment:-

MySQL Database Instances running in two separate Windows Servers namely PROD (172.21.50.162) and DR (10.218.86.8). They have been setup as Source (PROD) and Replica (DR) using the MySQL native replication configuration which are in-sync.

 

Restarting the MYSQL Databases (DR Server).

1. Login to the DR (10.218.86.8) environment.
2. Start the MYSQL workbench
3. Connect to the server using the root user and password.
4. In the SQL Tab run the following command:-

 

Use this command to check the status of the slave server at the moment and verify the following screenshots having the same value.

1. Show slave status;

Using the following command you will stop the replication of the database which will act as a pre-req.

1. stop slave;

Enter the shutdown command to stop the MYSQL services.

1. Shutdown

Once the command is completed successfully verify the services are stopped from ‘services.msc’

                                                        Also please confirm that ‘Startup Type’ is set to manual.

 

5. Now restart the Windows server for security updates.

Note:-

Do NOT start the DR MYSQL services at this stage.

 

Restarting the MYSQL Databases (Production Server).

1. Login to the Production (172.21.50.162) environment.
2. Start the MYSQL workbench
3. Connect to the server using the root user and password.
4. In the SQL Tab run the following commands:-

 

Use this command to check the status of the master server at the moment and also please note down the master status within a notepad.

1. Show master status;

Enter the shutdown command to stop the MYSQL services.

1. Shutdown

Once the command get’s completed successfully verify the services are stopped from ‘services.msc’

           Also please confirm that ‘Startup Type’ is set to manual.

 

5. Now restart the Windows server for security updates.

 

6. Start the MYSQL services using ‘services.msc’.
7. Once started take again the master status using the following command and note down the output again.

 

1. Show master status.

 

Starting the DR server services back online.

1. Login to the DR (10.218.86.8) environment.
2. Navigate to ‘services.msc’ and start the slave database manually.

 

3. Start the MYSQL workbench
4. Connect to the server using the root user and password.
5. In the SQL Tab run the following command:-

 

Use this command to check the status of the slave server at the moment and verify the following screenshots having the same value.

1. Show slave status;