BackupPC-users

Re: [BackupPC-users] mysql streaming

2013-04-26 17:30:17
Subject: Re: [BackupPC-users] mysql streaming
From: Les Mikesell <lesmikesell AT gmail DOT com>
To: "General list for user discussion, questions and support" <backuppc-users AT lists.sourceforge DOT net>
Date: Fri, 26 Apr 2013 16:29:10 -0500
On Fri, Apr 26, 2013 at 3:46 PM, Lord Sporkton <lordsporkton AT gmail DOT com> 
wrote:
> As mentioned we have multiple customers and departments. It's not just one
> server. Also 50g data bases aren't the largest. We have ones upto 200g
> individual dbs. Also we're using scsi drives which cost a pretty penny.

I think you are missing what people are saying.  Throw some big, cheap
SATA drives somewhere, on any convenient box (possibly the backuppc
server itself) and write your db dumps from other hosts there over the
network using   |ssh host 'cat >file',  nfs or smb.    Then if you
want a history, let backuppc back up this holding space.  However,
backuppc isn't great for storing lots of copies of large files with
small differences.  Depending on the database contents, you may get
pretty good compression on the content but it is still going to store
a complete copy of the data for every version.  Unlike, for example, a
large directory of files where only a few small files change between
copies and backuppc can hardlink the duplicates.

--
   Les Mikesell
    lesmikesell AT gmail DOT com

------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/

<Prev in Thread] Current Thread [Next in Thread>