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