vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Back up server / Mirroring recommendations please (https://vborg.vbsupport.ru/showthread.php?t=143847)

Make Money? 04-02-2007 10:59 AM
Back up server / Mirroring recommendations please
 
Forum is on sys admins private racks at a server co.

I want a copy on a machine I own.

Here is the size of the forum:

Server Type Linux Data
Usage 824.11 MB
Web Server Apache v2.0.52
Index Usage 471.41 MB
PHP 4.3.9
Attachment Usage 15.25 GB
PHP Max Post Size 8.00 MB
Avatar Usage 19.01 MB
PHP Maximum Upload Size 20.00 MB
Profile Picture Usage 2.53 MB
PHP Memory Limit 64.00 MB
Unique Members Today 1,202
MySQL Version 5.0.27-standard
MySQL Packet Size 64.00 MB

Average online at once 400 - 600
Maximum ever on line = 1,000
30,000 members
8,000 active
6 Million page views per month

Whats the best way to keep a constantly updated copy in case the sys admins private racks go down?

I want it all, attachments etc..

I don't mind a little slowness at off peak times or even a total switch off for 5 mins per night to get it done if thats what it takes..

Thanks in advance,

Lynne 04-02-2007 03:46 PM
I run a mysql backup script that I got from here every night during the off-peak times to backup my database (a bit less than 550 MB). Then, I also wrote a script to backup my avatars and torrents (26 MB and 100 MB) that I run every night (about 30 minutes after the mysql backup) and then I run a similar script to back up my attachments (only 3.5 GB) once a week (about a hour after the mysql backup).

Make Money? 04-03-2007 08:44 AM
hmm thanks

I have 15 gig of attachements..

Can these be backed up incrementally?

Is there a link to the scripts you use please?

Many thanks

Lynne 04-04-2007 02:42 AM
I've never looked into backing them up incrementally. As I mentioned, ours is just 3.5 GB right now and so I haven't looked into it yet. The script I use is a modification of something I found online somewhere. I would love to find some way to do it better than how I do it. But, here's my basic script:

PHP Code:
<?php

/*======================================================================*\
|| #################################################################### ||
|| # Cron Job to backup all avatars, attachments, and torrents            ||
|| # Last Modified: February 26, 2006                                   ||
|| #################################################################### ||
\*======================================================================*/ 

        $backupdate = date("Y-m-d");

        $backupdir1 = "/my/path/to/torrents/";
        //Where are the files located?
        //ie.  "/home/sitename/public_html/tracker/torrents/";

        $files = "*";
        //What file to backup? Use a * to backup all the files
        //inside the folder entered above.

        $backupto = "/my/path/to/backups/";
        //Where to store the tarball?
        //Make sure to put this outside your main folder
        //ie. "/home/sitename/backups/

        $fileprefix1 = "torrents";
        //This is the prefix that will be added before the date:
        //bak20060225.tgz

        $tararg = "-cf";
        //Here goes the tar arguments.
        // -cf to archive
        // -cjf to archive and bzip2
        // -tf to list the contents later on
        // -xf to extract them all later on

//Call the function
backupsus();

function backupsus() {
global $backupdate,$backupdir1,$backupto,
$fileprefix1,$tararg,$files;
$backupattach = "cd $backupdir1;
    tar $tararg {$fileprefix1}{$backupdate}.tar $files;
    mv {$fileprefix1}{$backupdate}.tar $backupto";
    passthru ("$backupattach");
}

?>

Make Money? 04-04-2007 03:32 PM
Thanks for the help!

Anyone else got any ideas for daily incremental back ups of attachements?

Thanks


All times are GMT. The time now is 07:15 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01076 seconds
  • Memory Usage 1,731KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete