Tanzu MySQL Multi-Site Switchover Fails Due to Cross-Foundation Plan Name Validation

Products

• VMware Tanzu for MySQL

Issue/Introduction

While attempting a Tanzu MySQL Multi-Site switchover using the cf mysql-tools plugin, encountered a validation failure before the switchover operation begins.

cf mysql-tools switchover \
  --primary-target primary \
  --primary-instance ha-primary \
  --secondary-target secondary \
  --secondary-instance ha-secondary \
  -f

 

The plug-in output includes status lines that show checkpoints for the various configuration steps .

 

When successful, leader will become secondary and follower will become primary. Do you want to continue? [yN]: y
[primary] Checking whether instance 'ha-primary' exists
[secondary] Checking whether plan 'multisite-large' exists
[secondary] Plan 'multisite-large' does not exist

Environment

Tanzu for MySQL on Tanzu Platform

Cause

This is a plugin limitation as per the source code and it is a known design constraint of the cf mysql-tools plugin.

The cf mysql-tools plugin's SwitchoverReplication() logic performs a cross-foundation check to verify that the leaderPlanName exists on the secondary target and the followerPlanName exists on the primary target. 

 

Resolution

Trigger a switchover manually with different plan names by following the documentation:

https://techdocs.broadcom.com/us/en/vmware-tanzu/platform/tanzu-mysql-tanzu-platform/10-4/mysql-tp/multi-site-trigger-failover.html