Set up Looker cluster on Azure.md

How to set up a Looker cluster on Azure

Install Terraform

1. Download terraform binary
2. Install Azure CLI curl -L https://aka.ms/InstallAzureCli | bash
3. Login with az login you will be taken to the browser and returned to the shell

Step 1. Create Resource Group

Step 2. Provision Compute

• create app server looker-1
• create database server mysql (must click on star to get to Microsoft Azure Database for MySQL)
• create user and password to connect to managed mysql instance, write it down!
• open ports to current public IP

• The Ubuntu 18.04 instances available on Azure don't have a JDK

• Need to download the binary from Oracle's website for v8 and then scp it to box

• Untar files

• Export path of /bin: ** export PATH="pwd:$PATH"

• Add users and groups per docs https://docs.looker.com/setup-and-management/on-prem-install/installation

• Download Looker jar file to /home/looker

• Download startup script

• Install libssl and libcrypt.so ** sudo apt-get install libssl-dev

• Looker customer-scripts startup-scripts looker github

• wget this file

• chmod 750 looker (this is the jar - rename from looker-latest.jar)

• Open port 9999

• Access over https protocol

• Create new account and add license key

• Install mysql client and connect to managed mysql instance that was created earlier

• Connect to mysql from the command line

• Need to fully-qualify the username like user@host

Step 3. Log in to Looker-1

sudo apt update sudo apt install oracle-java8-set-default

Step 4. Follow instructions to migrate internal database from HSQL to MySQL

Make sure username is fully-qualified in database.yml

https://discourse.looker.com/t/migrating-looker-backend-database-to-mysql/2384

Step 5. You need an Azure storage account

Also need to create a file share (equivalent of an S3 bucket) Install samba Install cifs-utils