KACE K1000 SQL Frequent Backup Support
Hello,
We have an issue in our organization in which SQL tables become damaged when there is a sudden powerdown of the K1000 due to a VM failure.
We then have to restore from a backup taken the previous night at 2am.
We would like to take frequent backups of our SQL tables in order to have a recent or near-recent copy of the SQL tables available at our disposal at all times to recover from these types of events more quickly.
I have been told that a standard MySQL backup process, in which the SQL tables are created, set to read-only, and then flashed, is not feasible as root password and SQL access keys are required.
But I have to believe that this is possible - the K1000 has to have some mechanism or process in place that allows for minimizing downtime. It is, after all, a production technology.
How do others deal with this problem? What is a decent solution? Is there a third-party backup tool that can help?
Many thanks!
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
Channeler
5 years ago
Hi.... maybe check your enterprise UPS, a VM shutdowns should no be as frequent as that. (two or three at max during a year is the ideal).
It appears the KACE SMA does not have a way to backup just the DB:
Also third party backup tools are not supported, this article says that is not a good idea to use them, as they may cause corruption, see these links:
https://support.quest.com/kace-systems-management-appliance/kb/238313/regarding-third-party-virtual-machine-backup-and-kace-appliances
https://support.quest.com/kace-systems-deployment-appliance/kb/195580/configuring-backup-integration-services-appropriately-for-k1000-and-k2000-vms-running-on-hyper-v-to-prevent-mysql-database-file-corruption
https://support.quest.com/kace-systems-management-appliance/kb/238313/regarding-third-party-virtual-machine-backup-and-kace-appliances
https://support.quest.com/kace-systems-deployment-appliance/kb/195580/configuring-backup-integration-services-appropriately-for-k1000-and-k2000-vms-running-on-hyper-v-to-prevent-mysql-database-file-corruption
Comments:
-
I agree, you need to figure out why your VM server is crashing. Fixing the root problem is better than finding another work around. - chucksteel 5 years ago
