• It is a fast, scalable data warehouse
  • Used to analyze all data across data warehouse and data lake.
  • Integrates with machine learning, parallel query execution, and columnar storage.
  • Setup and deploy a new data warehouse in minutes
  • Run queries across petabytes in Redshift, and exabytes in data lake.
  • uses columnar storage, data compression, and zone maps to reduce I/O to perform queries.
  • Has a massively parallel processing (MPP) architecture to parallelize and distribute SQL operations
  • stores three copies of your data — all data written to a node in cluster is automatically replicated to other nodes within the cluster, and all data is continuously backed up to Amazon S3.
  • Snapshots are automated, incremental, and continuous and stored for a user-defined period (1-35 days)
  • Manual snapshots can be created and are retained until deleted.
  • Continuously monitors health of cluster
  • Automatically re-replicates data from failed drives and replaces nodes as necessary.
  • has three pricing components:
    • data warehouse node hours – total number of hours run across all the compute node
    • backup storage – storage cost for automated and manual snapshots
    • data transfer
      • There is no data transfer charge for data transferred to or from Amazon Redshift outside of Amazon VPC
      • Data transfer to or from Amazon Redshift in Amazon VPC accrues standard AWS data transfer charges.
  • number of nodes can be easily scaled as per demand

Monitoring Amazon RDS

  • Amazon RDS Events – Subscribe to Amazon RDS events to be notified when changes occur with a DB instance, DB cluster, DB snapshot, DB cluster snapshot, DB parameter group, or DB security group.
  • Database log files – View, download, or watch database log files using the Amazon RDS console or Amazon RDS API actions. You can also query some database log files that are loaded into database tables.
  • Amazon RDS Enhanced Monitoring — Look at metrics in real time for the operating system that your DB instance or DB cluster runs on.
  • Amazon CloudWatch Metrics – Amazon RDS automatically sends metrics to CloudWatch every minute for each active database instance and cluster.
  • Amazon CloudWatch Alarms – Watch a single Amazon RDS metric over a specific time period, and perform actions based on the value of the metric relative to a threshold you set.
  • Amazon CloudWatch Logs – MariaDB, MySQL, and Aurora MySQL enable you to monitor, store, and access your database log files in CloudWatch Logs.

Menu