What backup works best with MySQL?
My company currently uses tape drives for backing up MySQL. Our system is getting a bit old, and we're looking at other options. Can you suggest some backup systems that work well with MySQL?
That's a hard question to answer without knowing more about your needs. Generally a backup solution is a mix of hardware and software, and the hardware is not really tied too tightly to MySQL since you can store your backup on tape, optical disk, or drive arrays. If tape worked before you may just want to get a newer tape solution.
On the software front there are a variety of options: you can use built-in tools such as mysqldump and mysqlhotcopy, or you can use a third-party backup solution from companies such as Veritas and Arkeia. Here is a list of backup solution providers that may be of use to you.
This was first published in May 2005