murphe5/test-guide

Scaling Down MySQL Runbook:

Table of Contents

• Prerequisites
• Check the Health of Your Cluster
• Scale down your cluster

Prerequisites

• Before scaling down your MySQL cluster, perform the following actions to ensure the cluster is healthy.:
  • MySQL 1.9 MySQL-diag tool
  • MySQL 1.8
  • MySQL 1.7

Procedure

Triage (Required)

• Complete the required triage for MySQL

Scale down your cluster

• Delete the dummy database. When prompted for a password, provide the password value obtained above.

$ mysql -h FIRST-NODE-IP-ADDRESS -u YOUR-IDENTITY -p -e "drop database verify_healthy;"

• From the PCF Installation Dashboard, click the MySQL for Pivotal Cloud Foundry tile.

• Click the Settings tab.

• Click Resource Config and use the drop-down menu to change the Instances count for MySQL Server to 1.

• Click Save to apply the changes.

Runbooks