Tanzu Mysql for VMs changes to internal db version

Products

• VMware Tanzu Platform Core

Issue/Introduction

Since Tanzu Mysql v10.1.0 All service plans now default to MySQL version 8.4 per the release notes https://techdocs.broadcom.com/us/en/vmware-tanzu/platform/tanzu-mysql-tanzu-platform/10-1/mysql-tp/release-notes.html#changes(1),

Since Tanzu Mysql v10.4.0 mysql v5.7 is completely removed for all service plans as specified in release notes https://techdocs.broadcom.com/us/en/vmware-tanzu/platform/tanzu-mysql-tanzu-platform/10-4/mysql-tp/release-notes.html#changes(1) 

Before upgrade of mysql tile it is recommended to check release notes for a tile for breaking changes. 

Environment

Tanzu Mysql 

Resolution

During the upgrade of Mysql tile from v10.1.x to v10.4.x you may run into the error as shown below if your plan has mysql version set at v8.0 

{"name":".properties.plan1_selector.single_node.version_dropdown","type":"dropdown_select","errors":["value is not included in allowed options: [\"8.4\"]"]}

To workaround this issue, manually update the version of mysql used by the plan to be 8.4, save the page and run Apply Changes.