On Wed, 2003-09-10 at 05:29, Jimmy Wales wrote:
Tim Starling wrote:
Does anyone back up the image and oldimage
tables, the user table, the
watchlist table and the sitestats table? How often are the images
themselves backed up?
Good question. I backup everything using rsync to my home computer.
Just a note: rsync would work great for images uploads and general
stuff, but it won't work for the live database files. These files are
being changed constantly, so any attempt to copy them while MySQL is
running and making updates to them is likely to net you only a corrupted
copy. The tables could perhaps be locked during the rsync, but I don't
know how long it would take to rsync the ~15 gigabyte innodb table
space.
One thing to think about is the binary update log (currently not enabled
on pliny). MySQL can keep a log of all updates to the tables it manages,
for the purpose of sending the updates on to slave servers to keep
replicated copies of the databases up to date.
It may be possible to extract just the updates to the cur and old tables
and produce runnable SQL which can be made available for download for
nightly incremental backup updates.
(Also, a complete replicated server could be set up.)
-- brion vibber (brion @
pobox.com)