topic Re: Controller Database Backup & Restore in Splunk AppDynamics

Controller Database Backup & Restore

CommunityUser — Fri, 10 Mar 2017 00:11:43 GMT

Hi,

I am looking for any comments based on real-world experience from the Appdynamics community on backup and restore of the Controller database. Our Controller is on a Linux platform and we use Commvault in our environment. Does anyone have any experience using Commvault to take hot backups of the Appdynamics Controller database please? (We are aware of the Apppdynamics recommendations and location of documentation referring to backups/restores). Any advice based on experience greatly appreciated.

Thanks, Niki

Re: Controller Database Backup & Restore

Mohammed_Rayan — Tue, 14 Mar 2017 08:00:09 GMT

Niki,

IMO,if the tool Commvault is able to backup sql data in binary ,then you can use it.

I understand you have already gone through our docs and recommendations on the same.

https://docs.appdynamics.com/display/PRO42/Controller+Data+Backup+and+Restore#ControllerDataBackupandRestore-BackupTools

Regards,

Mohammed Rayan

Re: Controller Database Backup & Restore

Saradhi_Pothara — Tue, 14 Mar 2017 08:05:26 GMT

I have not come across a case where hot backup was successfully taken using Commvault. Commvault was intermittently losing connections to mysql.
"Lost connection to MySQL server during query when dumping table 'xxx "

Regards,
Saradhi