Introduction to Amazon RDS
Amazon RDS offers traditional relational databases as fully managed services on the AWS platform. Ideal for transactional database requirements, also known as OLTP, AWS offers six different database engines, as follows:
- MySQL
- PostgreSQL
- MariaDB
- Microsoft SQL server
- Oracle
- Amazon Aurora
Another term you might have heard of is Relational Database Management System (RDBMS). An RDBMS performs functions to create, read, update, and delete (CRUD) data from the database using an underlying software component, which we call the database engine.
An important point to understand here is that when you choose to set up an Amazon RDS database, you are setting up a database instance with a chosen engine to run on that instance. You can then create one or more databases supported by that engine on your database instance. This means you can have several databases running on an individual database instance.
Furthermore, on Amazon...