fbpx

Teradata In The Cloud

By DWH Pro Admin

January 28, 2020


Teradata moved towards the cloud in order not to lose the connection to modern cloud databases.

How the essential things like security, backups, sizing are solved, I show you with the AWS Cloud solution from Teradata.

Is the Teradata architecture in the cloud the same as before?

The basic architecture is the same.

The database software is unchanged. Teradata has been adapted to the infrastructure of AWS.

On an on-premises Teradata, all services are executed on hardware servers. In the AWS cloud, each node runs on a computing instance (a virtual server).

This means certain limitations (BYNET is not running on Infiniband in AWS) and new features that were not available before.

While an on-premise Teradata system is optimized for IO throughput, this is not the case in the AWS Cloud.

What components of AWS are used to emulate an on-premise Teradata system?

EC2 instances provide the nodes. Data is stored in Elastic Block Stores (EBS).

Teradata uses only SSD in the cloud to optimize IO throughput (in principle, hard disks would also be provided).

How secure is my data in AWS?

Fallback Protection is activated if at least two nodes exist.

The EBS is automatically replicated within the availability zone. This is equivalent to mirroring data (Raid 1).

Backups can be created on the S3 file system.

The data on an EBS is also stored encrypted.

How can a Teradata system be expanded in the cloud?

Compute nodes (EC2 instances) can be exchanged (upscaling), or Instances can be added (out scaling).

Adding storage space is associated with the usual problems of a shared noting system. This is one of the reasons why Teradata has introduced the MAPS architecture.

The MAPS architecture makes it no longer necessary to redistribute data as soon as storage space is increased, but this process can be delayed.

Nevertheless, Teradata can keep up with the elasticity of modern cloud databases like Snowflake, which scales immediately.

How is the Hot-Standby Node implemented?

These are available, but no longer necessary in AWS.

Since instances can be booted at any time, there is the so-called Node Failure Recovery Feature. A computing instance is started as soon as a node crashes, and the Elastic Block storage from the failed node is coupled to the new node.

Does Teradata have the same workload management in the AWS cloud as on the on-premise systems?

The Base license has no workload management; the Advanced license only has Teradata Integrated Workload Management (TIWM).

Only the Enterprise License comes with TASM.


__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"62516":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"62516":{"val":"var(--tcb-skin-color-0)"}},"gradients":[]},"original":{"colors":{"62516":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"b4fbe":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"b4fbe":{"val":"rgb(241, 99, 52)"}},"gradients":[]},"original":{"colors":{"b4fbe":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
Previous Article
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"b4fbe":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"b4fbe":{"val":"rgb(241, 99, 52)"}},"gradients":[]},"original":{"colors":{"b4fbe":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
Next Article
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"62516":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"62516":{"val":"rgb(255, 0, 0)"}},"gradients":[]}}]}__CONFIG_colors_palette__
GET OUR TERADATA BOOK

DWH Pro Admin

Roland Wenzlofsky is an experienced freelance Teradata Consultant & Performance Trainer. Born in Austria's capital Vienna, he is building and tuning some of the largest Teradata Data Warehouses in the European financial and telecommunication sectors for more than 20 years. He has played all the roles of developer, designer, business analyst, and project manager. Therefore, he knows like no other the problems and obstacles that make many data warehouse projects fail and all the tricks and tips that will help you succeed.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

You might also like

>