Rest API + AWS RDS Demo

How to develop rest api with AWS RDS and test it locally.

Pre-Requisite

1. Eureka service Git Hub -

2.Restaurent Service

USer Service

Git hub -

https://github.com/anerurkar/restaurantsrepo

https://github.com/anerurkar/user-service

3. AWS free tier account

4. AWS RDS MySQL DB created

Steps

1. Download the source code into local

2, Import it into eclipse workspace

3. login to AWS free tier account-> create MYSql DB Instance as below

host= restaurent-db-instance.cvws40ggkvwc.us-east-1.rds.amazonaws.com

port =3306

Edit applition.yml file to point to aws rds as below

server:

port: 9091

spring:

profiles:

active: local

application:

name: RESTAURANT-SERVICE

datasource:

url: jdbc:mysql://restaurent-db-instance.cvws40ggkvwc.us-east-1.rds.amazonaws.com:3306/restaurantdb

username: admin

password: password

driver-class-name: com.mysql.cj.jdbc.Driver

jpa:

hibernate:

ddl-auto: update

show-sql: true

database-platform: org.hibernate.dialect.MySQL5InnoDBDialect

3. Click Run=maven install

4. Run application

5. Test api in postman as below

UserService

===