FORUMS: list search recent posts

CatDV Hot SQL backup

COW Forums : Square Box CatDV

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
Eli Garrett
CatDV Hot SQL backup
on Mar 6, 2015 at 8:07:03 pm

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?

http://www.percona.com/software/percona-xtrabackup


Return to posts index

Dougal Matthews
Re: CatDV Hot SQL backup
on Mar 9, 2015 at 12:49:00 pm

hi Eli

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

http://www.squarebox.com/catdv-backups/

http://www.squarebox.com/automating-backups-mac-2/

http://www.squarebox.com/automating-backups-win/

Please be aware that there will always be a performance hit while these backups are taking place so its best to schedule them for quite times


For real time redundancy its possible to mirror a mysql DB to another Machine please see our guidance in the online server help manual here

http://www.squarebox.com/server68-manual-advanced-mysql/


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

http://www.squarebox.com/professional-services/

thank you Dougal

Improvise Adapt and Overcome


Return to posts index

Eli Garrett
Re: CatDV Hot SQL backup
on Mar 12, 2015 at 7:29:43 pm
Last Edited By Eli Garrett on Mar 12, 2015 at 7:30:02 pm

Thanks, This is exactly what I was looking for, I will give this a try.


Return to posts index

<< PREVIOUS   •   VIEW ALL   •   PRINT   •   NEXT >>
© 2017 CreativeCOW.net All Rights Reserved
[TOP]