AWS Database

RDS

RDS can be defined as Relational Database Service. RDS is a database as a service that automatically configured and maintains the databases in the AWS cloud. For Example in our day to day life we use Netflix and many other services to watch movies and web series etc.. so we the films in that app is stored as a database.. so whenever we search for any movie that movie is sorted out using that database.. all this done by RDS.

Using MySQL on RDS as a service

With Amazon RDS, you can deploy scalable MySQL servers in minutes with cost-efficient and resizable hardware capacity.

1. Go to AWS Management Console. And search for the RDS in the search bar of services section.

2. In the Create database section, choose Create database.

3.

4.

By following the above steps we can create the database…

Using DynamoDB as a service

Amazon DynamoDB is a fast and flexible NoSQL database service for all applications that need consistent, single-digit millisecond latency at any scale. It is a fully managed cloud database and supports both document and key-value store models. Its flexible data model and reliable performance make it a great fit for mobile, web, gaming, ad tech, IoT, and many other applications. Amazon DynamoDB Accelerator (DAX) is a fully managed, highly available, in-memory cache that can reduce Amazon DynamoDB response times from milliseconds to microseconds, even at millions of requests per second.

SQL Vs NoSQL

1. SQL databases are relational, NoSQL are non-relational.
2. SQL databases use structured query language and have a predefined schema. NoSQL databases have dynamic schemas for unstructured data.
3. SQL databases are vertically scalable, NoSQL databases are horizontally scalable.
4. SQL databases are table based, while NoSQL databases are document, key-value, graph or wide-column stores.
5. SQL databases are better for multi-row transactions, NoSQL are better for unstructured data like documents or JSON.

Thank you!