Do you have to stop the DX NetOps Performance Management Performance Center services when create MySql database backups?
We just migrated to new servers and are setting up backups. The "Back Up NetOps Portal" section in the document link below instructs users to stop the following services when creating the MySql backups with the mysqldump command.
Is this necessary to bring the PC services down for backups?
What is the risk of running myslqdump with the services running? Would this impact recovery?
All supported DX NetOps Performance Management releases
For 21.2.8 and higher You can create “live” backup of NetOps Portal configuration and event manager data in addition to “cold” backups. A “live” backup backs up the data while the NetOps Portal services are up and running.
For the previous versions:
There are a few reasons that the backup process requests the PC services be stopped during the active backup process.
Support recommends the backups be run late at night during off hours when nobody is using the Performance Center (PC) UI. This helps to ensure it doesn't impact UI access during working hours. If the backups are being run when nobody is using the UI it's doubtful anybody would notice it's down for a short time while the backup completes.
Note: There is no reason to stop the Data Aggregator (DA), Data Collectors (DC) or Data Repository DB while PC is down for the backup. These other systems should remain remain up and running, gathering/processing data, while the PC services are down for the MySql backups.