Deploying a Two-Tier Web Application on AWS with MySQL and Apache

ssh -i your-key.pem ubuntu@your-ec2-public-ip

sudo apt update && sudo apt install -y apache2 php libapache2-mod-php php-mysql mysql-client

sudo systemctl start apache2
sudo systemctl enable apache2

cd /var/www/html

sudo nano index.html

Registration Form


    User Registration
    
        Name: 
        DOB: 
        Email: 
        
    





    Enter fullscreen mode
    


    Exit fullscreen mode
    




8.2 Create PHP Script (submit.php)

sudo nano /var/www/html/submit.php



    Enter fullscreen mode
    


    Exit fullscreen mode
    





connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$name = $_POST['name'];
$dob = $_POST['dob'];
$email = $_POST['email'];
$stmt = $conn->prepare("INSERT INTO users (name, dob, email) VALUES (?, ?, ?)");
$stmt->bind_param("sss", $name, $dob, $email);
if ($stmt->execute()) {
    echo "Registration successful";
} else {
    echo "Error: " . $stmt->error;
}
$stmt->close();
$conn->close();
?>



    Enter fullscreen mode
    


    Exit fullscreen mode
    




Step 9: Create Target Group
Go to the AWS EC2 Console → Navigate to Target Groups
Click Create target group
Choose Target type: Instance
Enter Target group name: my-target-group
Select Protocol: HTTP
Select Port: 80
Choose the VPC you created earlier
Click Next
Under Register Targets, select your EC2 instances
Click Include as pending below, then Create target group
Step 10: Create an Application Load Balancer (ALB)
Go to AWS EC2 Console → Navigate to Load Balancers
Click Create Load Balancer
Choose Application Load Balancer
Enter ALB Name: my-alb
Scheme: Internet-facing
IP address type: IPv4
Select the VPC
Select at least two public subnets (for high availability)
Click Next
Step 11: Test the Application
Restart Apache
sudo systemctl restart apache2
Open your browser and visit:
http://your-ec2-public-ip/

Fill in the form and Submit
Check MySQL Database:


mysql -u admin -p -h your-rds-endpoint
USE your_database;
SELECT * FROM table_name;



    Enter fullscreen mode
    


    Exit fullscreen mode
    




This setup ensures a scalable, secure, and high-availability application on AWS! 🚀Follow for more and happy learning :)