CatDV Hot SQL backup

[Dougal Matthews]

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

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

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

https://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

https://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

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

thank you Dougal

Improvise Adapt and Overcome

[Eli Garrett]

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