[Episode 49] Connecting Spring Boot to a MySQL Database with Azure Key Vault

Опубликовано: 29 Сентябрь 2024
на канале: Bingyang Wei
742
20

🔗 hogwarts-database.sql: https://drive.google.com/file/d/1Sxbh...
🔗 Project GitHub: https://github.com/Washingtonwei/hogw...

Although the H2 in-memory database comes in handy during development, we need to switch to a beef production-ready database in production. In this video, let’s connect our Spring Boot application to a MySQL database hosted on Microsoft Azure. I will then demonstrate using Azure Key Vault to securely store database login credentials.

0:00:00 Overview
0:03:38 Provisioning a MySQL database in Azure
0:15:15 Connecting Azure Database for MySQL using MySQL Workbench
0:17:07 Creating the "hogwarts" database and populating the database
0:20:25 Switching between “dev” and “prod” environment using Spring Profiles
0:40:31 Storing database login credentials in the Azure Key Vault
0:46:54 Configuring an Azure Web App Service to connect to the Azure Key Vault
0:49:57 Connecting a Spring Boot application to the Azure Key Vault
0:58:31 Deploying a Spring Boot application to Azure
1:01:15 Testing the staging site
1:03:34 Swapping the staging and production site
1:08:04 Synchronizing the local main branch
1:08:40 Summary

Keep watching. Here are more Spring Boot Packaging and Deployment videos:
42 Introduction to Spring Boot Packaging and Deployment 🔗    • [Episode 42] Introduction to Spring B...  
43 Packaging a Spring Boot Application into an Executable JAR 🔗    • [Episode 43] Packaging a Spring Boot ...  
44 Containerizing a Spring Boot Application 🔗    • [Episode 44] Containerizing a Spring ...  
45 Introduction to CI and CD with GitHub Actions 🔗    • [Episode 45] Introduction to CI and C...  
46 Spring Boot Continuous Integration with GitHub Actions 🔗    • [Episode 46] Spring Boot Continuous I...  
47 Deploying Spring Boot Applications to Azure with GitHub Actions 🔗    • [Episode 47] Deploying Spring Boot Ap...  
48 Setting Up Staging Environments in Azure App Service 🔗    • [Episode 48] Setting Up Staging Envir...  
49 Connecting Spring Boot to a MySQL Database with Azure Key Vault 🔗    • [Episode 49] Connecting Spring Boot t...  

This video belongs to a playlist "Learn Spring Boot 3 with Bingyang":    • Learn Spring Boot 3 with Bingyang  

I don't want to make a super long video so I split it into smaller ones. If you want to learn Spring Boot 3 systematically, please visit the playlist (and save the playlist) for more Spring Boot 3 tutorials.

Feel free to leave a comment if you have any questions.

As always, thanks for watching, and happy learning!