Hi All,
I have a mysql server, v4.0.15, running on Windows 2000 Server. There
are around 750 tables on it, taking up about 56G of data. Most of the
tables are updated at intervals of about 30 seconds. As you can imagine,
this makes it quite difficult to back up my data properly. Currently I'm
doing a 'backup table to d:\temp\backups' for each table and then
copying the resulting files to networked storage. This isn't terribly
efficient, and can take over 12 hours to do (mainly as i have a 10
second sleep between tables, to allow any outstanding writes to go
through). As a result, my data is not only out of date when it's
finished backing up, but it's also out of sync. I am also unable to take
the database offline for long to do backups, which makes it even harder.
To recitfy (part of ) the situation, I am considering using a slave
server, and stopping replication to do backups, then restarting
replication. My main question is, can I do this if my slave server is
running linux, or must I use Windows? Can I do it with a newer version
of mysql on the slave, or must I stick with the same version?
Alternatively, does anyone have any other suggestions for a backup
strategy?
Leigh
