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]
