Anabolics
Search More Than 6,000,000 Posts
Results 1 to 3 of 3
  1. #1
    ReX357's Avatar
    ReX357 is offline "Toughest & Best Looking Guy Around Here"
    Join Date
    Jan 2005
    Location
    Behind you
    Posts
    3,845

    Solution for the 3:00 AM Backup?

    Instead of backing up the server everyday and sending the database on the other server/computer, waisting 5 gig of bandwidth and 1 hour of uptime, why don't you add a line of code to send each new post/thread to the backup database too (on the other server/computer). Would be way faster, no?

  2. #2
    Blown_SC is offline Retired Vet
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    6,917
    Send your concerns to this guy maybe

    Quote Originally Posted by pixl97
    Howdy...

    I administrate the hardware for the forums. At 4:00 AM CST the server dumps and compresses around 5GB of data, which is then sent to and off site server. This consumes a significant amount of resources when this occurs, But we have found this to be the best trade off. Currently if the database is corrupted, hacked, or otherwise damaged it will only be one day behind when restored. We have adopted this policy after having a hard disk corrupt and the last backup was over two weeks old, earlier this year.

    I apologize for any inconvenience this may cause.
    Peter Maas

  3. #3
    pixl97's Avatar
    pixl97 is offline Almighty Root
    Join Date
    Dec 2004
    Posts
    674
    ReX357, what your suggesting is that we do live replication of the database, which I would love to do, but would require a second server running a database daemon. Currenly we have a NAS server on a private network with around 100Gb of space, but it only allows storage, and not running server processes.

    A few days ago we changed the compression settings on the backup which should lead to increased performance of the fourms while the backup is occuring. Is the server still slow at 4?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •