The engineers dilemma - Cheap, Fast, Reliable - Pick any two...
Now, with Delta Dumpa, you can finally pick all three!
Delta Dumpa (DD) servers are typically white-box items using mass produced components. Redundant arrays (RAID) of high capacity SATA drives provide excellent price per terabyte without compromising throughput or reliability. Resources (space, cpu, memory, network) can be spread over multiple servers with extensive use of open-source software reducing licensing implications. DD will handle all backups and restores, freeing up your DBA staff to handle other important tasks such as addressing security and performance concerns. De-duplication and high compression ensure DR sites can be updated with minimal WAN data costs.
Reliability is attained through several mechanisms: During the backup process failed dumps are retried intelligently giving them an excellent chance of succeeding, with various reporting mechanisms highlighting any persistent errors. At the hardware level, use of RAID disks and syncing of dumps between load-balance servers ensures that the effects of failures are not felt by the system nor lead to data or service loss. Getting production data off site (to a DR system) ensures data integrity under catastrophic conditions, and 'load upon arrival' ensures that the remote SQL-servers are properly tested, applicable space is available etc.
By compressing data at source, dump speeds of over 350 megabytes per
second are achieved. Using large disk arrays with deep caching, high
sustained throughput is achieved. Combinations of differential and
transaction log dumps ensure data delivery of consistently high
speeds. When necessary, bonded networks are used to facilitate
parallelism and even higher throughput.
On many databases de-duplication techniques reduce the dump size to less than 1% of the original size, enabling extremely fast syncs to remote DR sites.