[BUG] apecloud and mysql does not support switchover ops

[shanshanying]

KubeBlocks: 1.0.0-beta.2

1. create apecloud-mysql cluster
2. apply a switchover ops
3. check ops and found

this cluster component mysql does not support switchover

apiVersion: operations.kubeblocks.io/v1alpha1
kind: OpsRequest
metadata:
  creationTimestamp: "2024-11-18T12:13:00Z"
  finalizers:
  - opsrequest.kubeblocks.io/finalizer
  generation: 1
  labels:
    app.kubernetes.io/instance: acmysql-cluster
    operations.kubeblocks.io/ops-type: Switchover
  name: acmysql-switchover-specify
  namespace: default
  ownerReferences:
  - apiVersion: apps.kubeblocks.io/v1
    kind: Cluster
    name: acmysql-cluster
    uid: 637094a5-82f0-4d1a-a4a1-6c58a0f7c742
  resourceVersion: "1436269"
  uid: fc014dce-631c-4bda-89c6-6c449f41e2fd
spec:
  clusterName: acmysql-cluster
  enqueueOnForce: false
  preConditionDeadlineSeconds: 0
  switchover:
  - componentName: mysql
    instanceName: acmysql-cluster-mysql-2
  type: Switchover
status:
  completionTimestamp: "2024-11-18T12:13:00Z"
  conditions:
  - lastTransitionTime: "2024-11-18T12:13:00Z"
    message: 'wait for the controller to process the OpsRequest: acmysql-switchover-specify
      in Cluster: acmysql-cluster'
    reason: WaitForProgressing
    status: "True"
    type: WaitForProgressing
  - lastTransitionTime: "2024-11-18T12:13:00Z"
    message: this cluster component mysql does not support switchover
    reason: ValidateFailed
    status: "False"
    type: Validated
  phase: Failed
  progress: -/-