Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Blog
  • Questions
  • Learning
    • E-learning Courses
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Tutorials
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • DataMiner Insights
      • Security
      • Integration Studio
      • System Architecture
      • DataMiner Releases & Updates
      • DataMiner Apps
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
  • Downloads
  • More
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

MSSQL to Cassandra database migration time.

Solved2.02K views14th April 2021Cassandra migration
0
Carlos Trejo20 6th April 2021 0 Comments

Hi,
I'm in the process of migrating our MSSQL database to Cassandra database in our DMS. However, the Total remaining time states around 43hours to complete the migration, is this expected for a 200MB database?

I read in the documentation that it takes approximately 1 hour for every 5GB of data.

Thanks,
Carlos

Carlos Trejo Selected answer as best 14th April 2021

2 Answers

  • Active
  • Voted
  • Newest
  • Oldest
1
Randy Ulvenes [SLC] [DevOps Advocate]999 Posted 12th April 2021 3 Comments

Hi Carlos,

I was involved in a 5 DMA cluster migration.  The system had been operational for about 7 years and had some large tables.   This system was still running on Windows 2008.

The migration for each DMA took between 5 to 9 days depending upon the size of the database.  The databases were in the 300 GB to 700GB range.

When the migration started, the migration tool estimated the completion time at 2 to 4 days but it took longer.

Best Regards,

Randy

Carlos Trejo Selected answer as best 14th April 2021
Carlos Trejo commented 13th April 2021

Hi Randy,

Thank you for your response. For this 5 DMA cluster, how was this performed? Did you have to wait for one DMA to finish the migration before the next agent was migrated? During this time, the DMS is fully operational right?

In this case, for our customer, they have a DMA cluster comprised of 6 DM pairs ( 1 standby and 1 active) total of 12 agents. Do you know what would be the best practice for the migration in this scenario?

Thanks a lot!

Carlos

Randy Ulvenes [SLC] [DevOps Advocate] commented 13th April 2021

Scenario:
Current system: A 5 cluster running 8.5 Dataminer in a 1 to 1 failover mode. So there are 10 DMAs. This system is running on Windows Server 2008.

The goal was to move to new physical servers running VMs, Windows Server 2012, and upgrade to Dataminer 10.

1) What we did was put 8.5 Dataminer on the new physical servers VMs that were not connected to the internet.
2) We did a backup on the operational cluster MSSQL database on each DMA and loaded them it the corresponding new physical servers running 8.5 Dataminer.
3) We then upgrade these new 5 DMAs to 9.0 and then to 9.6.
4) We started Dataminer and connected to the elements as a test the 9.6 upgrade was working. We left the old 8.5 DMA cluster running. Thus we were running in parallel the old 8.5 cluster and the new 9.6 cluster. (note: we had to ” “not” turn up some elements on 9.6 as these elements would not allow more than 1 agent to poll it. ) But this did give us a confidence level check the 9.6 upgrade and new servers were working correctly
5) We started the Cassandra Migration on the 9.6 DMS but it the migration estimate was very long. We shut down the 9.6 Dataminer software to only run the Cassandra Migration by itself with the thought this would speed up the migration. This did not appear to speed up the migration much.

The migration started out with and estimate of 2 or 4 days but it took much longer as I mentioned.

Once the Cassandra migration was complete on the Dataminer 9.6.
1) We then upgraded the new DMS 9.6 to Dataminer 10.
2) We connected the new DataMiner 10 cluster in parallel with the original 8.5 cluster again to soak and compare data. During the soak period we had to make a couple of minor driver changes to a couple of connectors to be Cassandra compliant.

I would note that some trend MSSQL tables where very large as this system has been running for at least 8 years. We discussed with the customer if they needed trend data going back 8 years. They did not need this data and we truncated some of the very large tables to 1 year of data before the Cassandra migration. Example. One trend table had 91 million rows.

Carlos Trejo commented 14th April 2021

Hi Randy,

Thanks for going through this in such great detail! I really appreciate it and gives me a good picture of what to expect with this migration.

Cheers!
Carlos

1
Simon Therry [SLC] Posted 8th April 2021 1 Comment

Hi Carlos,

The current time estimation is based on the total percentage completed within the current time elapsed. From the screenshot, I see that the migration is running for about 13 minutes, with a total percentage of 0.50% completed. If we extrapolate this, it would take 43 hours to reach 100%. So the calculation seems to make some sense.

If I look at how many rows you have in the Info column, in this case around 12000, it seems to take a very long time to migrate them. The migration of Info is at 66%, meaning about 8000 rows have been done in around 13 minutes. This indeed seems very slow.

Perhaps it is interesting to have a look at the load (CPU/memory/disk IO) of the server that is performing the migration.

Best regards,

Simon

Carlos Trejo Posted new comment 13th April 2021
Carlos Trejo commented 13th April 2021

Thanks Simon, I will have a look at that

Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas

Recent questions

Web Applications exception in Cube due to invalid certificate 0 Answers | 0 Votes
Redundancy Groups and Alarming – Duplicate Alarms 0 Answers | 0 Votes
Correlation Engine: “Test rule” doesn’t result in a hit, despite functional rule 1 Answer | 3 Votes

Question Tags

adl2099 (115) alarm (62) Alarm Console (82) alarms (100) alarm template (83) Automation (223) automation scipt (111) Automation script (167) backup (71) Cassandra (180) Connector (109) Correlation (69) Correlation rule (52) Cube (151) Dashboard (194) Dashboards (188) database (83) DataMiner Cube (57) DIS (81) DMS (71) DOM (140) driver (65) DVE (56) Elastic (83) Elasticsearch (115) elements (80) Failover (104) GQI (159) HTTP (76) IDP (74) LCA (152) low code app (166) low code apps (93) lowcodeapps (75) MySQL (53) protocol (203) QAction (83) security (88) SNMP (86) SRM (337) table (54) trending (87) upgrade (62) Visio (539) Visual Overview (345)
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin