AWS Solution for an Honest Feedback System

Created by: Chris Sa
Last updated: 2023-01-15

Project Overview

The goal of this project is to create a simple feedback system that allows users to submit feedback and view a random piece of feedback. The system should be hosted on AWS and use DynamoDB to store the feedback.

Implementation outline

Level one is the basic implementation of the feedback system. It is hosted on EC2 instances and uses Auto Scaling to scale the number of instances up and down. The feedback system is hosted and managed on the EC2 instances.

Level two is the advanced implementation of the feedback system. It is hosted on Elastic Beanstalk and uses CloudFront to distribute the content. The feedback system is hosted and managed on Elastic Beanstalk.

Important note:

In the implementations below, level two is somewhat reliant on level one. For example, the Elastic Beanstalk environment is created in the same VPC made in level one. This means that the VPC needs to be created before the Elastic Beanstalk environment.

If you would like to skip the first you will need to complete the following steps from level one:

Create a VPC
Create a DynamoDB table
Create a policy

Demonstration video

To see a walkthrough of the project, please click here.

Files

For this project PHP was used to create the frontend and backend. The frontend page has a simple form that allows users to submit feedback. The backend is a PHP file that stores the feedback in a DynamoDB table.

Both files need to connect to the database, to do this the following code is used:

require 'vendor/autoload.php';

use Aws\DynamoDb\DynamoDbClient;

$client = DynamoDbClient::factory(array(
    'region' => 'ap-southeast-2',
    'version' => 'latest'
));

$tableName = 'Cotiss-Feedback-DB';

The full files can be found in the project's GitHub repository

Index (frontend)

The index file is the main file for the project. It should be structured as follows:

A random piece of feedback should be pulled from the database and displayed at the top of the page. This is done by using the following code:

$response = $client->scan(array(
   'TableName' => $tableName
));

$items = $response->get('Items');

$feedback = $items[array_rand($items)];

The form should have the following fields:

Feedback (text)
Rating (number)

Feedback (backend)

The feedback file is the backend file for the project. It should be structured to take the form data from the index file and store it in the database. The following code can be used to store the data:

$response = $client->putItem(array(
   'Item' => array(
      'id' => array('N' => $id),
      'feedback' => array('S' => $feedback),
      'rating' => array('N' => $rating)
   ),
   'TableName' => $tableName
));

Implementation - Level 1

The goal of level 1 is to deploy the feedback system on Auto Scaling EC2 instances.

Virtual Private Cloud (VPC)

Create a VPC

Go to the VPC console.
Click "Create VPC".
Apply the following settings:
- VPC only
- Name (optional)
- IPv4 CIDR manual input
- A 16-bit IPv4 CIDR block (e.g. 168.16.0.0/16)
- No IPv6 CIDR block
- Default tenancy

Create subnets

Go to the subnets console.
Click "Create subnet".
Select the VPC created in the previous section.
Apply the following settings:
- Name (optional)
- Availability zone (select one)
- A 24-bit IPv4 CIDR block (e.g. 168.16.0.0/24)
Click "Add new subnet" to create more subnets. In this example, an additional two availability zones were selected with the following IPv4 CIDR blocks: 168.16.16.0/24 and 168.16.32.0/24.
Click "Create subnet".
Ensure you now have three subnets in different availability zones.

Create an internet gateway

Go to the internet gateways console.
Click "Create internet gateway".
Provide a name for the internet gateway.
Click "Create internet gateway".
Select "Actions" and then "Attach to VPC".
Select the VPC created in the first section.
Select "Attach internet gateway".

Edit the route table

Go to the route tables console.
Select the route table associated with the VPC created in the first section.
Change to the "Routes" tab.
Click "Edit routes".
Click "Add route".
Apply the following settings:
- Destination: 0.0.0.0/0
- Target: Select the internet gateway created in the previous section.
Click "Save changes".

Create DynamoDB endpoint

Go to the VPC endpoints console.
Click "Create endpoint".
Search for "DynamoDB" and select com.amazonaws.ap-southeast-2.dynamodb.
Select the VPC created in the first section.
Select the route table associated with the VPC.
Click "Create endpoint".

DynamoDB

Go to the DynamoDB console.
Click "Create table".
Enter a table name (e.g. Cotiss-Feedback-DB).
Enter id as the primary key.
Select "Number" as the key type.
Select "Create table".

Identity and Access Management (IAM)

Create a policy

Go to the IAM console.
Click "Create policy".
Select DynamoDB as the service.
Select the following actions:
- dynamodb:BacthGetItem
- dynamodb:GetItem
- dynamodb:GetRecords
- dynamodb:Query
- dynamodb:Scan
- dynamodb:BatchWriteItem
- dynamodb:PutItem
Select "Add ARN" for "stream".
1. Add your region (e.g. ap-southeast-2).
2. Add your table name (e.g. Cotiss-Feedback-DB).
3. Tick the "Any" box for the "Stream label" field.
4. Click "Add".
Select "Add ARN" for "table".
1. Add your region (e.g. ap-southeast-2).
2. Add your table name (e.g. Cotiss-Feedback-DB).
3. Click "Add".
Click "Next: Tags".
- Add a tag if you wish.
Click "Next: Review".
Name the policy (e.g. Cotiss-Feedback-DB-Policy).
Click "Create policy".

Open your policy and confirm the JSON is as follows - where XXXXXXXXXXXX is your AWS account ID:

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "VisualEditor0",
            "Effect": "Allow",
            "Action": [
                "dynamodb:BatchGetItem",
                "dynamodb:GetItem",
                "dynamodb:GetRecords",
                "dynamodb:Query",
                "dynamodb:Scan",
                "dynamodb:BatchWriteItem",
                "dynamodb:PutItem"
            ],
            "Resource": [
                "arn:aws:dynamodb:ap-southeast-2:XXXXXXXXXXXX:table/Cotiss-Feedback-DB/stream/*",
                "arn:aws:dynamodb:ap-southeast-2:XXXXXXXXXXXX:table/Cotiss-Feedback-DB"
            ]
        }
    ]
}

Create a role

Go to the IAM console.
Click "Create role".
Select "AWS service" as the trusted entity.
Select "EC2" as the use case.
Click "Next".
Select the policy created in the previous section.
Click "Next".
Provide a name for the role (e.g. Cotiss-EC2-Role).
Click "Create role".

EC2

Creating an EC2 instance

Go to the EC2 Instances console.
Click "Launch instance".
Name the instance (e.g. Cotiss-EC2-Instance).
Select "Amazon Linux 2 AMI"
Select "t2.micro" as the instance type.
Click "Create new key pair".
1. Name the key pair (e.g. Cotiss-EC2-Key-Pair).
2. Keep RSA as the key pair type.
3. Select the format as laid out below.
  - Windows users: select .ppk.
  - Mac/Linux users: select .pem.
4. Click "Create key pair".
5. Save the key pair file somewhere safe.
Ensure your key pair is selected.
Click "Edit" under "Network settings".
1. Select the VPC created in the first section.
2. Choose a subnet from the list. These should be the subnets created in the second section.
3. Change the auto-assign public IP setting to "Enable".
4. Select "Create security group".
  1. Name the security group (e.g. Cotiss-EC2-Security-Group).
  2. Add a description (e.g. Allows SSH and HTTP access).
  3. Change the SSH source to "My IP".
  4. Click "Add security group rule".
    1. Select "HTTP" as the type.
    2. Select "Anywhere" as the source.
    3. Click "Save rules".
Expand the "Advanced details" section.
Select the IAM role created in the previous section.
Launch the instance.

Setting up the EC2 instance

Connect to the EC2 instance using SSH.
- Windows users: use PuTTY.
- Mac/Linux users: use the terminal.
Update the instance:
- sudo yum update -y
Install Apache and PHP:
- sudo yum install -y httpd php
Start Apache:
- sudo systemctl start httpd
Enable Apache:
- sudo systemctl enable httpd
Confirm Apache is running by visiting the public IP of the instance in a web browser.
Transfer your website files to the instance.
- Windows users: use WinSCP.
- Mac/Linux users: use scp.
Move the website files to the Apache directory:
- sudo mv /home/ec2-user/website/* /var/www/html/
Navigate to the Apache directory:
- cd /var/www/html/
Run the below commands to install the AWS SDK for PHP:
- sudo php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"
- sudo php composer-setup.php
- sudo php -r "unlink('composer-setup.php');"
- sudo php composer.phar require aws/aws-sdk-php
Confirm the website is working by visiting the public IP of the instance in a web browser and submitting a form.

Amazon Machine Image (AMI)

Go to the EC2 Instances console.
Select the instance created in the previous section.
Stop the instance.
- Click "Instance State" and then "Stop".
Click "Actions" then "Image and templates" and then "Create Image".
Enter a name for the image (e.g. Cotiss-EC2-AMI).
Click "Create Image".

Launch Template

Go to the EC2 Launch Templates console.
Click "Create launch template".
Enter a name for the launch template (e.g. Cotiss-Launch-Template).
Select the AMI created in the previous section under "AMI".
Choose "t2.micro" as the instance type.
Select the security group created in the previous section.
Expand the "Advanced details" section.
Select the IAM role created previously.
Click "Create launch template".

Auto Scaling Group

Go to the EC2 Auto Scaling Groups console.
Click "Create auto-scaling group".
Name the auto-scaling group (e.g. Cotiss-Feedback-ASG).
Select the launch template created in the previous section.
Change "Version" to "Latest version".
Click "Next".
Choose the VPC created in the first section.
Select the subnets created under the selected VPC.
Click "Next".
Select "Attach to a new load balancer".
Select "Internet-facing".
Change "Default routing" to "Create new".
Click "Next".
Set desired capacity. This is the number of instances you want to run.
Click "Next".
Add notifications if required.
Click "Skip to review".
Confirm the settings are correct.
- The correct launch template.
- The correct VPC with subnets.
- An application load balancer with a target group.
- The correct capacity numbers.
Click "Create auto-scaling group".
Go to the EC2 Load Balancers console.
Copy the DNS name of the load balancer.
Paste the DNS name into a web browser and confirm the website is working.

Implementation - Level 2

ZIP of the website

Create a new file called composer.json in the root of the website directory.

Add the below code to the file:

{
  "require": {
    "aws/aws-sdk-php": "^3.0"
  }
}

Add an image to the index page with the following code (replacing your-domain.com with your domain name):
```
<img src="https://static.your-domain.com/cotiss-logo.svg" alt="Cotiss logo" />
```
Zip the website directory including the composer.json and PHP files.

IAM Role

Go to the IAM Roles console.
Click "Create role".
Select "EC2" as the service.
Click "Next".
Select the policy made in level 1 (i.e. Cotiss-Feedback-DB-Policy).
Select the following three policies:
- AWSElasticBeanstalkWebTier
- AWSElasticBeanstalkMulticontainerDocker
- AWSElasticBeanstalkWorkerTier

Elastic Beanstalk

Go to the Elastic Beanstalk console.
Click "Create application".
Give the application a name (e.g. Cotiss-EB-Application).
Select "PHP" as the platform.
Select "Upload your code" as the application code and upload the zip file created in the previous section.
Click "Configure more options".
Change "Proxy server" to "Apache" under "Software".
Change "Environment type" to "Load balanced" under "Capacity".
Select the IAM role created in the previous section under "Security" and then "IAM instance profile".
Select the VPC created in the first section of Level 1 under "Network".
1. Leave visibility as "Public".
2. Select the subnets created under the selected VPC for both "Load balancer subnets" and "Instance subnets".
3. Tick "Public IP addresses" under "Instance settings".
Click "Create environment".

S3 Bucket

Go to the S3 console.
Click "Create bucket".
Name the bucket (e.g. cotiss-static).
Leave everything else as default.
Click "Create bucket".
Upload your image to the bucket.

Route 53 - No hosted zone

Go to the Route 53 hosted zone console.
Click "Create hosted zone".
Enter a domain name you own (e.g. your-domain.com).
Leave the type as "Public hosted zone".
Click "Create hosted zone".

Amazon Certificate Manager

Go to the Amazon Certificate Manager console.
Confirm your region is "US East (N. Virginia)".
Click "Request a certificate".
Select "Request a public certificate".
Click "Next".
Enter your fully qualified domain names:
- your-domain.com
- *.your-domain.com (This covers static.your-domain.com)
Select "DNS validation".
Select RSA as the key algorithm.
Click "Request".
Find your certificate and click on it.
Click "Create records in Route 53".
Wait for the certificate to be issued.

CloudFront

Static bucket distribution

Go to the CloudFront console.
Click "Create distribution".
Select the S3 bucket created in the previous section as the origin.
Change "Origin access" to "Origin access control settings".
1. Create a new control setting. You only need to give it a name.
Select HTTPS only under "Viewer protocol policy".
Add an alternate domain name (e.g. static.your-domain.com).
Select your certificate created in the previous section.
Click "Create distribution".
Click "Copy policy" on the blue banner.
Click "Go to S3 bucket permissions to update policy" also in the blue banner.
Click "Edit" on the bucket policy.
Paste the policy copied from CloudFront.
- Right-click > Paste
- ctrl + v
Click "Save changes".

Elastic Beanstalk distribution

Go to the CloudFront console.
Click "Create distribution".
Select the Elastic Load Balancer connected to the Elastic Beanstalk application as the origin.
Select GET, HEAD, OPTIONS, PUT, POST, PATCH, DELETE under "Allowed HTTP methods".
Change the cache policy to "CachingDisabled".
Add an alternate domain name (e.g. cotiss.your-domain.com).
Select your certificate created in the previous section.
Click "Create distribution".
Return to the CloudFront console.
Click on the distribution created for the Elastic Beanstalk application.
Switch to the "Behaviors" tab.
Click "Create behavior".
1. Set the path pattern to *.
2. Select "Redirect HTTP to HTTPS" under "Viewer protocol policy".
3. Select GET, HEAD, OPTIONS, PUT, POST, PATCH, DELETE under "Allowed HTTP methods".
4. Change the cache policy to "CachingDisabled".
5. Click "Create behavior".

Route 53

Go to the Route 53 hosted zone console.
Click on the hosted zone created in the previous section or the hosted zone you want to use.
Click "Create record".
Click "Switch to quick create" if presented with the creation wizard.
Enter cotiss as the name.
Select "A" as the record type.
Switch on alias mode.
Choose "Alias to CloudFront distribution".
Select the CloudFront distribution for the Elastic Beanstalk application.
Click "Add another record".
Enter static as the name.
Repeat steps 5-8 but select the CloudFront distribution for the S3 bucket.
Click "Create records".
Wait for the changes to propagate.
Check the website is working by visiting cotiss.your-domain.com.

Cost analysis

All prices are in USD unless otherwise stated. Prices are current as of 2023-01-15. The yearly cost is based on 8760 hours in a year.

Level 1

Service	Cost month	Cost year	Upfront Cost	Number of instances	Total
EC2 (t2.micro)	$21.46	$258.72	$0.00	3
DynamoDB	$13.06	$156.72	$205.20	1
Elastic Load Balancer	$18.60	$223.20	$0.00	1
Total	$53.12	$638.64	$205.20	-	$843.84

These estimates are based on the following assumptions:

3 instances of EC2 (t2.micro) running for 24 hours a day, 7 days a week.
DynamoDB has low usage as it is only used for storing user data which is unlikely to be accessed frequently.
Elastic Load Balancer is used to distribute traffic to the EC2 instances.

You can view the cost breakdown in the AWS Pricing Calculator.

When it comes to scaling the level one solution you can increase the number of EC2 instances to handle more traffic. You can also increase the size of the EC2 instances to handle more traffic. However, this will increase the cost of the solution significantly. Due to the nature of the website, it is unlikely that the website will need to scale to handle more traffic, allowing it to downscale to 2 EC2 instances and save on costs.

Level 2

Service	Cost month	Cost year	Upfront Cost	Number of instances	Total
EC2 (t2.micro)	$21.46	$258.72	$0.00	3
S3	$0.08	$1.00	$0.00	2
DynamoDB	$13.06	$156.72	$205.20	1
Route 53	$0.54	$6.48	$0.00	1
CloudFront	$0.54	$6.48	$0.00	2
Elastic Load Balancer	$18.60	$223.20	$0.00	1
Total	$54.22	$651.60	$205.20	-	$856.80

These estimates are based on the following assumptions:

3 instances of EC2 (t2.micro) running for 24 hours a day, 7 days a week.
CloudFront never reaches the free tier limit of data transfer.

This solution comes out more expensive but not a significant amount. The main reason for the increase in cost is CloudFront and Route53 which are used to serve the website at a nice-looking URL compared to the automatically generated one of an Elastic Beanstalk application. The cost of CloudFront is based on the amount of data transferred which is unlikely to reach the free tier limit of 1TB. The cost of Route53 is based on the number of queries which is unlikely to reach the free tier limit of 1 million queries.

You can view the cost breakdown in the AWS Pricing Calculator.

Scaling this solution is the same as scaling the level one solution.

Files

README.md

Latest commit

History

README.md

File metadata and controls

AWS Solution for an Honest Feedback System

Table of contents

Project Overview

Implementation outline

Demonstration video

Files

Index (frontend)

Feedback (backend)

Implementation - Level 1

Virtual Private Cloud (VPC)

Create a VPC

Create subnets

Create an internet gateway

Edit the route table

Create DynamoDB endpoint

DynamoDB

Identity and Access Management (IAM)

Create a policy

Create a role

EC2

Creating an EC2 instance

Setting up the EC2 instance

Amazon Machine Image (AMI)

Launch Template

Auto Scaling Group

Implementation - Level 2

ZIP of the website

IAM Role

Elastic Beanstalk

S3 Bucket

Route 53 - No hosted zone

Amazon Certificate Manager

CloudFront

Static bucket distribution

Elastic Beanstalk distribution

Route 53

Cost analysis

Level 1

Level 2