Can anyone here give me some suggestions for the best way to back up
the database for our website? Originally we used a cron job that did a
MySQL dump every evening, but as the size of our wiki has grown, the
time needed just to run the dump has grown. It now takes 30-45
minutes, during which time site performance bogs down. We've therefore
tried doing live MySQL replication instead to maintain a mirror of the
database, but that doesn't seem to work very well.
Is there some other approach that we should be trying?
-------------------------------------------
SHELDON RAMPTON
Research director, Center for Media & Democracy
Center for Media & Democracy
520 University Avenue, Suite 227
Madison, WI 53703
phone: 608-260-9713
Subscribe to our free Weekly Spin email:
<http://www.prwatch.org/cmd/subscribe_sotd.html>
Subscribe to our Weekly Radio Spin podcasts:
<http://www.prwatch.org/audio/feed>
Read and add to articles on people, issues and groups shaping the
public agenda:
<http://www.sourcewatch.org>
Support independent, public interest reporting:
<http://www.prwatch.org/donate>