Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Difference between RDS and Redshift

Can anyone list down the main differences between Amazon Redshift and RDS? I know both are relational DB's but why choose one over the other ?

like image 506
Mateen Sajjad Avatar asked Apr 19 '16 06:04

Mateen Sajjad


1 Answers

RDS is a managed service for Online Transaction Processing databases (OLTP), i.e. a managed service for the usual MySQL, PostgreSQL, Oracle, MariaDB, Microsoft SQL Server or Aurora (Amazon's own relational database)

Redshift is a managed service for data warehousing, i.e. columnar oriented storage, typical for business analytics type of workloads.

like image 116
Sébastien Stormacq Avatar answered Oct 19 '22 05:10

Sébastien Stormacq