AWS Classroom Series – 27/Oct/2021

Relational Databases

• Scenario 1: Hosting the Database on your Data center On-premises
• Scenario 2: Hosting the Database on AWS EC2 (Virtual Machine) Servers
• Scenario 3: Hosting the database using Amazon RDS

Understanding the Amazon Relational Database Service (RDS)

• AWS provides service for hosting and managing the relational databases called RDS. Using this service, you can host the following RDBMS Engines
  • Aurora MySQL
  • Aurora PostgreSQL
  • Oracle
  • SQL Server
  • MySQL
  • PostgreSQL
  • MariaDB
• Benefits of running databases on RDS
  • No infrastructure Management
  • Instant Provisioning: We can deploy the RDMS of your choice in few minutes
  • Scaling: RDS is easy to scale, with few clicks we can scale up or down
  • Cost-effective: You pay only for what you use & there is no minimum setup fees.
  • Highly Available: Using RDS, you can provision a database in multiple AZs, Amazon RDS replicates your data to a standby instance in a different AZ
  • Security

Lets create a free-tier AWS RDS instance

• Database Engine: MySQL

• free tier size: db.t2.micro

• Lets create

• Lets open port in security group for communication

• Now to connect to this databse we need endpoint and credentials

• To connect to mysql database we need mysql clients

  • mysql commandline
  • mysql workbench

• Lets install mysql workbench Refer Here

• Applications use connection string to connect to the database

  • Java:
  • .net (C#):
  • Python: