Site Backups - Midnight GMT Sunday

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
To make sure the PC Review backups are 100% accurate, weekly backups will be manually taken late on every Sunday night. The site will be down for approximately 5-10 minutes when this takes place to ensure that the database does not change during the backup.

Although this is not idea, it is the only way to make reliable backups for such a large database without an extra server, $1500+ live innodb software or risking corrupt backups. I am looking into ways to backup data daily on a live basis, whilst still ensuring complete datasets and no downtime.
 

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
Sorry for the downtime - I installed some automated backup software that sounded promising and it brought the server down... I think I will avoid that one in future!
 

muckshifter

I'm not weird, I'm a limited edition.
Moderator
Joined
Mar 5, 2002
Messages
25,735
Reaction score
1,204
Ian Cunningham said:
Sorry for the downtime - I installed some automated backup software that sounded promising and it brought the server down... I think I will avoid that one in future!
Me is happy the DB was not lost ... :D
 

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
OK, server was offline for 10 mins for a manual backup... although I need to find a solution for live backups.

Anyone here a MySQL / InnoDB expert?
 

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
Typical... just as I was about to give up doing a live backup, I've found an app that works... will report back soon :)
 

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
Yup, appears to work - all done in the last 15 mins all online :)
 

muckshifter

I'm not weird, I'm a limited edition.
Moderator
Joined
Mar 5, 2002
Messages
25,735
Reaction score
1,204
Ian ... your talking to yourself.

Stop it.

:D
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top