Migrating a Database from CloudOps for AWS to CloudOps for Kubernetes

If you have an existing database created from an existing CloudOps for AWS based Self Managed Commerce deployment, you can migrate the database and its existing schema into CloudOps for Kubernetes.

note

Ensure that the database is suitable for use with CloudOps for Kubernetes. The external database instance must be a MySQL variant and is one of the MySQL variants compatible with the version of Self Managed Commerce.

For more information on the database requirements for the latest Commerce version, see Databases.

Ensure that the schema and data from the existing database are for the same Commerce version as the CloudOps For Kubernetes deployment of Self Managed Commerce to avoid compatibility issues.

The schema must have been created by the data-pop tool to ensure that the required Liquibase records are present. This allows the data-pop tool in CloudOps for Kubernetes to be able to update it in the future.

1. Run the use-existing-database-server Jenkins Job with the following parameters set:

• useExistingDatabase set to true
• databaseName set to the schema used in the Commerce deployment from CloudOps for AWS
• databaseUsername set to the username used in the Commerce deployment from CloudOps for AWS
• databasePassword set to the password of the username used in the Commerce deployment from CloudOps for AWS
• databaseServerUrl set to the database hostname used in the Commerce deployment from CloudOps for AWS
• databaseType set to aurora-mysql
• kubernetesNickname set to the namespace you have planned for the Elastic Commerce stack to be deployed into.

warning

useExistingDatabase must be set to true when migrating the database. Otherwise a new schema is created by this job and the data does not get copied into the created schema.

Once you have migrated the database to CloudOps for Kubernetes, do not run the run-data-pop-tool Jenkins job with the job parameter dataPopToolCommand set to reset-db on the database. If you do the schema will be recreated and the original data will be lost.