Run the Teradata Database in your private cloud instead of a dedicated physical server for testing and development.

Tech2Tech

Applied Solutions

The Flexibility of Virtualization

Run the Teradata Database in your private cloud instead of a dedicated physical server for testing and development.

Test and development flexibility is critical to effectively provide superior analytical capability. Thorough testing, unencumbered by system availability or usage restrictions, increases quality. Conversely, delayed or restricted test and development efforts reduce value to the business by postponing a new application rollout or software upgrade.

Configurations and Prerequisites

Teradata Virtual Machine Edition (VME) consists of a plug-in for the VMware vSphere console and three preconfigured VMware templates. The plug-in adds dialogs to the familiar vSphere graphical interface for deploying and administering virtual machines containing the Teradata Database.

Each of the templates contains a pre-installed Teradata Database with a fixed maximum size and configuration running on a virtual symmetric multiprocessing system (SMP) system. Having three configurations simplifies managing private cloud resource allocation and utilization. Using Teradata VME requires:

  • VMware ESX 4.0, VMware ESXi 5.0 or higher
  • The disk space to fully instantiate one of the templates:
    • Small 155GB
    • Medium 395GB
    • Large 2.475TB
  • Additional OS disk space for maintenance release management

Traditional installation of a new database to support advanced application development and prototyping, or to try a new software release or feature, can be a complex and time-consuming challenge. The Teradata® Virtual Machine Edition (VME) allows for fast, easy deployment within an organization’s enterprise VMware environment. It leverages the cost-effective flexibility of a VMware private cloud for the creation of a robust and supported Teradata Database for test and development purposes. This allows a VMware private cloud administrator to launch a new database within minutes, not hours or days.

Virtual Machine, Functional Database

By clicking a few buttons in the vSphere console and entering some information, such as network IP addresses to access the virtual machine once it’s deployed, an administrator can easily launch a virtual machine with the Teradata Database pre-installed and configured. Database installation is not required. Once VMware creates the machine—which usually takes less than 20 minutes—the database can be accessed by any Teradata client product or application.

The software pre-installed in the virtual machines is the same that Teradata installs on physical members of the workload-specific platform family. The functionality is therefore identical to a Teradata production system. While the performance will be slower and more varied than on a physical server due to the virtualization layer and overhead, queries and applications will behave the same.

The database software is supported by Teradata Customer Services. New virtual machine templates containing database maintenance releases will be made available in accordance with regular software support policies. Upgrades will also take place with each Teradata Database release.

Create, Test, Discard

Performing test and development activities in a private cloud has advantages beyond not having to procure a new physical symmetric multiprocessing (SMP) server or arrange for space and power in the data center for each deployment. A system can be launched for ongoing use just like with a physical SMP server. Or, because of the private cloud flexibility, a virtual system can be created to meet a temporary need or situation.

For example, a DBA can request a virtual machine to try a physical database design change, such as the creation of Aggregate Join Indexes or changing a table to hybrid columnar storage. A new system could be deployed, sample data loaded, and the change tested all within a matter of hours or days. The primary test system remains in sync with the production system; ongoing production and test work is not impacted. Once the trial is completed, the virtual machine can be discarded by the private cloud administrator via the vSphere plug-in. The resources are then immediately available for other purposes.

Database upgrade testing is another temporary use in which an additional system can accelerate new application delivery or performance improvement. Teradata VME eliminates the need to free up a system and upgrade its software to verify a Teradata Database release. Instead, an organization can set up a new virtual machine with the database release or replace an existing machine while preserving the data that is already loaded into the database. No changes are made to the physical production system or other test systems. This means there is no effect on or exposure to the production environment until the organization is ready to roll the upgrade forward to those systems.

Teradata VME Configurations

Click to enlarge

High-Powered Flexibility

Teradata VME provides flexibility throughout the development, test and support lifecycle. VMware ESXi is a highly available, data center class infrastructure with full network and multi-user access. Unlike using the free demo-class Teradata Express software, Teradata VME and VMware ESXi provide the setting and power for a multi-person development group to test a large application in a realistic SMP setting.

However, the private cloud and virtualization also offer the ability to give individual developers or testers their own system. They can work on an advanced development project to use Teradata Temporal for capturing historical changes to key data and introduce new temporal analysis options into an existing business application.

Databases can be deployed in any way for the most efficient and effective support of applications. A team can even load a standardized data set into a database and then create a new VMware template. Each virtual machine created with this template will immediately have the identical data, pre-loaded and ready to use without the need to run Teradata load jobs or to verify that the test environment is at the standard baseline.

Drive Value

With Teradata VME, applications can be tested more thoroughly and new applications or incremental enhancements can be deployed sooner to bring more value to the business. By isolating activities on a virtual machine, any impact on other systems or production work is avoided. Once sample data is created or copied from the other systems, there is no risk to ongoing work. Imagine how your organization can benefit by leveraging your private cloud for flexible Teradata Database testing and development.


Your Comment:
  
Your Rating:

Comments
Fuzzy Logix