MIgrate Offload to db to aws mysql

Solved688 views
0
0 Comments

Hi Dojo,

Im trying to migrate an offload db to AWS Mysql.
Is it possible that I can migrate the db or cluster?

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 13th July 2023

1 Answer

1
2.71K 3 Comments

Hi Soumith,

There's currently no built-in functionality to migrate Offload databases. You could try to achieve a similar result by stopping the on-prem offload DB and taking a MySQL backup of the on-prem DB. Then you can restore the MySQL backup on the AWS MySQL. Now you can switch the DataMiner offload configuration to point to the new AWS MySQL. This should result in all your offload data being available in the AWS MySQL. The data generated during the "move" will be offloaded once the DataMiner config is updated.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 13th July 2023
Alberto De Luca [DevOps Enabler] commented

Jens, interested in the option to write directly to AWS MySQL.
Amazon RDS supports MySQL Community Edition versions 5.6, 5.7, and 8.0 – are these all ok for the offload application?

Collecting info in this thread:
https://community.dataminer.services/question/offload-to-a-db-in-the-cloud-not-on-premise-any-specific-test-required/
Gellynck Jens [SLC] commented

Hi Alberto, MySQL 5.6 & 5.7 are supported by default I think. For offloading to a MySQL 8 database you’ll have to do a small configuration change. For this see the answer from Thibault on this question: https://community.dataminer.services/question/mysql-8-0-support-for-central-database-offload/?hilite=mysql+offload
Alberto De Luca [DevOps Enabler] commented

Thanks for the suggestion, Jens
Top Notch!