FastHack - Postgres migration
Introduction
This intro level hackathon will help you get hands-on experience migrating databases from on-premises PostgreSQL to Azure DB for PostgreSQL Flexible Server.
Learning Objectives
In this hack you will solve a common challenge for companies migrating to the cloud: migrating open source databases to Azure. The application using the database is a sample e-commerce application written in Java. It will be configured to use PostgreSQL.
The participants will learn how to:
- Perform a pre-migration assessment of the databases looking at size, database engine type, database version, etc.
- Use offline tools to copy the database to Flexible Server
- Do cutover and validation to ensure the application is working properly with the new configuration.
- Optionally you can use Database Migration Service to perform an online migration.
- Configure connection pooling in Flexible Server and update the configuration of your application.
Challenges
- Challenge 0: Pre-requisites - Setup Environment and Prerequisites!
- Prepare your environment to run the sample application
- Challenge 1: Assessment (features differences and compatibility)
- Assess the application's PostgreSQL database
- Challenge 2: Size analysis
- Determine the CPU/memory configuration and database file size and map to an equivalent size in Azure
- Challenge 3: Offline migration
- Dump the "on-prem" databases, create database for Flexible Server restore and migrate schema + data.
- Challenge 4: Offline Cutover and Validation
- Reconfigure the application to use the appropriate connection string and validate that the application is working.
- Challenge 5: Configure connection pooling
- Configure connection pooling and update your application configuration.
Prerequisites
- Access to an Azure subscription with Owner access
- If you don't have one, Sign Up for Azure HERE
- Familiarity with Azure Cloud Shell
- Azure Data Sudio (optional)