Amazon Redshift

Amazon Cloud Concepts Learning --> Day25

Amazon Redshift

• A fully managed cloud data warehouse solution that can store petabytes of data.

• Online Analytics Processing (OLAP) type of DB.

Amazon Redshift Features

• For processing massive volumes of data for business analytics, RedShift is perfect.

• Only supports Single-AZ deployments.

• Compared to a conventional SQL database, RedShift is ten times quicker.

• RedShift has the capacity to store enormous volumes of data, however it is unable to instantly ingest such volumes of data in real time.

• Features parallel processing and columnar data stores which are optimized for complex queries.

• Extremely cost-effective as compared to some other on-premises data warehouse platforms.

• Columnar data storage is utilized by RedShift

  ✓ Data is stored sequentially in columns instead of rows.

  ✓ Columnar based DB is ideal for data warehousing and analytics.

  ✓ Requires fewer I/Os which greatly enhances performance.

• A single node has a capacity of 160GB, while clusters may hold up to a petabyte or more.

• Storage options are SSD and HDD.

• Although users cannot directly access their AWS RedShift cluster nodes, they may do so via apps.

Amazon Redshift Availability & Durability

• RedShift can automatically recover from component and node failures and employs replication and continuous backups to increase availability and durability.

• Only available in one AZ but you can restore snapshots into another AZ.

• Redshift regularly backs up your data to Amazon S3 and replicates it inside your data warehouse cluster.

• By default, Amazon Redshift retains backups for 1 day. You can configure this to be as long as 35 days.

• Keeps Three copies of data

  ✓ Original

  ✓ A Replica on Compute Nodes

  ✓ A Backup of S3

• RedShift provides continuous/incremental backups:

  ✓ Multiple copies within a cluster.

  ✓ Continuous and incremental backups to S3.

  ✓ Continuous and incremental backups across regions.

  ✓ Streaming restores.

• RedShift provides fault tolerance for the following failures:

  ✓ Disk failures.

  ✓ Node failures.

  ✓ Network failures.

  ✓ AZ/region level disasters.

• RedShift can asynchronously replicate your snapshots to S3 in another region for DR

Amazon Redshift Security

• Additionally encrypted are snapshots made from the encrypted cluster.

• Encryption via SSL is supported while data is sent between client apps and the Redshift cluster data warehouse.

Additional Resources and Reference

https://docs.aws.amazon.com/redshift/latest/mgmt/welcome.html

https://www.amazonaws.cn/en/redshift/faqs/

---

"Thank you for reading! If you found this blog helpful, don't forget to subscribe and follow for more insightful content. Your support keeps me motivated to bring you valuable insights. Stay updated and never miss out on our latest posts. Feel free to leave comments or suggestions for future topics. Happy learning!"

https://awslearner.hashnode.dev/amazon-web-services-via-category

https://awslearner.hashnode.dev/aws-beginner-level-project-ideas