From owner-freebsd-questions@FreeBSD.ORG Tue Jul 6 12:42:07 2010 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 41A2A106566B for ; Tue, 6 Jul 2010 12:42:07 +0000 (UTC) (envelope-from kraduk@googlemail.com) Received: from mail-gw0-f54.google.com (mail-gw0-f54.google.com [74.125.83.54]) by mx1.freebsd.org (Postfix) with ESMTP id EDE978FC12 for ; Tue, 6 Jul 2010 12:42:06 +0000 (UTC) Received: by gwb1 with SMTP id 1so2647028gwb.13 for ; Tue, 06 Jul 2010 05:41:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=6kRa8RZm+AAegZSrYewn0vy3hG2Z9ndBGd7Z56OSPoM=; b=JYqbTH3JJNoYsq46tbY+y770rM8XUTgXX58zmdGBwk4BaAszjJf3uqvQ2fGINfQcaM +e3DhVE2Hgtncs9wk9vn13rBo/SWG5yiiPncqidKHRTmgph75Hq1WTr8Bri6Ulu/wlKD unH4Lh1f+geQwQO8/f1ygcwbqOzTbp2MCvTiw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=lC4PbCKNpldds0IeoHQqC8cP/ZPhiUIfSPxZ4pt5gsfaG56Lr3D5ogC85rk8wCIH85 HigrQ8Q7Bj90oxTnO8G05Vgj9k580QQYvEHxycGphSg1NnXbTOTx72LqoL6BnnCRreOE hwcI+HHLuENZuBFs9ia+4n2nhG0aCYcRLi5Wk= MIME-Version: 1.0 Received: by 10.239.182.9 with SMTP id o9mr325248hbg.57.1278405775439; Tue, 06 Jul 2010 01:42:55 -0700 (PDT) Received: by 10.239.161.199 with HTTP; Tue, 6 Jul 2010 01:42:55 -0700 (PDT) In-Reply-To: <4C3108B6.8070606@tundraware.com> References: <4C3108B6.8070606@tundraware.com> Date: Tue, 6 Jul 2010 09:42:55 +0100 Message-ID: From: krad To: Tim Daneliuk Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Liste FreeBSD Subject: Re: Global backup solution for FBSD & Ubuntu X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 06 Jul 2010 12:42:07 -0000 On 4 July 2010 23:18, Tim Daneliuk wrote: > On 07/04/10 16:43, bsd wrote: > >> Hello, >> >> I am trying to build a global backup solution for couple of strategic >> servers (7) based on two operating systems : >> >> - FreeBSD (6 - 7 // soon 7 - 8) >> - Ubuntu 8.04 LTS >> >> These servers are hosting some strategic components mainly related to DN= S >> infrastructure and databases. >> >> >> For the moment I am backing up these server using network based backup >> solution: >> >> - A "duplicity" based solution which backs up key directories in my >> infrastructure on a remote FTP server provided by my hosting company. >> - A "dump" of some key components which I am doing on regular basis for >> FreeBSD servers. >> - Duplicity is also used for the Ubuntu servers. >> - Databases are replicated "live" on a remote server using "slony" for t= he >> most strategic ones (Postgres DB) and using mysql dump export for MySQL. >> >> >> =95 I am not a 100% sure these solutions will allow me to restart rapidl= y >> from a crash, specially for Ubuntu servers. >> =95 I would like to know which solution(s) you have deployed at what cos= t >> for what results ? >> >> I am actually considering couple of different solutions >> >> - SAIT solution and backula. >> - Disk based solution (maybe also with backula). >> =85 >> >> >> I have couple of servers that will reach their end of life that could be >> recycled as backup solution at a very convenient price=85 >> >> >> > > I wrote a simple shell-based solution for this problem some time ago. It > (and FreeBSD > instructions) can be found: > > http://www.tundraware.com/Software/tbku/ > > > I am able to recover a production server (DNS, dhcp, http, sendmail, > etc...) in under > 30 minutes using this technique. > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to " > freebsd-questions-unsubscribe@freebsd.org" > we use an rsync based solution at work. All the files are basically rsyncd onto a big opensolaris filer backed with zfs. We then snapshot each hosts file system after the completed backup. It then gives us an incremental forever backup so is generally quite fast to do. Restores are also fairly fast depending on the size of the data set. For a full restore I boot into the new box on a liveusb os, partition/slice, newfs, mount and push the rsync back. All fairly easy and quick. With regard to database backups, we run all our mysql and oracle dbs on zfs= . This allows us to put a global write lock on the db and flush everything to disk. We then snapshot the db zfs fs and remove the write lock. Alternatively if its a mysql slave, we just stop the slave, flush and snap. This means we can take hot backups of all our dbs with minimal impact.