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