Hiya!

Thanks for the help!!!

Do RSync like big files? Or does it prefer smaller files? I see it supports
larger than 2 Gig files, but, Ive not seen any speed comparrisons etc. E.g.
one big file, or 10 small ones for example.

THANKS!

Steve


----- Original Message ----- 
From: "Peter Lovatt" <[EMAIL PROTECTED]>
To: "Steve Vernon" <[EMAIL PROTECTED]>; "Mysql List"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, October 31, 2003 12:17 PM
Subject: RE: Hardware Raid and 2 Gig Limit


> Hi
>
> We have a similar challenge. Offsite backups with huge amounts of data,
> without spending a fortune.
>
> We have a local Linux box and the remote server both running rsync.
>
> http://samba.anu.edu.au/rsync/
>
> Rsync is brilliant because it only updates file sectors that have changed.
> We would only use it if we can stop MySql but then synchronising takes
> minutes (1MB broadband connection), particularly using compression.
>
> If you cannot add your own server software MySql files also compress very
> well (gzip 90%+), but this means some server load.
>
> HTH
>
> Peter
>
>
> -----------------------------------------------
> Excellence in internet and open source software
> -----------------------------------------------
> Sunmaia
> Birmingham
> UK
> www.sunmaia.net
> tel. 0121-242-1473
> International +44-121-242-1473
> -----------------------------------------------
>
>
>
>
>
>
> -----Original Message-----
> From: Steve Vernon [mailto:[EMAIL PROTECTED]
> Sent: 31 October 2003 12:00
> To: Mysql List
> Cc: [EMAIL PROTECTED]
> Subject: Re: Hardware Raid and 2 Gig Limit
>
>
> Hiya!
>
> Thanks for the quick reply!!!
>
> But dosen't it make more sense to have 20 0.5 Gig files rather than one 10
> Gig file?
>
> I know you can split files, but basically because we have raid I trust it
to
> a point. But I would like to make backup's. It costs a lot to have our
> server provider to do backup's themselves. We can't afford replication and
> backups at the moment. So I plan to stop MySQL. Copy the database files to
a
> temp directory. THen download them at my leisure. Oh and I suppose I need
to
> start MySQL then! ;-) The backup will be to Windows 2000, and I want to be
> able to use the local copy of the files.
>
> So if I have smaller files, I can download them, and keep a local copy.
> Theres no way I want to start downloading a 10 Gig file from the server.
Ok
> I can do it, I have a download manager etc, Iv'e downloaded bigger. But I
> guess it must be a massive strain on the server sending the data, and we
> dont have that fast an internet connection so it's easier. We only have
512
> broadband and it sometimes messes up files larger than 2 Gig.  The
download
> manager realises there is a problem, seems to backtrack or something, so
> takes ages. Cable is not available where I live.
>
> If we go beyond 10 Gigs, it just increases the complexity.
>
> Do you or anyone know of any serious speed differences between having one
> file or 20 smaller files for one table? With one files, isn't there a
worry
> if it gets corrupted you loose the lot?
>
> A couple of years ago I looked into big tables for myself and everyone
said
> you need the raid option in MySQL. Now I'm not sure!
>
> Thanks,
>
> Steve
>
>
>
> ----- Original Message -----
> From: "David T-G" <[EMAIL PROTECTED]>
> To: "mysql users" <[EMAIL PROTECTED]>
> Cc: "Steve Vernon" <[EMAIL PROTECTED]>
> Sent: Friday, October 31, 2003 10:44 AM
> Subject: Re: Hardware Raid and 2 Gig Limit
>
>
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > Steve --
> >
> > ...and then Steve Vernon said...
> > %
> > % Hello,
> >
> > Hi!
> >
> >
> > %
> > % Does the 2 Gig file size limit on Linux get broken when I have a
> hardware
> > % raid controller?
> >
> > The limit applies only to ext2 filesystems, and not all of them at that;
> > ext3 and reiserfs (and others) can happily write much larger files.
> >
> >
> > %
> > % My ISP says I don't need the raid option activated on MySQL.
> >
> > I would generally agree.  I can't imagine an ISP not using a journalled
> > filesystem such as those above.  More to the point, though, the mysql
> > raid option has nothing to do with disk RAID; they are completely
> > separate.
> >
> >
> > %
> > % Thanks,
> > %
> > % Steve
> >
> >
> > HTH & HAND
> >
> > :-D
> > - --
> > David T-G                      * There is too much animal courage in
> > (play) [EMAIL PROTECTED] * society and not sufficient moral
courage.
> > (work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and
> Health"
> > http://justpickone.org/davidtg/      Shpx gur Pbzzhavpngvbaf Qrprapl
Npg!
> >
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.0.7 (FreeBSD)
> >
> > iD8DBQE/ojzyGb7uCXufRwARAtEmAJ9i3oIMbLTA4yq8koPcEOUwD7SpRwCfe+bn
> > rvzVjuD8tIxO8AVj3jp02CI=
> > =QdfG
> > -----END PGP SIGNATURE-----
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to