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
  • Updates & Insights
  • Questions
  • Learning
    • E-learning Courses
    • Empower Replay: Limited Edition
    • Tutorials
    • 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
    • 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
    • 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
      • About the DevOps Program
      • DataMiner DevOps Support
  • Downloads
  • More
    • DataMiner Releases & Updates
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

Restarting MySQL process while DMA is running?

Solved794 views13th July 2023MySQL
0
Jeff Douglass860 24th August 2022 0 Comments

Is it safe to restart the MySQL process from the Workbench while DM is running or do I need to stop DM first, restart MySQL, and then restart DM?

Thanks

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

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
3
Michiel Saelen [SLC] [DevOps Enabler]5.63K Posted 25th August 2022 3 Comments

Hi Jeff,
There should be no problem restarting MySQL while DM is running. When the local DB goes offline, DM will go into offload mode. This means all data that needs to be forwarded to the DB will be stored in files temporarily. Once the DB is back online, DM will push the files from the offload folder towards the DB. and then start to communicate again directly to the DB. If your DMA would restart with offload files in the folder, it will only do the startup after all files have been pushed from the offload folder. This is to ensure DM starts with the latest data. So if you have a lot of files in the offload folder the startup might take a lot of time. When you want to ensure fast startup and you know there are no important parameters changed recently you could move the offload files to have a faster startup.

Let us know if you have other questions related to this.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 13th July 2023
Jeff Douglass commented 25th August 2022

Thanks for the details. How about any queries that are in progress such at the periodic deletes that DM does to cleanout the trend tables?
Thanks again.

Michiel Saelen [SLC] [DevOps Enabler] commented 26th August 2022

Hi Jeff, that is a very good question.
Not sure at the moment if they also follow the same path and get into the offload files, but I’ll see if I can get an answer for you on that.

Simon Declerck [SLC] [DevOps Advocate] commented 26th August 2022

Hi Jeff,

Whilst the in progress queries are interrupted they will not go to the offload files. In this scenario the periodic job will pick up where it left off the next time it is triggered by its timer.

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
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