Open GCP Cloud Shell with SDK pointed at demo project

Run the following to ensure key services are enabled

export PROJECT_ID=$(gcloud config get-value project)
gcloud services enable sqladmin.googleapis.com --quiet
gcloud services enable pubsub.googleapis.com --quiet
gcloud services enable compute.googleapis.com --quiet
gcloud services enable cloudresourcemanager.googleapis.com --quiet
sleep 60

This will take 5-8 minutes to complete. The sleep at the end is meant to avoid timing problems where the APIs won't respond immediately after being enabled.

Run the following get get the current version of demo into home directory

cd ~
rm -rf ce-demo-lms
git clone https://github.com/jwdavis/ce-demo-lms.git
cd ~/ce-demo-lms/terraform

Run the following to populated some Terraform variables. Make sure to replace the placeholders (including the <>) with real values:

export TF_VAR_SUP_PASS=<sup_pass>
export TF_VAR_SQL_PASS=<sql_pass>
export TF_VAR_SQL_SUFFIX=$(date +%Y%m%d%H%M%S)
export TF_VAR_project=$PROJECT_ID

Run the following to do the Terraform build:

terraform init
terraform apply -auto-approve

Installation with take about 20 minutes to complete (Cloud SQL takes a long time to create a primary and 2 read replicas). Also, after TF shows it's down, it may still take 5+ minutes for the load balancer to settle down

Open browser pointed at load balancer IP (this is shown after the setup has completed) and validate app is running

1. Note that MIGs are autoscaling 1-10
2. NGINX servers scale based on LB load
3. Transcoding servers scale based on CPU load
4. Primary Cloud SQL instance is HA
5. There are Cloud SQL read replicas in other regions
6. App is written to read from local replica, write to primary
7. When video is uploaded, app sends pubsub message to topic
8. Transcoding app reads messages about uploads and processes them
9. Server speak to Cloud SQL using Cloud SQL Auth Proxy

1. Custom subnet network is created for solution
2. Firewall rules only allow HTTP traffic from google LBs and HC
3. Cloud SQL Admin API is enabled during setup
4. What might you do differently?

1. it takes a while for the page to update
2. hopefully, it shows traffic from each source going to different backends

1. it takes a while for the page to update

1. the videos are being served by bucket and CDN

1. this takes a while to update

Run the following in Cloud Shell

# Workaround https://github.com/hashicorp/terraform-provider-google/issues/6782
 sudo sysctl -w net.ipv6.conf.all.disable_ipv6=1 net.ipv6.conf.default.disable_ipv6=1 net.ipv6.conf.lo.disable_ipv6=1 > /dev/null
 export APIS="googleapis.com www.googleapis.com storage.googleapis.com iam.googleapis.com cloudresourcemanager.googleapis.com sqladmin.googleapis.com pubsub.googleapis.com compute.googleapis.com"
 for name in $APIS
 do
   ipv4=$(getent ahostsv4 "$name" | head -n 1 | awk '{ print $1 }')
   grep -q "$name" /etc/hosts || ([ -n "$ipv4" ] && sudo sh -c "echo '$ipv4 $name' >> /etc/hosts")
 done
# Workaround end

cd ~/ce-demo-lms/terraform 
terraform destroy -auto-approve && \
   cd ~ && \
   rm -rf ~/ce-demo-lms && \
   export PROJECT_ID=$(gcloud config get-value project) && \

If you receive an error that looks similar to this

terraform dial tcp [2607:f8b0:400c:c15::80]:443: connect: cannot assign requested address

Just rerun the command; eventually it'll all work. This is a bug in TF and Cloud Shell.