backup solutions ?

giulianoz · Tux's lil' helper Joined: 11 Oct 2004 Posts: 96

Hi,
I have 7 gentoo servers (3 pairs in HA/load balancing and 1 as a single server). Each server runs mysql baserd services (2 runs radius and the others are apache+php+mysql). I need to find a backup solution that can backup my data (mainly /var/lib/mysql /var/www and db dumps) without the need to stop the services and/or locking the databases. Is it possible or should I simply stop the DB on the server I want to backup (high availability helps) and accepf lower performances for the needed backup period ?

thanks

giuliano

PaulBredbury · Watchman Joined: 14 Jul 2005 Posts: 7310

It's easy with postgresql, anyway:

madchaz · Posted: Wed Dec 14, 2005 3:10 pm Post subject:

The best would probably be to do a mysql dump and do a backup of that. This way, you don't have to take the server offline.

Doing a backup of the data files directly tends to give unpredictable results with mysql, in my experience.

I would sujest you use the crontab to make the mysql dump and then run your standard backup procedure on the files.
_________________
Someone asked me once if I suffered from mental illness. I told him I enjoyed every second of it.

giulianoz · Tux's lil' helper Joined: 11 Oct 2004 Posts: 96

thanks for the tips. Unfortunately I can't switch to pgsql at this time.
I'll try to have a one-way replicated mysql server which I can take down to backup everything (actually importing the whole db from a dump takes about 90 minutes and this take too long for my boss...)

giuliano