Question: How to Migrate datastore in Spinnaker from Redis to MySQL?


Answer: Instructions available in this blog

https://blog.opsmx.com/how-to-migrate-mysql-to-redis-database-in-spinnaker/


In case, if you notice the following exception "Caused by: java.sql.SQLException: Access denied for user 'front50_migrate'@'10.32.0.1' (using password: YES)". Execute the below commands

GRANT ALL PRIVILEGES ON . TO 'orca'@'%';
GRANT ALL ON . TO 'orca'@'%' IDENTIFIED BY '<OrcaDBPassword>' WITH GRANT OPTION;
GRANT ALL ON . TO 'orca_migrate'@'%' IDENTIFIED BY '<OrcaUserPassword-1>' WITH GRANT OPTION;
GRANT ALL ON . TO 'orca_service'@'%' IDENTIFIED BY '<OrcaUserPassword-2>' WITH GRANT OPTION;
flush privileges;