Shirt Pocket Discussions

Shirt Pocket Discussions (https://www.shirt-pocket.com/forums/index.php)
-   General (https://www.shirt-pocket.com/forums/forumdisplay.php?f=6)
-   -   Limiting Super duper's FW transfer speed.... (https://www.shirt-pocket.com/forums/showthread.php?t=1761)

tspore 11-04-2006 09:29 PM

Limiting Super duper's FW transfer speed....
 
Here is a situation,
I have a few mac mini's and they are all connected to a G5 server. On the G5 I run mysql for the mini's & Put backups from the mini to a seperate drive on the server. But now I have come up with an issue. When the Super duper script runs, mySQL driven sites get well bogged down, fighting for the bandwidth to get through the FW connection. I was shuting down the public side of the websites weekly, but I would really like to do more frequent backup's than 1X a week.
So does someone know, or can someone point me to a way to limit the backup speeds on the FW connection?
The mini's only have 1 FW port... And no FW 800, or else I would be using that.
If I can keep the bandwidth that superduper pulls through I can upgrade to each mini gets backed up every other day, which I would prefer.
Many of my sites, are heavely accessed 24 hours a day, so shutting them down for even 30 minutes every other night isn't acceptable either.
Thanks
T

dnanian 11-04-2006 09:32 PM

Actually, try excluding the MySQL databases from the backup. My guess is that MySQL is switching into a "no cache" mode when you try to back them up directly.

Instead, I'd suggest using mysqldump to dump the database to a file before backing up. Exclude the "real" databases, and then you should be all set.

tspore 11-04-2006 09:40 PM

Quick reply, thanks!
Well the DB's are on the G5 already and seperate from the webservers, because on the G5 I have redundancy, so that they are backed up already. They communicated to the other 2 servers via FW, as does Superduper.
They do get dumped regularly.
But for example right now I was running a mini backup, and it was blowing through at 43 MB a/sec... This left no room in the FW connection for the mysql to transfer through on the connection when the 30+ member at this instant were accessing 1 of the 30 DB driven websites.
(Software on the sites such as Vbulleting, and joomla...)
So the only fix I see is to somehow tell Superduper to only read/write at 15-20 MB a second or some such thing.

dnanian 11-04-2006 09:44 PM

Got ya. Sorry -- I don't know of any way to limit our transfer rate other than perhaps nice-ing down the SDCopy process once it kicks off, but I don't even think that'd do it...


All times are GMT -4. The time now is 05:34 AM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.