How to perform a manual backup of mysql service instance to test the automatic backups

Products

• VMware Tanzu Application Service

Issue/Introduction

After making a configuration change to update the blob store username and private key for automated mysql backups using SCP, how to test and verify mysql service backup manually?

Environment

Tanzu Mysql Tile

Resolution

Here are the steps to perform a manual backup mysql service instance:

 

1.  You need to install the adbr plug-in, run:

# cf install-plugin -r CF-Community "ApplicationDataBackupRestore"

2.  Perform a manual back up your service instance by running:

# cf adbr backup <mysql-service-instance-name>

3.  View the status of the backup process by running:

# cf adbr get-status <mysql-service-instance-name>

 

Optional steps to make sure the mysql service instance backup is successful:

 

1.  Bosh ssh into mysql service instance vm

2.  Check the /var/vcap/sys/log/adbr-agent log to confirm the backup completed with no error.