Setup Metabase using ansible scripts and Docker containers

[vinayvenu]

Action items

Setup Metabase using ansible scripts and Docker containers

Reference documentation

https://www.digitalocean.com/community/tutorials/how-to-use-ansible-to-install-and-set-up-docker-on-ubuntu-20-04

https://docs.ansible.com/ansible/latest/collections/community/docker/docker_container_module.html#ansible-collections-community-docker-docker-container-module-parameter-detach

https://www.hostinger.in/tutorials/docker-cheat-sheet#Container_Interaction_Commands

---

Metabase

• Capture AMI of reporting server ec2 before upgrade
• old version => v0.42.3, targeted version => docker pull metabase/metabase:v0.47.6

---

Approaches discussed

Upgrade metabase jar on Amazon Linux1 instance

=> Doesn't work as metabase:v0.47.6 needs Java11, which doesnt install on Amazon Linux1 instance

Setup new ec2 instance with Metabase running as Docker container within it (Choosen option)

=> setup docker, metabase using ansible
Logs? what to do? // Needs to be purged periodically
Volumes? //Can be ignored, everything is persisted in DB
EC2 instance Management, ALB? // Continue in old manner

Elastic Container Service

• cluster (Reporting)
• task
• service (24/7 Healthcheck run always)
• ALB
• allocate a ec2 instance (Ec2-image-template)
• Network config
• Security group
• CloudWatchLogs (Logs)
  => Too much of departure from current way of working

---

[himeshr]

Created ECS CLuster "reporting" with a task "metabase" to run metabase as a containerized service.

[himeshr]

Using this image, as the ec2 instance is arm64/v8 instanceType.

metabase/metabase#13119 (comment)

[himeshr]

Deploy tasks: (Pending)

• Terminate reporting-db-temp
• terminate t4g reporting-metabase server
• Modify ec2 instance template to use t3 instance instead of t4g(arm64/v8)
• Launch new ec2 instance
• Update route53 mapping to point to new instance
• Update secret to point to reporting-db old rds url
• Run ansible playbook on reporting-metabase using below command
• Run below specified make command to
  • Update ec2 instance env property to point to reporting-db old rds url
  • Restart docker container after rds url change
• Route Reporting ALB traffic to new ec2 instance
• Terminate old prod reporting instance
• Correct reporting-ssh security-group to remove 3000 port

make metabase-onpremise VAULT_PASSWORD_FILE=~/.ssh/infra-valut-pwd-file

[himeshr]

Test instance available at http://13.232.181.189:3000/auth/login?redirect=%2F