Technical stack design and chosen is very important for initial stage start-ups. If we can do it right, the future issues could be avoided. There are many factors to build a scalable, cost efficient, high-performance system, but we will discuss a lot bit of the database vendor choices.
AWS RDS vs MySQL
MySQL is the most widely used database which supports ACID:
Compare with MongoDB (NoSQL), MySQL (RDBMS) can be used in the transactional system. Lots of e-commerce systems use MySQL as the core trading database. It is free, mature, with a big technical community.
AWS RDS is a mantainance free MySQL system, you don't have to do:
It provides the features such as:
Compare the price of the RDS with the same CPU/disk EC2 instance (db.m4.large vs m4.large):
|Aspect||m4.large (EC2)||db.m4.large (RDS)||Multi-az RDS|
|Memory||8 GB||8 GB||8 GB|
|CPU||2 vCPUs||2 vCPUs||2 vCPUs|
You can see the on-demand price of RDS is roughly double the price of self-managed MySQL on the similar EC2 instance; the price of multi-az RDS doubles the single instance RDS.