TweetFollow Us on Twitter

Building a Backup System on the Mac

Volume Number: 22 (2006)
Issue Number: 4
Column Tag: Tools of the Trade

Building a Backup System on the Mac

by Neil Ticktin, Publisher/Editor-in-Chief

Unless you like tempting fate, or are a masochist, backups are a necessary part of any computer setup. Whether you have just one machine, or are in an Enterprise environment, you have to think about backups. There are a variety of reasons why you do backups. Sure, you may want to provide against the obvious hardware failure, but backups also give you protection against hackers, viruses, newly installed software, missing computers, and the ever-present user error.

There are a number of solutions for the home network or individuals that are out there, and there are high-end solutions for large networks and Enterprise environments. This article, however, talks about a multi-vendor approach that we took on a real world network.

There have been articles out there about what to do with your older machines, but we thought that we would take the approach of using a combination of existing hardware, upgrades and modern technology to create a solid backup solution for a small to medium size business.

Software, Media and The Test Scenario

We wanted to test our newly built system with a scenario that may be typical of many small to medium size businesses. In this scenario, we had one "main" location with about 15 machines, one satellite office with another 5 machines, and one telecommuter.

Many people today like backing up to a disk drive. It's fast. It's very reliable, and, disks are relatively cheap these days. I agree. In fact, we make sure that we have a clone of main web server's hard drive available at all times, so that it can be back up and running in no time. But one thing that hard drives don't do for you is give you "snapshots" in time which are the ultimate protection against viruses, hacking, newly installed software and user error.

If you want snapshots, as we do, then you need two things: software that does that for you, and a medium that supports it well. Some of the backup software out there does not support snapshots as completely as I would like, or is the wrong "size" of software, so we chose Retrospect 6.1 as our base. Furthermore, while we do have hard drives as part of our strategy, tape is our medium of choice simply because it's easy to have multiple sets of data (so that some are off-site and some are on-site). It's also very inexpensive for large volumes of data.

The main location has the largest data sets: databases, web sites, file servers, email, and the dedicated backup server. With remote locations backing up to the main location, we wanted to have dedicated hard drives in the backup server that would be available 24/7 and be the staging area for backup to tape, our primary backup media.

Putting Together the Pieces

This was a fun project as we could look at a variety of wonderful products to put together a great solution for the test scenario. In the articles to follow, written by MacTech's staff, you'll see a number of different technologies. Some are specific to backups, but many of these you can use in a variety of ways to upgrade your machines. And sometimes, upgrading is the most cost effective way to go, especially when you are talking about a platform as reliable as a PowerMac G4.

The PowerMac G4

In the past several years, Apple has made some simply terrific machines. Sure, the new iMacs and MacBooks are obviously wonderful products, but there are others that are solid performers. One such machine is the PowerMac G4, which many of us have laying around in quantities. These machines have solid power supplies, are expandable, and are quite reliable, but they are not the speediest.

We have found that in addition to our higher-end Xserves, and Mac OS X Server, there are a number of things that we can do with PowerMac G4s running plain old Mac OS X (Panther or Tiger).

In creating a backup system, we knew that we wanted to have several hard drives, multiple Ethernet interfaces, high performance I/O, and more. It was easy to choose the expandable PowerMac G4 for this duty as we didn't need the processing power of G5, and we had several of these PowerMac G4s around.

One of the beautiful things about the PowerMac G4 is that you can have 5 drives in it. Even the exceptional PowerMac G5 doesn't have that capability out of the box. Don't get me wrong, you do have options on a PowerMac G5 to go beyond the two drive positions, but you need to look to third party options such as those from WiebeTech and others for drive module expansions. These are specifically designed to give enough cooling even though Apple didn't design these machines to do this. So, make sure that you are relying on a reputable vendor before putting more than two drives in your PowerMac G5.

What Needed To Be Added

Retrospect

The first choice you have to make on the backup system, possibly even before the hardware you are going to run on, is the software. In our case, we wanted something easy-to-use, and even familiar, but that could handle a decent size network. On the Mac, the obvious choice was Retrospect by EMC Insignia.

Retrospect is a great product for the right size market. If you are have thousands of clients, should you use it to back up each of them to a server? Nope. You'll want to look at one of the more "Enterprise" level backup systems, or use a Windows or Linux box as a backup server.

One of the limitations of Retrospect is that it can only perform one backup at a time. For a smaller environment (e.g., the SMB space), this works fine. But if you have high end needs, that's beyond the scope of this article, and you should look at other applications like Netvault by BakBone, bru by Tolis Group, or Time Navigator by Atempo. These types of products have the ability to do multiple backups simultaneously to disk (obviously, all products can only backup to one tape at one time). Take note: while these are great solutions, they are industrial, and some of them can cost a great deal of money, and are likely going to take more effort to set up and manage compared to Retrospect.

To be fair, Retrospect is not designed to backup live files. With that in mind, whether it's our Now Up-to-Date server, our FileMaker Server, or the Xserve, we make sure that the live databases are set up to save off copies of the databases periodically to their local drive, and then when Retrospect comes through, it backs up those snapshots.

If you do want to backup live files, you really need to look at a different type of software (see above) for a more Enterprise level approach.

SQL Backups: Navicat

As you'll see in the article on Navicat, there are a variety of ways to backup MySQL databases, whether at the command line, using open source options, or a commercial product. In the accompanying article, we give you not only the command line information, but took at a look at the commercial application Navicat, which has some really nice backup and restore functions that you can schedule.

Sonnet SATA/IDE Interfaces

We want to use some existing drives, and experiment with both larger ATA/IDE drives (e.g., larger than 128GB) as well as the newer SATA drives. There are a variety of ways to do this, and we chose the Sonnet products to do this. That allowed us to add both RAID and SATA drives to our PowerMac G4. And, when Retrospect is backing up these drives to the tape drive, they scream.

Sonnet Gigabit Ethernet

Since much of the LAN at the main location is gigabit, we wanted to add gigabit Ethernet to the PowerMac G4. And, we didn't want the PowerMac to share that interface for uploads that were being done from the satellite office nor the telecommuter. By adding the Sonnet gigabit Ethernet card, we were able to dedicate that interface to the LAN, and the built-in Ethernet to the Internet backups that were happening. Since everything happens at the same time at night, this optimized the use of the machine.

SDLT 600

We needed a tape drive for this setup. Today, the two formats that have the most support are DLT and LTO. Both are wonderful, and you can read more on these in the SDLT review that we have. In the end, we chose the SDLT 600 which holds 300-600GB per ~$100 tape, and in real life usage regularly gets at least 450GB per tape.

ATTO SCSI-3 Interface

The PowerMac G4 does not have an external SCSI interface. You add that with a PCI card. With that in mind, there's only one company that comes to mind: ATTO. ATTO's SCSI-3 interface cards are excellent. And, if you choose the FibreChannel approach, they have options for you there as well.

Media

You can't backup without media, so we chose the Maxell solutions for both SDLT II tapes as well as cleaning tapes to maintain the Quantum SDLT drive.

Daystar Acceleration

At first, we weren't going to accelerate the PowerMac G4, and to be fair, it did run ok without any acceleration. But we wanted to see what the difference was, so we added in a 1.8GHz accelerator from Daystar, and wow, what a difference. Well worth the $330 for this interface card. Everything runs so much faster and better than without the accelerator.

Conclusion

By using a variety of solutions, and basing it on a PowerMac G4, we were able to focus as much of the resources as possible on the backup media/drive. To us, this allowed us to get the test scenario onto a backup system that was reliable, modern, and would need as few tapes as possible to hold the data being backed up yet. And, this wasn't your typical "test bench" scenario. While we did design it for a diverse test, we grouped these sets of machines together for a real world test that we did over multiple months and worked out all the kinks. It's as real world as it gets!

Of all the things that you can do on the Mac, I think you'll find that backups are one of the most "diverse" set of choices. There are so many different ways to go. You just have to think it through and prioritize. Once you have a set of ordered priorities, you'll find that decisions start falling into place easily.

Hopefully, this article will help you think through your own examples. But again, even if you don't have backups on your mind, check out the accompanying product solutions, as they will apply to much more than just backups.

As always, let us know what you think!


Neil Ticktin is the Publisher/Editor-in-Chief of MacTech Magazine. Neil has been in the Mac industry since 1985. When Neil writes a review, he likes to put solutions into a real-life scenario and then write about that experience from the user point of view. That said, Neil has a reputation around the office for pushing software to its limits and crashing software/finding bugs.

 

Community Search:
MacTech Search:

Software Updates via MacUpdate

Together 3.6.1 - Store and organize all...
Together helps you organize your Mac, giving you the ability to store, edit and preview your files in a single clean, uncluttered interface. Features Smart storage. With simple drag-and-drop... Read more
Cloud 4.1.1 - File sharing from your men...
Cloud is simple file sharing for the Mac. Drag a file from your Mac to the CloudApp icon in the menubar and we take care of the rest. A link to the file will automatically be copied to your clipboard... Read more
OmniFocus 2.7.1 - GTD task manager with...
OmniFocus helps you manage your tasks the way that you want, freeing you to focus your attention on the things that matter to you most. Capturing tasks and ideas is always a keyboard shortcut away in... Read more
CleanApp 5.1.1 - Application deinstaller...
CleanApp is an application deinstaller and archiver.... Your hard drive gets fuller day by day, but do you know why? CleanApp 5 provides you with insights how to reclaim disk space. There are... Read more
ForkLift 3.0 Beta 2 - Powerful file mana...
ForkLift is a powerful file manager and ferociously fast FTP client clothed in a clean and versatile UI that offers the combination of absolute simplicity and raw power expected from a well-executed... Read more
Sublime Text 3126 - Sophisticated text e...
Sublime Text is a sophisticated text editor for code, markup, and prose. You'll love the slick user interface, extraordinary features, and amazing performance. Features Goto Anything. Use Goto... Read more
1Password 6.3.3 - Powerful password mana...
1Password is a password manager that uniquely brings you both security and convenience. It is the only program that provides anti-phishing protection and goes beyond password management by adding Web... Read more
WhatsApp 0.2.1880 - Desktop client for W...
WhatsApp is the desktop client for WhatsApp Messenger, a cross-platform mobile messaging app which allows you to exchange messages without having to pay for SMS. WhatsApp Messenger is available for... Read more
NeoFinder 6.9.3 - Catalog your external...
NeoFinder (formerly CDFinder) rapidly organizes your data, either on external or internal disks, or any other volumes. It catalogs all your data, so you stay in control of your data archive or disk... Read more
Amadeus Pro 2.3.1 - Multitrack sound rec...
Amadeus Pro lets you use your Mac computer for any audio-related task, such as live audio recording, digitizing tapes and records, converting between a variety of sound formats, etc. Thanks to its... Read more

Our 5 Favorite iMessage Sticker Packs
At long last, iMessage joins the ranks of messaging apps the likes of LINE and Whatsapp, adding an impressive collection of stickers. They’re a great way to add a little something extra to your daily conversations. [Read more] | Read more »
How to get past Vulture Island's tr...
Vulture Island is a colorful and quirky mish-mash of platforming and puzzles. It’s creative and fresh, but sometimes the game can throw a curveball at you, leaving you stuck as to how you should progress. These tips will help you explore smoothly... | Read more »
The new Clash of Kings is just for Weste...
If you’ve played the original Clash of Kings, you’ll probably recognise the city building, alliance forging and strategic battles in Clash of Kings: The West. What sets this version apart is that it’s tailor made for a Western audience and the... | Read more »
Frost - Survival card game (Games)
Frost - Survival card game 1.12.1 Device: iOS Universal Category: Games Price: $3.99, Version: 1.12.1 (iTunes) Description: *Warning: the game will work on iPhone 5C and above and iPad Pro / 4. Other devices are not supported* | Read more »
How to build and care for your team in D...
Before you hit the trail and become a dog sledding legend, there’s actually a fair bit of prep work to be done. In Dog Sled Saga, you’re not only racing, you’re also building and caring for a team of furry friends. There’s a lot to consider—... | Read more »
How to win every race in Dog Sled Saga
If I had to guess, I’d say Dog Sled Saga is the most adorable racing game on the App Store right now. It’s a dog sled racing sim full of adorable, loyal puppies. Just look at those fluffy little tails wagging. Behind that cute, pixelated facade is... | Read more »
Let the war games commence in Gunship Ba...
Buzz Lightyear famously said, “This isn’t flying, this is falling – with style!” In the case of Gunship Battle: Second War, though, this really is flying - with style! The flight simulator app from Joycity puts you in control of 20 faithfully... | Read more »
How to get a high score in Fired Up
Fired Up is Noodlecake Games’ high score chasing, firefighting adventure. You take control of a wayward firefighter who propels himself up the side of a highrise with blasts of water. Sound silly? It is. It’s also pretty difficult. You can’t... | Read more »
NBA 2K17 (Games)
NBA 2K17 1.0 Device: iOS iPhone Category: Games Price: $7.99, Version: 1.0 (iTunes) Description: Following the record-breaking launch of NBA 2K16, the NBA 2K franchise continues to stake its claim as the most authentic sports video... | Read more »
Dog Sled Saga (Games)
Dog Sled Saga 1.0.1 Device: iOS Universal Category: Games Price: $3.99, Version: 1.0.1 (iTunes) Description: A game by Dan + Lisa As a rookie musher, foster a dogsledding team whose skills will grow if they're treated right. Week by... | Read more »

Price Scanner via MacPrices.net

15-inch 2.2GHz Retina MacBook Pro on sale for...
B&H Photo has the 2015 15″ 2.2GHz Retina MacBook Pro (MJLQ2LL/A) on sale for $1799, including free shipping plus NY sales tax only. Amazon also has the 2015 15″ 2.2GHz Retina MacBook Pro (... Read more
Toughbook Celebrates 20 Years of Ruggedized M...
Panasonic System Communications Company of North America, Division of Panasonic Corporation of North America (Panasonic) today celebrates the 20th anniversary of its industry-leading Toughbook mobile... Read more
12-inch 1.1GHz Gray Retina MacBook on sale fo...
B&H Photo has the 2016 12″ 1.1GHz Gray Retina MacBook on sale for $1199.99 including free shipping plus NY sales tax only. Their price is $100 off MSRP. Read more
13-inch 2.5GHz MacBook Pro (Apple refurbished...
Apple has Certified Refurbished 13″ 2.5GHz MacBook Pros available for $829, or $270 off the cost of new models. Apple’s one-year warranty is standard, and shipping is free: - 13″ 2.5GHz MacBook Pros... Read more
Save 30% on Camera Guard’s Secure Protection...
To celebrate the release of macOS Sierra, Miami-based security solutions company, ProtectStar has announced a special 30% discount on Camera Guard Professional for Mac 2016. This innovative security... Read more
DVDFab Special Deal – Get a 1-Year Free Licen...
Beijing, China based specialist in the field of DVD, Blu-ray and video backup solutions, Fengtao Software has launched its Autumn Special Deals 2016, giving a 1-year free license of a randomly picked... Read more
21-inch iMacs on sale for up to $120 off MSRP
B&H Photo has 21″ iMacs on sale for up to $120 off MSRP including free shipping plus NY sales tax only: - 21″ 3.1GHz iMac 4K: $1379 $120 off MSRP - 21″ 2.8GHz iMac: $1199.99 $100 off MSRP - 21″ 1... Read more
13-inch 2.7GHz/256GB Retina MacBook Pro on sa...
Amazon.com has the 13″ 2.7GHz/256GB Retina Apple MacBook Pro on sale for $151 off MSRP including free shipping: - 13″ 2.7GHz/256GB Retina MacBook Pro (sku MF840LL/A): $1348 $151 off MSRP Read more
Apple TVs on sale for up to $50 off MSRP
Best Buy has 32GB and 64GB Apple TVs on sale for $40-$50 off MSRP on their online store. Choose free shipping or free local store pickup (if available). Sale prices for online orders only, in-store... Read more
Apple refurbished 13-inch Retina MacBook Pros...
Apple has Certified Refurbished 13″ Retina MacBook Pros available for up to $270 off the cost of new models. An Apple one-year warranty is included with each model, and shipping is free: - 13″ 2.7GHz... Read more

Jobs Board

Restaurant Manager (Neighborhood Captain) - A...
…in every aspect of daily operation. WHY YOU'LL LIKE IT: You'll be the Big Apple . You'll solve problems. You'll get to show your ability to handle the stress and Read more
Sr. *Apple* Mac Engineer - Net2Source Inc....
…staffing, training and technology. We have following position open with our client. Sr. Apple Mac Engineer6+ Months CTH Start date : 19th Sept Travelling Job If Read more
*Apple* Retail - Multiple Positions-Norfolk,...
Job Description: Sales Specialist - Retail Customer Service and Sales Transform Apple Store visitors into loyal Apple customers. When customers enter the store, Read more
Restaurant Manager (Neighborhood Captain) - A...
…in every aspect of daily operation. WHY YOU'LL LIKE IT: You'll be the Big Apple . You'll solve problems. You'll get to show your ability to handle the stress and Read more
Lead *Apple* Solutions Consultant - Apple (...
# Lead Apple Solutions Consultant Job Number: 51829230 Detroit, Michigan, United States Posted: Sep. 19, 2016 Weekly Hours: 40.00 **Job Summary** The Lead ASC is an Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.