Bacula-users

Re: [Bacula-users] Encrypion & compression during transmission from remote site

2008-09-08 05:23:40
Subject: Re: [Bacula-users] Encrypion & compression during transmission from remote site
From: John Huttley <John AT mib-infotech.co DOT nz>
To: Bill Damage <bill.damage AT yahoo DOT com>, bacula-users AT lists.sourceforge DOT net
Date: Mon, 08 Sep 2008 21:23:26 +1200
Hi,
There is away of doing this economically with rsync over ssh (use keys).
I know you don't want to use ssh, but it really isn't that hard.

You need lots of storage on your server, essentially you have a local copy of their data, and invoke bacula on that.
The trick is to manipulate file names.

Suppose your remote backup is 1Gb of the form mysql-YYYY-MM-DD.sql

Copy this file to myqsl.sql and then rsync that file against the copy on your server.

(If the filename keeps changing, rsync is just a copy and the advantage is lost)

Then take a backup of the remote files on your server and time stamp that.
 ( I use tar and put the date into the filename., then use 'find' to delete copies older than XX days.)
You can do this by having the client run a script on your server via ssh after performing the rsync.

Now, what you get is the enormous speed increase of rsync, the security of ssh public keys.
And even better, ssh compresses.

You can even do this on a clients windows box using cwrsync.
It needs a little bit of  shell programming to get the correct filename and to archive your copy of his tree.

Restoring is easy since you have the latest copy uncompressed on your server. scp or even rsync it backwards.

That how I manage my MS SQL backups.

An bacula backs up the whole shebang once or twice a week.

--John


Bill Damage wrote:
Hi, if I do a mysqldump it creates a huge text file which compresses to 1/10 its size if zipped. What I'm wondering is if this is needed as I'm only doing it to shorten the transmission time, IOW does bacula compress traffic as its being transmitted automatically? Related to this is security - is there anything in place without having to set up ssh tunnels etc (i.e. over and above what you'd get with http/ftp transmissions) ? Thanks.


------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url="">

_______________________________________________ Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
<Prev in Thread] Current Thread [Next in Thread>