Clouddriver migrating from redis to mysql did not work

Clouddriver migrating from redis to mysql did not work.

But when I configured clouddriver to use mysql only, it worked and there are some data in the database clouddriver in mysql.

The following is the configuration in clouddriver-local.yml for migrating:

(I refer to the spinnaker link: https://www.spinnaker.io/setup/productionize/persistence/clouddriver-sql/)

sql:
  enabled: true
  task-repository:
    enabled: true
  cache:
    enabled: true
    read-batch-size: 500
    write-batch-size: 300
  scheduler:
    enabled: true
  connectionPools:
    default:
      default: true
      jdbcUrl: jdbc:mysql://xxx.xxx.xxx.xxx:3306/clouddriver
      user: clouddriver_service
      password: hunter2
  migration:
    user: clouddriver_migrate
    password: hunter2
    jdbcUrl: jdbc:mysql://xxx.xxx.xxx.xxx:3306/clouddriver

redis:
  enabled: true
  connection: redis://10.102.21.106:6379
  cache:
    enabled: false
  scheduler:
    enabled: false
  task-repository:
    enabled: true

dual-task-repository:
  enabled: true
  primaryClass: com.netflix.spinnaker.clouddriver.sql.SqlTaskRepository
  previousClass: com.netflix.spinnaker.clouddriver.data.task.jedis.RedisTaskRepository

Note:

  1. The mysql is running normally.()

  2. kubectl get svc -n spin-development | grep redis

spin-redis ClusterIP 10.102.21.106 6379/TCP,8008/TCP 38d


Could someone give me some suggestions or advices?

Thanks a lot!

BR//Yongxuan