Fail-Over Testing Guide

Failover Testing Procedure

  1. Check the current status of the MySQL cluster

    • Check the status of the target group: Ensure that only one MySQL instance is running.

      Create VPC

    • Check accessibility to the Wordpress instance:

      • Access the EC2 service control panel.
      • Copy the public IP address of the Wordpress instance.
      • Open a browser and navigate to http://Public IP/wordpress.
      • Confirm that the Wordpress application is operational.

      Create VPC

      Create VPC

  2. Shut down the MySQL instance and check access to the Wordpress application

    • Shut down the primary MySQL instance.

      Create VPC

    • Check both instances:

      • Ensure both instances fail the health check.

        Create VPC

      • Verify if the alert has been triggered.

        Create VPC

      • Check if the incident has been created and the runbook has been activated.

        Create VPC

      • Verify if the runbook has run successfully.

        Create VPC

    • Check accessibility to Wordpress:

      • If Wordpress is still accessible, the automatic failover to the secondary node has succeeded.

        Create VPC