Amazon RDS | Deploy Spring Boot + MySQL CRUD Application into Elastic Beanstalk | JavaTechie

This tutorial will guide you ,how to integrate Spring boot application with MySQL using Amazon RDS and how to Deploy Spring Boot + MySQL CRUD Application into Elastic Beanstalk
#javatechie #AWS #RDS #SpringBoot
GitHub:
github.com/Java-Techie-jt/spr...
Blogs:
/ javatechie
Facebook:
/ 919464521471923
guys if you like this video please do subscribe now and press the bell icon to not miss any update from Java Techie
Disclaimer/Policy:
--------------------------------
Note : All uploaded content in this channel is mine and its not copied from any community , you are free to use source code from above mentioned GitHub account

[@rajyahoob]

thank you again for concise and clear tutorials, great job.

[@joyateechattopadhyay9510]

you are just too good, you make me understand any complex thing in such a way ,that it seems so easy. When ever I got stuck anywhere ,I just search with Java Techie. Thank you so much.

[@Javatechie]

Thanks Joyatee , glad to hear this 😊

[@ajitharumugam8797]

Best video , tried it and successfully deployed, Thanks a lot

[@shubhamchakravarty4121]

Amazing content on your channel, man. Thanks a lot.

[@PANKAJSINGH-lv7iu]

You made it easy man. Salute

[@dawednesru5353]

This is wonderful video. Thank you very much!!!

[@antonmariadas7747]

As usual, nice video. Thanks java techie

[@PappuKumar-ho3ek]

Thanks for the video... I was looking for that.... thank you sir. It's really helpful video.

[@user-gw8qr8em1z]

Thank you so much it worked. Best tutorial.

[@user-qw5dj5sz3x]

Thanks alot, great content, works perfectly.

[@prasadb114]

Good source of learning. Loved it😍😍. Thanks for such a wonderful content...

[@niranjanverma6516]

Appreciated for your Work...Nice Tutorials

[@josephfifstones]

this channel is really good

[@mohamedely3987]

Definitely

[@anilshetty2842]

deployed successfully, Thank u :)

[@andrewsselvaraj]

Very useful video...thanks

[@mahima3236]

Superb video Thank you so much

[@arturoisidro9411]

Amazing video thanks 🙏🏽

[@swagatdishri749]

Great tutorial.Thanks

[@b_1729-j8j]

Thanks a lot :-) this is my first deployed app and it successful.

[@dasariarun3920]

I am the big fan know thank you so much 🥰

[@sunnyvarun6652]

Great Tutorial!!

[@manjulamuttagi4142]

It helped alot sir. thanks

[@jesusarmandomaciasbenitez1517]

It looks so really easy....

[@atharhussain9223]

Nice ... Please take the full realtime project of microservice, aws, and all other tools merge

[@dheereshsingh6415]

Hi, Its really an amazing explanation, Thank a lot for this...I was also getting the Bad Gateway Problem, but i simply saw the comment chain and seen your suggestions to everyone. Hence i resolved my issue....Thanks a ton boss 😍

[@ejemaster8413]

Danke. sehr gut erklärt

[@mehmetpekdemir2863]

Thank you bro.

[@gurbanalizada3978]

Very usefull

[@chienvu6870]

thank you so much!

[@talu_mut]

Thank you ❤

[@obinnadanil8146]

Thank you

[@amitkolgaonkar]

Super video

[@kamleshgujariya6432]

Thanks!

[@bikashthapa3972]

Good video

[@luisfernandomartinezibarra1290]

Thanks

[@chia-shenglin4115]

you save my life

[@supercars4574]

best tutorial, straight to the point but i see server.port = 5000 is required because elastic bean search for the same port

[@Javatechie]

Yes exactly even I don't know logic behind it .

[@user-mk6fp9vf4e]

thanks

[@ChetanRawattunein]

Thankyou so much, I was having trouble in connecting rds with spring boot. Extremely informative video. Can you also create a video where we consume an external api and store it's output or status etc to RDS .

[@Javatechie]

Okay

[@nickyjadhav]

Thanks man

[@nickyjadhav]

I'm wondering how to deploy multiple instances on a same stack

[@aminebouita7185]

Hi Basant, first I want to thank you for the tutorial, I did not understand why you have configured the database when creating the application in Beanstalk, since I continue to use the rds database created in the first example, I have done the same configuration without adding the database to the beanstalk and it worked correctly for me.

[@Javatechie]

Am not sure but without configure in elastic beanstalk I faced some error .

[@amargupta1728]

@@Javatechie jugad acha hai..😛😛

[@Javatechie]

@@amargupta1728 not getting you

[@amargupta1728]

@@Javatechie Nothing just joking..chill bro..😀

[@Javatechie]

Aman cool 😃

[@rajeshg3570]

Nice video. I've a question here - why do we need specify the DB details in elastic beanstalk ? Any specific reason? The DB connectivity would be part of the app

[@sandeepjayaram83]

Even I had same question , in beanstalk we are giving just name and pwd is it creating new db instance if not how is it recognized particular db instance which got created

[@husseinali1199]

Thank you very much for wonderful video. please help Elastic Beanstalk deploy working on postman and not on browser

[@divyashankar4752]

same prblm too me also'

[@koribarodramatv]

Thanks for this nice tutorial I have 2 questions though Where I can find the .jar you did select in the target folder I just couldn't find it? How much I should pay for the service at the beginning?

[@Javatechie]

Run maven install then jar will be available in your target folder

[@afritravelogue]

is there any another specification rules for JSP front-end for spring boot? As, I have tried everything, I can connect the MySQL rds hosted on aws from locally, but after deploying whole app, I am getting Whitelabel Error Page (404) error. But, all of my controller and jsp front-end works fine in local env, but not working on elasticbean

[@sashikantbiswal4707]

Bhai, gote complete ecommerce project using spring and angular with customer and admin pages with spring security and delpoyment tutorials banantu. Aapana bahut bhala padhanti, matey apanka tutorials bahut bhala lagey. Please gote ecommerce application banantu. Please.

[@Javatechie]

I will try to start one project series 😊. But it may take some time most probably mid of next month

[@sashikantbiswal4707]

@@Javatechie sure, I will wait

[@sakthinivas1840]

Hi, thanks for your video. We did not create the additional database configuration in EBS to deploy app wiith DynamoDB but we did only for app with MySQL DB. whats the reason behind it?

[@vishakhasharawat4869]

Hi Basant thanks for all your videos very good content . I have a question here while deploying via bean stalk can we configure security groups like we did in your video of creating EC2 instance first Also can we see S3 bucket contents as well using beanstalk ? and how load balancing, versioning and deploy multiple instances done in aws .can you make some video on this as well ?

[@Javatechie]

Yes of course we can as under the hood beanstalk also create an EC2 instance

[@saitejagatadi9711]

Bro, Give some basic tips on how to crack interview (not regarding tech but just common basic) who is working on any other platform and who haven't worked in Full Stack in his/her career. Like some basic questions: 1. What he/she checks first just after login to his system. 2. What will be his/her role and responsibilities as 2+ years experienced person 3. Shall we proceed to say that i am part of Agile? If not how can i deal the question.. 4. What kind of calls do we have on daily basis? If Agile/Scrum or If not Agile/Scrum 5. What kind of instant requests we receive for troubleshooting? Frontend or Backend 6. How Full Stack Developer deploy the newly implemented feature into Production apart from PCF and other cloud technologies(AWS, Azure, Docker, Kubernetes) Like a usual day to day life of a full stack Java developer including live deployement..

[@RockdolfoUltimate]

Great video... thanks!! Can we how to upload the frontend to the aws?

[@Javatechie]

It's there buddy kzbin.info/www/bejne/in3afqijpt56e7M

[@mohammedshabbir1347]

Hi Basant, Thanks for the tutorial. Very nicely explained. Just want to mention that git hub source code is missing pom.xml file. Please correct the source code file.

[@Javatechie]

Thanks buddy let me check I will add

[@bhushangosavi435]

@@Javatechie The souce code is still missing the pom.xml file. Can you please add. Thanks

[@Javatechie]

@@bhushangosavi435 please use below pom github.com/Java-Techie-jt/springboot-aws-secrets-manager/blob/main/pom.xml

[@adityavyas6603]

Thanks for AWS Rds... When application is deployed on AWS Elastic Beans talk table is recreated??.. That's why old 2 records are not available...

[@Javatechie]

Yes in we need to chsbte hbm2.auto.ddl=update

[@DavisTibbz]

Can you please Show how to setup SSL for Java Elastic beanstalk AWS

[@varunateru]

Hi Basant. Is it necessary to put ddl-auto, database-platform properties. Thank you for the video.

[@Javatechie]

database-platform we can ignore but ddl-auto we must need to specify if not you need to create table manually .

[@tonythecruz4933]

Where can find the maven install option , in my sts it is not showing maven

[@sriaya1743]

Nice video sir, say we are using Nosql example couchbase, then in this case how can we use couchbase in AWS.

[@Javatechie]

Am not sure about this need to check

[@sriaya1743]

Sure thank you

[@deepakrohilla5574]

Hi, I am new to AWS. Are both the DB env (RDS and ElasticBeanstalk) different? As it does not show the previous records stored through Postman hit.

[@Javatechie]

It should display

[@anindyaghosh5163]

it's because we have "spring.jpa.hibernate.ddl-auto = create" in the application.properties (check 05:10). if we had it as "update" we could see the existing values. The value "create" enforces to re-create the schema on application start-up.

[@sudheendrasatrasala6936]

Thank you for your tutorial. Is it possible to host small spring boot microservice (Eureka server, Config Server, Multiple RestFul APIs) in the same way ?

[@Javatechie]

Eureka server is not there in AWS but yes through API gateway we can host

[@sudheendrasatrasala6936]

@@Javatechie can we host user developed Eureka Server, user developed Config Server ?

[@sourabhjain4914]

Hi just wanna know one thing instead of keeping yaml in code, can we put it in S3 bucket and can read from there. If yes ,how? --spring .config .location does not load.

[@Javatechie]

Yes I believe it should work but not sure as I never tried this.will check this

[@hariprasad1727]

Hi, When I Am Uploading Jar File In Elastic Bean Stalk getting Exception No Source Code available And Jar File Not uploading Successfully, But Eecutable Jar Running in Cmd Prompt. Any Solution is There ?

[@ravipratap2900]

How to deploy different microservices running on different ports ??

[@praveenpatel7148]

Hi guys .. I was trying to run the above application as mentioned but was getting error like unknown schema javatechie. So find out that we need to connect to database using mysql workbench and need to manually create schema like - create database javatechie. After that i was successfully make connection from springboot to aws-rds. I thought if just sharing with this if anyone get the same error. Bu default it was not able to connect . Thanks

[@bitsbard]

If this content speaks to you, this book will sing. "AWS Unleashed: Mastering Amazon Web Services for Software Engineers" by Harrison Quill

[@abhishekrathore8903]

Thank you sir its really helpful but i am getting 502 bad gateway error. I have changed server port to 5000 and on my local everything working fine even with aws rds. Please help here

[@Javatechie]

If you configure RDS specific datasource in your application.properties file Will you able to access ?

[@jaganmohanmylapuru5974]

Thanks for the video, but I am getting 502 Bad Gateway nginx/1.20.0. RDS works fine. Can some please help?

[@jaganmohanmylapuru5974]

Found the solution, added the PORT number in configurations(in AWS configurations) that I assigned to my app in the local.

[@riyazkhan5117]

Hello.sir How can connect h2 database to aws deployment

[@cristianramirezfonseca8567]

does anyone know how to connect EBS with a PRIVATE RDS instance?

[@riyazkhan5117]

Sir please define in aws how can fix 502 bad gateway error

[@video-vocabulary]

Do we need All traffic rule in Inbound rules?

[@Javatechie]

We should customize it in case of realtime application .this is just a demo

[@abhisheksrivastava5209]

Server. Port 5000 but still getting badway after deployment.. Help me out

[@suvadippaul2543]

Hi ... I created DB in RDS and able to connect from MySQL work bench. I also able to connect from my Spring Boot application when its start-up. But when I trying connect controller method, its giving "status": 404, "error": "Not Found", "path": "what ever path it is" I checked same application without RDS working. Any clue?

[@Javatechie]

404 means it's something wrong in your URL .share your code in GitHub and curl which you tried .

[@suvadippaul2543]

@@Javatechie , thanks for addressing fast. I tried freshly, this time all is good.

[@Javatechie]

Great 👍🏻

[@TshepoMphirime]

Hi, I get 502 Bad Gateway nginx/1.20.0 after deploying my springboot app. What's the cause of this... Please help?

[@Javatechie]

Please change server port to 5000

[@sumitpaswan2682]

Can we use ec2 instead of elastic bean stalk as it will be cost efficient 10:15

[@Javatechie]

Yes you can even already I did that in video. Elastic beanstalk also internally create an EC2 instance

[@balaiahyatham5197]

Hi, I have followed same steps and deployed application in Elastic Beanstalk but when I access URL I am getting 502 bad gateway nginx. Could you please let me know how to resolve it.

[@Javatechie]

Please check server.port it should be 5000

[@balaiahyatham5197]

@@Javatechie Hi, Thanks for your help its worked for me after changing server.port=5000 in application.properties file. But is it only 5000 or any range required in choosing port number?

[@balaiahyatham5197]

Hi one more doubt I am getting in this example. Test purpose I have dropped table from mysql workbench and try to access yathamsapp-env.eba-pzc3ypxp.us-east-1.elasticbeanstalk.com/policies/all then I am getting "Sun Jul 18 08:03:18 UTC 2021 There was an unexpected error (type=Internal Server Error, status=500)." Even If try to add data from postman by using above url also getting same ""error": "Internal Server Error",". If I restart my local springboot application then table is creating. What is the reason behind this?

[@manasamaddu7728]

Hi, can i know any way to connect java app with rds mysql?

[@Javatechie]

Yes you can do that Just use AWS SDK for java Even you can find the simple steps in AWS official page itself

[@riyazkhan5117]

Hello Sir I can follow each and every step for.this videos everything is working good but at the end Showing this error in my pc screen 502 bad gateway error

[@Javatechie]

Please change server.port 5000 in your application.properties

[@riyazkhan5117]

@@Javatechie okk sir

[@krishnamalhotra3206]

even after making server.port=5000, i am getting nginx error, 502 bad gateway. Any solution?

[@rajidipuneeth9900]

Have you figured it? Even I am facing same issue

[@guptarishabh412]

@@rajidipuneeth9900 plz let me also know if u have solved the problem

[@Javatechie]

What is the error you are getting and what did you mentioned server.port

[@domlee7599]

Hi I am getting Access denied for user 'admin '@'124.13.255.95' (using password: YES). Appreciate any help to fix the error thanks

[@BalrajSingh-jb7ul]

I am getting "Access denied error using Password NO" while running the app even after entering correct master db password...please help

[@Javatechie]

Have you configured secrets

[@prasannakumarz]

At 10:45 what to choose if my application is written with java11 version? please someone reply if u know....!

[@Javatechie]

You can choose java 11

[@prasannakumarz]

@@Javatechie java11 is not there in the option sir....

[@Javatechie]

Jdk 11 should be there wait let me check

[@prasannakumarz]

@@Javatechiesir there is corretto11....is this the java jdk11?

[@Javatechie]

No I am not sure

[@bharathmuniganti2821]

I am getting error like "Field bookRepository in Application required a bean of type". Please help me

[@Javatechie]

Are you able to run this application in your local instance ? First test it in local by giving datasource info

[@maxsfernandes]

Nos dias de hoje não funciona.

[@muhammadkk6672]

POM file is not available in the github repo?? why??

[@Javatechie]

Yeah Buddy not sure I also notice it now . Let me share you another reference github.com/Java-Techie-jt/springboot-aws-secrets-manager/blob/main/pom.xml

[@Abhishekk577]

Getting Unknown database 'firstrds'. I am doing anything wrong ?

[@Javatechie]

Are you able to connect your db with connection string in MySQL workbench

[@Abhishekk577]

@@Javatechie issue is sorted. Big big thanks to you sir. I was looking for this series after my certification.Big Thanks to You

[@gadilohith3994]

im getting 502 bad request what can i do

[@Javatechie]

Check application health in elastic beanstalk

[@SreenuChimmili]

Hi bro. I am try to deploy my spring boot app but i am getting Degrated Error after jar upload can some please help on this

[@Javatechie]

What is the error

[@SreenuChimmili]

@@Javatechie its showing as " impaired services in all instances"

[@sureshmanne7245]

your code in git is not updated it seems, any annotation you missed with "BookRepository.java" file? Also i couldn't find pom file

[@sureshmanne7245]

*************************** APPLICATION FAILED TO START *************************** Description: Field bookRepository in com.javatechie.aws.Application required a bean of type 'com.javatechie.aws.BookRepository' that could not be found. The injection point has the following annotations: - @org.springframework.beans.factory.annotation.Autowired(required=true) Action: Consider defining a bean of type 'com.javatechie.aws.BookRepository' in your configuration.

[@Javatechie]

It seems there is some glitch from GitHub while uploading content to GitHub. Are you able to resolve or not?

[@atulpatil7472]

pom.xml is missing in git code

[@ikennaifekaonwu6015]

How do I connect my front end to view this stored data?

[@Javatechie]

Just invoke this backend api from frontend

[@ikennaifekaonwu6015]

@@Javatechie I used Aws s3 for my front end deployment, even after using the endpoint from EC2, I was not gettting my data from the backend

[@ikennaifekaonwu6015]

I fixed the problem, seems I was invoking the backend from my package.json, which was the central proxy. I fixed this by inserting the endpoint everywhere I fetch data from the backend

[@video-vocabulary]

Why have you created another RDS instance with Elastic Beanstalk, didn't you already created one at the begging of the video?

[@Javatechie]

I created once only right ?

[@video-vocabulary]

@@Javatechie At the beginning of the video you created one RDS and connected to it from MySQLWorkbench and Spring Boot application, at the second part of the video you modified Database configuration in Elastic Beanstalk, which is supposed to create a new database, not connect to existing database, isn't it?

[@Javatechie]

No it will connect to existing RDS instance . Check in config I mentioned the same

[@video-vocabulary]

@@Javatechie As far as I understand, Elastic Beanstalk creates a new database, unless you set connection parameters to the existing database as environment variables - serverfault.com/a/540916

[@vinodsinghchauhan8535]

@@video-vocabulary true

[@s4sunshine01]

is RDS opensource?

[@Javatechie]

Yes opensource , as am using AWS free account

[@s4sunshine01]

@@Javatechie that does not make open source

[@bhavanisankar71]

It is free of cost or paid version

[@Javatechie]

It will be chargeable but a very minimum amount near to 15 rs Indian currency per month

[@bhavanisankar71]

@@Javatechie how to pay

[@akashrathor9863]

after connection with mysql workbench . can we directly add or delet rows or table or values in mysql workbench ? and it will be reflected in aws rds???

[@Javatechie]

Yes it will

[@BalrajSingh-jb7ul]

Yes in workbench you'll have to make a new connection and in host add the rds endpoint and the master password and everything will be reflected there

[@sandhyaaa24]

Caused by: java.sql.SQLException: Access denied for user 'admin'@'' (using password: YES)

[@Javatechie]

Please provide valid password . Error message says you configured wrong username and password

[@sandhyaaa24]

@@Javatechie thank you :)

[@muhammadkk6672]

Please send me the pom file

[@atharhussain9223]

i am getting 502 bad gateway

[@atharhussain9223]

what should i do

[@Javatechie]

Did you specify server.port=5000 If not set it then run once , if it will workout then I can suggest what to do okay

[@atharhussain9223]

i got the 200 response by postman with rds but with beanstalk I am getting 502 bad gateway

[@Javatechie]

Dude as I mentioned please change server.port=5000 then create a jar and deploy in beanstalk If you don't want this then go to elastic beanstalk environment then change port there .

[@atharhussain9223]

@@Javatechie Thanks dear, I got the response by using port 5000.

[@Satenc0]

what does @SneakyThrows means or is used for? first time i see it, thank you!

[@Javatechie]

If you want to avoid throws exception from your method just use this annotation

[@niteshaarne2208]

Great vdo...🙌🏻 Thank you so much

[@krishnamalhotra3206]

even after making server.port=5000, i am getting nginx error, 502 bad gateway. Any solution?

[@Javatechie]

Did you configure security for MySQL ?

[@krishnamalhotra3206]

Java Techie the one in security groups? I did give it custom and 0.0.0.0/0 though

[@Javatechie]

Did you rebuild the jar after changes server.port ?

[@krishnamalhotra3206]

Java Techie yes, clicked on maven-> install and then uploaded snapshot in elasticbean

[@karandulani9857]

@@krishnamalhotra3206 @Java Techie same error coming to me also