Cassandra Database

Solved857 views
3
0 Comments

Hi,

We are looking to migrating our MSSQL database to Cassandra database, but we would like to know if DataMiner installs the Cassandra Database and then does the migration or do we have to install the Cassandra database first and then DataMiner performs the data migration.

Thanks in advance,

Carlos

Carlos Trejo Selected answer as best 22nd March 2021

1 Answer

2
1.95K 5 Comments

I believe it does depend on where you Cassandra instance will be hosted. If you are running Cassandra on a different host or linux server, it could be different.

However, for a simple migration from MySQL to Cassandra on the same server, there is no need to install the Cassandra database manually, the migration process does download and install Cassandra as part of the same procedure.

More information on following link. Note also the item 2 of the 'Migrating To Cassandra' section, which does indicate that you can even choose if you want to start the migration after the download and installation of Cassandra.

https://help.dataminer.services/dataminer/#t=DataMinerUserGuide%2Fpart_3%2Fdatabases%2FMigrating_the_general_database_to_Cassandra.htm

Leander Druwel [SLC] [DevOps Advocate] Posted new comment 23rd March 2021
Leander Druwel [SLC] [DevOps Advocate] commented

Note: before you launch the migration step, it might also be useful to check the DataMiner system requirement, which does also mention the requirements for Cassandra.

https://community.dataminer.services/where-to-find-the-most-recent-dataminer-system-requirements/
Carlos Trejo commented

Thanks for your response Leander, if we follow the simple migration from MS SQL to Cassandra, I assume this would install Cassandra locally for each DMA, is my understanding correct? And them, if we want to have a Cassandra cluster we can do that?

Or is it possible to have the migration and set a Cassandra cluster instead of having the Cassandra db locally on each DMA?

Thanks!
Leander Druwel [SLC] [DevOps Advocate] commented

I would indeed recommend to first perform the migration to local Cassandra dBs for each DMA, and once completed then look into moving it into a cluster.
Carlos Trejo commented

Thanks a lot Leander!
Leander Druwel [SLC] [DevOps Advocate] commented

One additional note. If you want to afterwards move to a Cassandra cluster, following tool can be used: https://community.dataminer.services/documentation/cassandra-to-cassandra-cluster-migrator/

That page also contains references to a lot of other interesting Cassandra articles.