Thursday, July 7, 2022
HomeBig DataUse Amazon Redshift RA3 with managed storage in your trendy knowledge structure

Use Amazon Redshift RA3 with managed storage in your trendy knowledge structure

Amazon Redshift is a completely managed, petabyte-scale knowledge warehouse service within the cloud. You can begin with only a few hundred gigabytes of information and scale to a petabyte or extra. This allows you to use your knowledge to amass new insights for what you are promoting and clients.

Over time, Amazon Redshift has developed loads to satisfy our buyer calls for. Its journey began as a standalone knowledge warehousing equipment that supplied a low-cost, high-performance, cloud-based knowledge warehouse. Help for Amazon Redshift Spectrum compute nodes was later added to increase your knowledge warehouse to knowledge lakes, and the concurrency scaling function was added to assist burst exercise and scale your knowledge warehouse to assist hundreds of queries concurrently. In its newest providing, Amazon Redshift runs on third-generation structure the place storage and compute layers are decoupled and scaled impartial of one another. This newest era powers the a number of trendy knowledge structure patterns our clients are actively embracing to construct versatile and scalable analytics platforms.

When spinning up a brand new occasion of Amazon Redshift, you get to decide on both Amazon Redshift Serverless, for if you want an information warehouse that may scale seamlessly and robotically as your demand evolves unpredictably, or you may select an Amazon Redshift provisioned cluster for steady-state workloads and higher management over your Amazon Redshift cluster’s configuration.

An Amazon Redshift provisioned cluster is a group of computing sources referred to as nodes, that are organized into a bunch referred to as a cluster. Every cluster runs the Amazon Redshift engine and incorporates a number of databases. Creating an Amazon Redshift cluster is step one in your means of constructing an Amazon Redshift knowledge warehouse. Whereas launching a provisioned cluster, one choice that you just specify is the node sort. The node sort determines the CPU, RAM, storage capability, and storage drive sort for every node.

On this submit, we cowl the present era node RA3 structure, totally different RA3 node varieties, essential capabilities which can be obtainable solely on RA3 node varieties, and how one can improve your present Amazon Redshift node varieties to RA3.

Amazon Redshift RA3 nodes

RA3 nodes with managed storage allow you to optimize your knowledge warehouse by scaling and paying for compute and managed storage independently. RA3 node varieties are the newest node sort for Amazon Redshift. With RA3, you select the variety of nodes primarily based in your efficiency necessities and solely pay for the managed storage that you just use. RA3 structure provides you the power to measurement your cluster primarily based on the quantity of information you course of each day or the quantity of information that you just need to retailer in your warehouse; there isn’t a must account for each storage and processing wants collectively.

Different node varieties that we beforehand provided embody the next:

  • Dense compute – DC2 nodes allow you to have compute-intensive knowledge warehouses with native SSD storage included. You select the variety of nodes you want primarily based on knowledge measurement and efficiency necessities.
  • Dense storage (deprecated) – DS2 nodes allow you to create massive knowledge warehouses utilizing laborious disk drives (HDDs). If you happen to’re utilizing the DS2 node sort, we strongly advocate that you just improve to RA3 to get twice as a lot storage and improved efficiency for a similar on-demand price.

If you use the RA3 node measurement and select your variety of nodes, you may provision the compute impartial of storage. RA3 nodes are constructed on the AWS Nitro System and have excessive bandwidth networking and enormous high-performance SSDs as native caches. RA3 nodes use your workload patterns and superior knowledge administration strategies to ship the efficiency of native SSD whereas scaling storage robotically to Amazon Easy Storage Service (Amazon S3).

RA3 node varieties are available in three totally different sizes to accommodate your analytical workloads. You possibly can rapidly begin experimenting with the RA3 node sort by making a single-node ra3.xlplus cluster and discover numerous options which can be obtainable. If you happen to’re operating a medium-sized knowledge warehouse, you may measurement your cluster with ra3.4xlarge nodes. For big knowledge warehouses, you can begin with ra3.16xlarge. The next desk provides extra details about RA3 node varieties and their specs as of this writing.

Node Sort vCPU



Default Slices Per Node Managed Storage Quota Per Node Node Vary with Create Cluster Complete Managed Storage Capability
ra3.xlplus 4 32 2 32 TB 1-16 1024 TB
ra3.4xlarge 12 96 4 128 TB 2-32 8192 TB
ra3.16xlarge 48 384 16 128 TB 2-128 16384 TB

Amazon Redshift with managed storage

Amazon Redshift with a managed storage structure (RMS) nonetheless boasts the identical resiliency and industry-leading {hardware}. With managed storage, Amazon Redshift makes use of clever knowledge prefetching and knowledge evictions primarily based on the temperature of your knowledge. This technique helps you determine the place to retailer your most-queried knowledge. Most incessantly used blocks (scorching knowledge) are cached domestically on SSD, and often used blocks (chilly knowledge) are saved on an RMS layer backed by Amazon S3. The next diagram depicts the chief node, compute node, and Amazon Redshift managed storage.

Within the following sections, we talk about the capabilities that Amazon Redshift RA3 with managed storage can present.

Independently scale compute and storage

As the dimensions of a corporation grows, knowledge continues to develop—reaching petabytes. The quantity of information you ingest into your Amazon Redshift knowledge warehouse additionally grows. It’s possible you’ll be on the lookout for methods to cost-effectively analyze all of your knowledge and on the similar time have management over choosing the proper compute or storage useful resource on the proper time. For patrons who want to be price conscientious and cost-effective, the RA3 platform gives the choice to scale and pay in your compute and storage sources individually.

With RA3 cases with managed storage, you may select the variety of nodes primarily based in your efficiency necessities, and solely pay for the managed storage that you just use. This provides you the pliability to measurement your RA3 cluster primarily based on the quantity of information you course of each day with out growing your storage prices. It means that you can pay per hour for the compute and individually scale your knowledge warehouse storage capability with out including any extra compute sources and paying just for what you employ.

One other good thing about RMS is that Amazon Redshift manages which knowledge needs to be saved domestically for quickest entry, and knowledge that’s barely colder remains to be saved inside fast-access attain.

Superior {hardware}

RA3 cases use high-bandwidth networking constructed on the AWS Nitro System to additional scale back the time taken for knowledge to be offloaded to and retrieved from Amazon S3. Managed storage makes use of high-performance SSDs in your scorching knowledge and Amazon S3 in your chilly knowledge, offering ease of use, cost-effective storage, and quick question efficiency.

Extra safety choices

Amazon Redshift managed VPC endpoints allow you to arrange a personal connection to securely entry your Amazon Redshift cluster inside your digital non-public cloud (VPC) from consumer purposes in one other VPC throughout the similar AWS account, one other AWS account, or a subnet with out utilizing public IPs and with out requiring the site visitors to traverse throughout the web.

The next situations describe widespread causes to permit entry to a cluster utilizing an Amazon Redshift managed VPC endpoint:

  • AWS account A desires to permit a VPC in AWS account B to have entry to a cluster
  • AWS account A desires to permit a VPC that can be in AWS account A to have entry to a cluster
  • AWS account A desires to permit a distinct subnet within the cluster’s VPC inside AWS account A to have entry to a cluster

For details about entry choices to a different VPC, seek advice from Allow non-public entry to Amazon Redshift out of your consumer purposes in one other VPC.

Additional optimize your workload

On this part, we talk about two methods to additional optimize your workload.


AQUA (Superior Question Accelerator) is a brand new distributed and hardware-accelerated cache that allows Amazon Redshift to run as much as 10 occasions quicker than different enterprise cloud knowledge warehouses by robotically boosting sure sorts of queries. AQUA is on the market with the ra3.16xlarge, ra3.4xlarge, or ra3.xlplus nodes at no extra cost and with no code modifications.

AQUA is an analytics question accelerator for Amazon Redshift that makes use of custom-designed {hardware} to hurry up queries that scan massive datasets. AQUA robotically optimizes question efficiency on subsets of the information that require in depth scans, filters, and aggregation. With this strategy, you need to use AQUA to run queries that scan, filter, and combination massive datasets.

For extra details about utilizing AQUA, seek advice from Learn how to consider the advantages of AQUA in your Amazon Redshift workloads.

Concurrency scaling for write operations

With RA3 nodes, you may reap the benefits of concurrency scaling for write operations, akin to extract, rework, and cargo (ETL) statements. Concurrency scaling for write operations is very helpful if you need to keep constant response occasions when your cluster receives numerous requests. It improves throughput for write operations contending for sources on the principle cluster.

Concurrency scaling helps COPY, INSERT, DELETE, and UPDATE statements. In some instances, you may comply with DDL statements, akin to CREATE, with write statements in the identical commit block. In these instances, the write statements aren’t despatched to the concurrency scaling cluster.

If you accrue credit score for concurrency scaling, this credit score accrual applies to each learn and write operations.

Elevated agility to scale compute sources

Elastic resize means that you can scale your Amazon Redshift cluster up and down in minutes to get the efficiency you want, if you want it. Nevertheless, there are limits on the nodes which you can add to a cluster. With some RA3 node varieties, you may enhance the variety of nodes as much as 4 occasions the present rely. All RA3 node varieties assist a lower within the variety of nodes to 1 / 4 of the present rely. The next desk lists progress and discount limits for every RA3 node sort.

Node Sort Progress Restrict Discount Restrict
ra3.xlplus 2 occasions (from 4 to eight nodes, for instance) To 1 / 4 of the quantity
ra3.4xlarge 4 occasions (from 4 to 16 nodes, for instance) To 1 / 4 of the quantity (from 16 to 4 nodes, for instance)
ra3.16xlarge 4 occasions (from 4 to 16 nodes, for instance) To 1 / 4 of the quantity (from 16 to 4 nodes, for instance)

RA3 node varieties even have a shorter period of snapshot restoration time due to the separation of storage and compute.

Improved resiliency

Amazon Redshift employs in depth fault detection and auto remediation strategies so as to maximize the supply of a cluster. With the RA3 structure, you may allow cluster relocation, which gives extra resiliency by being able to relocate a cluster throughout Availability Zones with out dropping any knowledge (RPO is zero) or having to vary your consumer purposes. The cluster’s endpoint stays the identical after the relocation happens so purposes can proceed working with out modifications. As the present cluster fails, a brand new cluster is created on demand in one other Availability Zone so price of a standby reproduction cluster is averted.

Speed up knowledge democratization

On this part, we share two strategies to speed up knowledge democratization.

Information sharing

Information sharing gives on the spot, granular, and high-performance entry with out copying knowledge and knowledge motion. You possibly can question reside knowledge continuously throughout all shoppers on totally different RA3 clusters in the identical AWS account, in a distinct AWS account, or in a distinct AWS Area. Information is shared securely and gives ruled collaboration. You possibly can present entry in several granularity, together with schema, database, tables, views, and user-defined capabilities.

This opens up numerous new use instances the place you could have one ETL cluster that’s producing knowledge and have a number of shoppers akin to ad-hoc querying, dashboarding, and knowledge science clusters to view the identical knowledge. This additionally permits bi-directional collaboration the place teams akin to advertising and marketing and finance can share knowledge with each other. Queries accessing shared knowledge use the compute sources of the patron Amazon Redshift cluster and don’t affect the efficiency of the producer cluster.

For extra details about knowledge sharing, seek advice from Sharing Amazon Redshift knowledge securely throughout Amazon Redshift clusters for workload isolation.

AWS Information Alternate for Amazon Redshift

AWS Information Alternate for Amazon Redshift allows you to discover and subscribe to third-party knowledge in AWS Information Alternate which you can question in an Amazon Redshift knowledge warehouse in minutes. You too can license your knowledge in Amazon Redshift by means of AWS Information Alternate. Entry is robotically granted when a buyer subscribes to your knowledge and is robotically revoked when their subscription ends. Invoices are robotically generated, and funds are robotically collected and disbursed by means of AWS. This function empowers you to rapidly question, analyze, and construct purposes with third-party knowledge.

For particulars on how one can publish an information product and subscribe to an information product utilizing AWS Information Alternate for Amazon Redshift, seek advice from New – AWS Information Alternate for Amazon Redshift.

Cross-database queries for Amazon Redshift

Amazon Redshift helps the power to question throughout databases in a Redshift cluster. With cross-database queries, you may seamlessly question knowledge from any database within the cluster, no matter which database you might be linked to. Cross-database queries can get rid of knowledge copies and simplify your knowledge group to assist a number of enterprise teams on the identical cluster.

Considered one of many use instances the place Cross-database question helps you is when knowledge is organized throughout a number of databases in a Redshift cluster to assist multi-tenant configurations. For instance, totally different enterprise teams and groups that personal and handle knowledge units of their particular database in the identical knowledge warehouse must collaborate with different teams. You may need to carry out widespread ETL staging and processing whereas your uncooked knowledge is unfold throughout a number of databases. Organizing knowledge in a number of Redshift databases can be a standard state of affairs when migrating from conventional knowledge warehouse techniques. With cross-database queries, now you can entry knowledge from any of the databases on the Redshift cluster with out having to connect with that particular database. You too can be part of knowledge units from a number of databases in a single question

You possibly can learn extra about cross-database queries right here.

Improve to RA3

You possibly can improve to RA3 cases inside minutes regardless of the scale of your present Amazon Redshift clusters. Merely take a snapshot of your cluster and restore it to a brand new RA3 cluster. For extra data, seek advice from Upgrading to RA3 node varieties.

You too can simplify your migration efforts with Amazon Redshift Easy Replay. For extra data, seek advice from Simplify Amazon Redshift RA3 migration analysis with Easy Replay utility.


On this submit, we talked concerning the RA3 node varieties, the advantages of Amazon Redshift managed storage, and the extra capabilities that you just get by utilizing Amazon Redshift RA3 with managed storage. Migrating to RA3 node varieties isn’t a sophisticated effort, you may get began in the present day.

In regards to the Authors

Bhanu Pittampally is an Analytics Specialist Options Architect primarily based out of Dallas. He makes a speciality of constructing analytic options. His background is in knowledge warehouses—structure, improvement, and administration. He has been within the knowledge and analytics discipline for over 13 years.

Jason Pedreza is an Analytics Specialist Options Architect at AWS with knowledge warehousing expertise dealing with petabytes of information. Previous to AWS, he constructed knowledge warehouse options at He makes a speciality of Amazon Redshift and helps clients construct scalable analytic options.



Please enter your comment!
Please enter your name here

- Advertisment -
Google search engine

Most Popular

Recent Comments