Click to enlarge
Back It Up
Safeguard your investment and avoid lost revenue by making data availability a priority.
When you think about your shiny-new data warehouse and all the important business decisions it’s going to enable, backing up its data may not be top of mind. But it should be. Data availability is critical to every organization making real-time business intelligence (BI) decisions.
Data unavailability can be very costly when you consider things such as lost revenue if a call center can’t access customer information, lost time recreating data repositories and penalties for failing to meet data-retention regulations. To ensure business continuity and compliance with global regulations, and to keep up with exponential growth in data volumes, an organization’s information must be kept safe and readily accessible, with minimal impact to data warehouse activities.
That’s why a high-performing backup, archive and restore (BAR) solution is the best way to protect a data warehouse investment while providing a significant, cost-saving business benefit.
BAR is an integral component of a complete data warehouse solution that provides business continuity through data protection and recovery. To ensure an organization’s data will always be available, Teradata® offers BAR capabilities that enable data security, storage and retrieval.
The Teradata Database features a unique massively parallel processing (MPP) architecture that provides high-performance results and high-speed data flow. An optimized advocated Teradata BAR solution leverages this parallel data flow in and out of the database to achieve the fastest backups and restores.
The BAR solution will be different for every organization depending on the size and type of the Teradata system, the backup and recovery window requirements, and the budget. However, all solutions consist of components built to meet optimal performance standards, including:
The hardware infrastructure is fairly traditional: an Ethernet network connects each Teradata node to media servers, which in turn connect to the target storage, disk or tape. The media servers, called “BAR Servers,” combine with the network infrastructure between the nodes and the servers to form the “BAR Framework.” (See figure.) The hardware offers several benefits:
- A single Teradata BAR solution can support multiple Teradata platforms from the enterprise data warehouse to appliances. By scheduling backup jobs to occur sequentially, a single investment can be leveraged across production, test and development environments.
- All Teradata systems are connected to the BAR network, enabling access to the BAR Servers and storage targets.
- BAR Servers are available with a variety of I/O adapter options, including 1Gb or 10Gb Ethernet and 8Gb Fibre Channel, to allow a single server to support both disk and tape target devices.
The necessary network bandwidth must be available to meet the desired performance rates. With multiple, parallel data streams being sent from each node, most BAR implementations include a dedicated backup infrastructure because an imbalance or degradation of a single stream could create a bottleneck that reduces overall backup performance.
Most Teradata customers use tape backup because of its lower cost, portability and fast performance. Tape can also be easily encrypted for off-site storage. The Scalar portfolio from Quantum offers organizations a full range of library sizes and capabilities.
Many companies are also looking at disk-based backup for added reliability and the reduction of needed data storage, due to data deduplication capabilities. Teradata partners with EMC to offer Data Domain deduplication storage systems.
The Teradata Extension is a combination of software products that enables communication and data movement between Teradata and third-party backup applications. The extension includes:
- Teradata Archive/Recovery Utility (ARC) to facilitate the backup and restore of objects into the Teradata Database.
- Teradata Tiered Archive/Restore Architecture (TARA) applications. These components provide the graphic interface for creation and management of backup jobs, storing job metadata and direct communication to the third-party applications.
The advocated backup application, Symantec NetBackup, offers the ability to perform inline and parallel copying. It also has a tightly integrated vaulting application for tape and disk, and it enhances the performance of the Data Domain deduplication systems via the OpenStorage Technology protocol.
SERVICE, SUPPORT AND DELIVERY
To make communication with Teradata simple, Teradata Customer Services provides a single point of contact for all BAR support and maintenance needs. Organizations can turn over all support issues to one point person at Teradata who has the expertise to maintain, update, upgrade and monitor the BAR solution.
To get started, Teradata’s pre-sale consultants evaluate the backup and retention requirements for each system, database and/or table to understand the recovery point and recovery time objectives. The consultants also evaluate the type of backup jobs (e.g., all AMP versus multi-stream), node generations, performance characteristics and optimal number of data streams. These data points allow for a complete disk- and/or tape-based backup solution to be designed inline with the organization’s requirements. Then, an advocated BAR solution is built and delivered in conjunction with a new Teradata system installation or as a stand-alone project.
Teradata also provides planning and onsite integration, which covers:
- Installing products in rack-mount cabinets
- Implementing the software
- Configuring the BAR network
- Validating the system performance
- BAR training
Protect Your Investment
Not having data available is disruptive and costly so backing up data should not be an afterthought. Regulatory compliance requirements and the increasing use of the data warehouse for real-time operations drive the need for a high-performing advocated BAR solution.
Teradata’s advocated BAR product and services portfolio ensures optimum backup and restore performance along with comprehensive single-vendor support to meet an organization’s need for accessing and retaining data.