How to manage disk space taken up by MySQL binary logs through VMware Tanzu SQL tile

Products

• VMware Tanzu SQL

Issue/Introduction

The binary logs (mysql-bin) are filling up the persistent disk. This article describes a way to temporarily turn off binary logging, Binary Logs Filling up the Persistent Disk VMware Tanzu SQL (MySQL) [VMs.

This article covers how to manage disk space taken up by MySQL binary logs on a permanent basis through the VMware Tanzu SQL tile. 

 

Environment

Product Version: 2.10

Resolution

There is a new feature in the VMware Tanzu SQL tile to manage disk space taken up by MySQL binary logs.

Updating all service instances

To update all service instances, perform the following steps: 

1. Go to the MySQL Configuration page.

2. Choose Limit binary log disk use to 33% of disk capacity.

3. Click Save, and run an Apply Changes with the Upgrade all On-demand MySQL Service Instances errand selected.

Updating individual service instances

If you wish to apply this solution to individual service instances, perform these steps:

1. Go to the MySQL Configuration page.

2. Select the Limit binary log disk use to 33% of disk capacity option.

3. Click Save, and run an Apply Changes to the tile with all Errands selected except the Upgrade all On-demand MySQL Service Instances and Recreate all On-demand MySQL Service Instances.

To upgrade your service instances, do the following:

1. Confirm that an upgrade is available by running cf services and reviewing the upgrade available column.

$ cf services
Getting services in org acceptance / space dev as admin...
 
name      service   plan     bound apps   last operation     broker         upgrade available
mydb      p-mysql   small                 create succeeded   mysql-broker   yes
otherdb   p-mysql   medium                create succeeded   mysql-broker   no

2. Upgrade the service instance using the --upgrade flag:

$ cf update-service mydb --upgrade
You are about to update mydb.
Warning: This operation may be long running and will block further operations on the service until complete.
Really update service mydb? [yN]: y
OK

For more information about upgrading individual service instances, refer to https://docs.cloudfoundry.org/devguide/services/managing-services.html