Week 4 Worklog

Week 4 Objectives:

  • Deploy a production-grade WordPress architecture ensuring High Availability (HA) and Scalability using Auto Scaling Groups and CloudFront.
  • Master Server Migration workflows by importing/exporting Virtual Machines (VMs) between on-premises environments and AWS.
  • Perform comprehensive Database Migration for heterogeneous sources using AWS Schema Conversion Tool (SCT) and Database Migration Service (DMS).
  • Research advanced cloud migration strategies and tools (DataSync, MGN, Outposts).

Tasks to be carried out this week:

DayTaskStart DateCompletion DateReference Material
2WordPress on AWS - Part 1 (Deployment)
- Prepare Infrastructure: VPC, Subnets, Security Groups for Web & DB
- Launch Multi-AZ RDS for high database availability
- Deploy EC2 and install WordPress application
- Connect WordPress to RDS instance		29/09/202529/09/2025https://000021.awsstudygroup.com/
3WordPress on AWS - Part 2 (Scaling & CDN)
- Create AMI from the configured WordPress instance
- Setup Auto Scaling Group (ASG) with Application Load Balancer
- Accelerate content delivery using Amazon CloudFront
- Perform Database Backup (Snapshot) & Restore operations
- Cleanup resources		30/09/202530/09/2025https://000021.awsstudygroup.com/
4Server Migration (VM Import/Export)
- Deploy local Application Server (Simulated On-Prem)
- Import VM to AWS: Export local VM, upload to S3, and convert to AMI/EC2
- Export VM from AWS: Export EC2 instance back to S3 for on-prem use
- Manage S3 ACLs and CLI roles for migration tasks		01/10/202501/10/2025https://000014.awsstudygroup.com/
5Database Migration (DMS & SCT)
- Set up Migration Environment: Source (Oracle/SQL Server) & Target (Aurora/RDS)
- Use Schema Conversion Tool (SCT) to convert database schemas
- Configure AWS DMS:
  + Create Replication Instance & Endpoints
  + Run Migration Task (Full Load + CDC)
- Explore DMS Serverless for auto-scaling replication		02/10/202502/10/2025https://000043.awsstudygroup.com/
6Advanced Migration Monitoring & Strategies
- Monitoring DMS: Analyze CloudWatch metrics, Table statistics, and Task logs
- Troubleshooting: Diagnose memory pressure and table errors during migration
- Research: Explore upcoming migration patterns:
  + AWS Application Migration Service (MGN)
  + AWS DataSync & Migration Hub
  + Container Migration to EKS		03/10/202503/10/2025https://000043.awsstudygroup.com/

Self-Study on AWS Migration Hub

Week 4 Achievements

Scalable Web Architecture

  • Successfully deployed a highly available WordPress site using Multi-AZ RDS and Auto Scaling Groups.
  • Configured Application Load Balancer (ALB) to distribute traffic dynamically across healthy instances.
  • Optimized global content delivery speeds by integrating Amazon CloudFront as a CDN.
  • Implemented disaster recovery procedures using RDS Snapshots and restoration techniques.

Server Migration Expertise

  • Gained hands-on experience with VM Import/Export methodologies.
  • Successfully migrated a virtual machine from a simulated on-premises environment (VMware) to AWS EC2.
  • Mastered the reverse process of exporting an active AWS EC2 instance back to a portable VM image stored in S3.
  • Configured necessary IAM roles and S3 permissions to facilitate secure image transfer.

Database Migration & Modernization

  • Executed a heterogeneous database migration (e.g., SQL Server/Oracle to Aurora) using AWS DMS.
  • Utilized the AWS Schema Conversion Tool (SCT) to automate schema transformation between different database engines.
  • Configured Continuous Data Replication (CDC) to keep source and target databases in sync with minimal downtime.
  • Experimented with DMS Serverless to handle variable migration workloads automatically.
  • Learned to monitor migration health using CloudWatch and troubleshoot common issues like memory pressure or data type mismatches.