Migration MySQL to Cassandra and Elastic cluster

Solved1.28K viewsCassandra cluster migrator Elastic MySQL
7
0 Comments

Hi Dojo,

What would be the suggested approach when we would like to move our DB architecture:

  • From: Local MySQL DB on each DataMiner Agent in the cluster
  • To: Multi-Node Cassandra and Multi-Node Elastic cluster

We would like to:

  • Keep all the data in the DB,
  • Do the migration while having as little impact on the active cluster

Thanks

Stacey Van Colen [SLC] [DevOps Advocate] Selected answer as best 16th January 2023

2 Answers

1
2.54K 0 Comments

Hi Dojo,

I have found the following information regarding the migration of the general database to a DMS Cassandra Cluster:

https://docs.dataminer.services/user-guide/Advanced_Functionality/Databases/Supported_System_Data_Storage_Architectures/Migrating_the_general_database_to_a_DMS_Cassandra_cluster.html?tabs=tabid-2

Note that it will be best if the system runs DataMiner 10.2.0 CU8 or 10.2.11 (or higher).

Stacey Van Colen [SLC] [DevOps Advocate] Selected answer as best 16th January 2023
1
1.90K 2 Comments

Hi Stacey,

The migration to Cassandra procedure can be found here (Migrating the general database to Cassandra | DataMiner Docs).

To install Cassandra (Linux is now recommended as SO): Installing Cassandra on a Linux machine | DataMiner Docs

To install Elastic: Installing Elasticsearch on a DMA via DataMiner | DataMiner Docs

Other useful resources:

Supported system data storage architectures | DataMiner Docs

Data Storage Architecture – DataMiner Dojo

Cassandra database | DataMiner Docs

Elasticsearch database | DataMiner Docs

Rene De Posada [SLC] [DevOps Advocate] Posted new comment 19th January 2023