I am interested in setting up a backup system for CatDV that can automatically backup my database without the need to take CatDV server offline. My version of CatDv is using MYSQL in the background. I was looking at using perconas xtrabackup, which says that it allows for hot backups of SQL databases. Has anyone tried this or had any experience with a hot backup system for CatDV?
you can do a "hot" backup of mysql from the mysql command line we provide sample scripts to do this using batch files / shell scripts for both windows and mac on our website under the Resilience and housekeeping section of our Tutorials Pages along with general guidance on backups see links below
It is also possible to Run MySql in a high availability Cluster which while complex and requiring a lot of hardware should be achievable by a competent DataBase / Sysadmin. We can offer advice and assistance with designing and configuring this type of system as part of our professional services offering