GigaNews
Threads in some sections have NO links for Guests, Register before you can view those threads.




PDA

View Full Version : Database Backup


Samurai
01-13-2004, 11:35 PM
Database Backup

Please wait a minute while our database backup is running. Once completed you will be able to access our boards again.

Page will try to refresh every 10 seconds.

I just got this message for the last 10 minutes and wouldn't let me access the site <_<

james_bond_rulez
01-13-2004, 11:38 PM
it means it's backing up all the messages for archive

just read what it says :lol:

Samurai
01-13-2004, 11:41 PM
Ooh smart!! Let's see...

"Make me a coffee, with two sugars"






Hmm well I had to make my own it seems... waited damn near 10 minutes ;)

Cheers for your input Mr Bond.

7thElement
01-13-2004, 11:46 PM
We backup our database every x days to make sure that we have a working backup for the case that something happens (database crash etc)

This step takes around 2 - 3 minutes (800 MB backup). To make sure that the backup is not corrupt we disable board access.

If you backup while people browse or post it will backup a corrupt database which means that it cannot be restored.

lynx
01-14-2004, 12:08 AM
7th, have you considered a detachable software raid system?

Effectively, what this means is that you create a mirror of the live system. This takes a few minutes to generate, but is updated at the same time so by the time it has finished they are identical (and both being updated).

You then take a checkpoint and detach the mirror. If this is scripted, is takes less than a second during which time the system is unavailable. Now you can make a backup of the mirror, which is not corrupt.

Of course, depending on the underlying system you can get this sort of software for nothing or it can cost you a small fortune.

james_bond_rulez
01-14-2004, 12:19 AM
yeah right like u have the money to buy raid controller cards and hdds.....

wooot... :lol:

it really digs deep down ur wallet...

internet.news
01-14-2004, 07:29 PM
Originally posted by Samurai@14 January 2004 - 01:41
Ooh smart!! Let's see...

"Make me a coffee, with two sugars"






Hmm well I had to make my own it seems... waited damn near 10 minutes ;)

Cheers for your input Mr Bond.
Yeah, coffee sounds good - I was just amazed by your answer ;) I love it some ways... :rolleyes:

lynx
01-14-2004, 08:30 PM
Originally posted by james_bond_rulez@14 January 2004 - 00:19
yeah right like u have the money to buy raid controller cards and hdds.....

wooot... :lol:

it really digs deep down ur wallet...
software raid