Hi, We have similar numbers here.
A couple of questions: - are they logfiles that could be rolled over on a daily basis or are they constantly updated huge tables? - is the type of backup you want incremental or a daily/weekly snapshot one? - do you have a requirement for the speed of restore needed in the case of disaster recovery? - is the replicated slave allowed to stop replicating whilst the backup is being performed? Let me know and I think I'll be able to help :) Cheers, Andrew -----Original Message----- From: Joe Shear [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 21:08 To: [EMAIL PROTECTED] Subject: large mysql/innodb databases I was wondering if anyone had any experience with setting up large and fairly high performance databases. We are looking at setting up databases with each machine having somewhere between 500 gigs and 2 terabytes along with a slave box and we'd like to backup everything to tape at a minimum of once a week, but if possible, daily. We're also looking at central storage solutions. However, we're hesitant because that will result in a (very expensive) single point of failure. Of course, we could buy 2, but they are fairly expensive. Has anyone had any experience with setups like this? What kind of backup solutions did you use? We aren't too concerned about the CPU usage as our databases tend to be i/o bound. -- Joe Shear <[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]
