Hi,
Can the server be attached to a SAN? If so, there are various SAN backup
strategies that may be used...
Tony White
DBA - MIS SSG
THOMSONLocal
Tel : 01252 390063
Email:tony.white@stripped
www.thomsonlocal.com
-----Original Message-----
From: Leigh Sharpe [mailto:lsharpe@stripped]
Sent: 27 October 2009 04:24
To: win32@stripped
Subject: Replication across different platforms
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
The opinions expressed are those of the individual and not the company.
Internet communications are not secure and therefore Thomson Directories Limited ("the
company") does not accept liability for any claims arising as a result of the use of this
medium for transmissions by or to the company.
This email and any files transmitted with it are confidential. If you are not the intended
recipient, you are hereby notified that any disclosure, distribution or copying of this
communication is strictly prohibited.
Whilst we take every reasonable precaution to screen out computer viruses from emails,
attachments to the email may contain such viruses. We cannot accept liability for loss
or damage resulting from such viruses.
Thomson Directories Ltd. Registered Office: Thomson House, 296 Farnborough Road,
Farnborough, Hants. GU14 7NU. Incorporated in England. Registered No. 902438
