Upgrading Scheduler MySQL database to MySQL 8.0

Products

• VMware Tanzu MySQL

Issue/Introduction

Scheduler v2.0+ contains Spring Boot v3.1.5 and thus requires a MySQL v8.0 database. See release notes for more info on this breaking change. This procedure will show you how to update your existing Scheduler database to MySQL v8.0.

We will first need to identify the plan name of the database source being used by Scheduler. Using Ops Manager, navigate to Scheduler > Scheduler Configuration > Database Source > Plan Name. In this example, we can see that Scheduler is using the “db-medium” Plan Name.

Next, using the Plan Name found in the previous step, we will find the MySQL plan that corresponds to this Plan Name. Using Ops Manager, navigate to Ops Manager > MySQL > Settings > Plan. In this example, we can see that the “db-medium” Plan Name corresponds to Plan 2.

To update this plan to use a MySQL v8.0 database, use the MySQL Default Version dropdown to select MySQL 8.0

Apply changes will need to be run on the MySQL and Scheduler tile. Note that all Post-Deploy Errands must be enabled to migrate from a MySQL for PCF v1.x database to VMware Tanzu SQL with MySQL for VMs v2.x database. These settings are in the Scheduler Errands pane of the Scheduler tile.

Resolution

Following the steps in this kb will update your existing Scheduler database to MySQL v8.0.