How to deploy on GCE
Google Compute Engine is a popular subsidiary of Google that provides on-demand cloud computing platforms on a metered pay-as-you-go basis. Access the GCloud web console at console.cloud.google.com.
Summary
- Install GCloud and Juju tooling
- Bootstrap Juju controller on GCE
- Deploy charms
- Expose database (optional)
- Clean up
Install GCloud and Juju tooling
Install Juju via snap:
sudo snap install juju
sudo snap install google-cloud-cli --classic
Check the official the Google Cloud (GCloud) CLI documentation about other installation options.
To check they are all correctly installed, run the commands demonstrated below with sample outputs:
> juju version
3.5.4-genericlinux-amd64
> gcloud --version
Google Cloud SDK 474.0.0
...
Authenticate
Login to GCloud:
gcloud auth login
Create an service IAM account for Juju to operate GCE:
> gcloud iam service-accounts create juju-gce-account --display-name="Juju GCE service account"
Created service account [juju-gce-account].
> gcloud iam service-accounts list
DISPLAY NAME EMAIL DISABLED
...
Juju GCE service account [email protected] False
...
> gcloud iam service-accounts keys create sa-private-key.json --iam-account=juju-gce-account@canonical-data-123456.iam.gserviceaccount.com
created key [aaaaaaa....aaaaaaa] of type [json] as [sa-private-key.json] for [[email protected]]
> gcloud projects add-iam-policy-binding canonical-data-123456 --role=roles/compute.admin \
--member serviceAccount:[email protected]
Bootstrap Juju controller on GCE
It is necessary to move the newly exported GCloud json file into a SNAP-accessible folder due to a known Juju issue.
sudo mv sa-private-key.json /var/snap/juju/common/sa-private-key.json
sudo chmod a+r /var/snap/juju/common/sa-private-key.json
Add GCE credentials to Juju:
> juju add-credential google
...
Enter credential name: juju-gce-account
...
Auth Types
jsonfile
oauth2
Select auth type [jsonfile]: jsonfile
Enter path to the .json file containing a service account key for your project
Path: /var/snap/juju/common/sa-private-key.json
Credential "juju-gce-account" added locally for cloud "google".
Bootstrap a Juju controller (check all supported configuration options):
juju bootstrap google gce
Output example
> juju bootstrap google gce
Creating Juju controller "gce" on google/us-east1
Looking for packaged Juju agent version 3.5.4 for amd64
Located Juju agent version 3.5.4-ubuntu-amd64 at https://streams.canonical.com/juju/tools/agent/3.5.4/juju-3.5.4-linux-amd64.tgz
Launching controller instance(s) on google/us-east1...
- juju-33f662-0 (arch=amd64 mem=3.6G cores=4)
Installing Juju agent on bootstrap instance
Waiting for address
Attempting to connect to 35.231.246.157:22
Attempting to connect to 10.142.0.17:22
Connected to 35.231.246.157
Running machine configuration script...
Bootstrap agent now started
Contacting Juju controller at 35.231.246.157 to verify accessibility...
Bootstrap complete, controller "gce" is now available
Controller machines are in the "controller" model
Now you can run
juju add-model <model-name>
to create a new model to deploy workloads.
You can check the GCE instance availability (ensure the right GCloud project chosen!):
Create a new Juju model:
juju add-model welcome
(Optional) Increase the debug level if you are troubleshooting charms:
juju model-config logging-config='<root>=INFO;unit=DEBUG'
Deploy charms
The following command deploys MySQL and Data-Integrator (the charm to request a test DB):
juju deploy mysql
juju deploy data-integrator --config database-name=test123
juju relate mysql data-integrator
Check the status:
> juju status --relations
Model Controller Cloud/Region Version SLA Timestamp
welcome gce google/us-east1 3.5.4 unsupported 23:49:56+02:00
App Version Status Scale Charm Channel Rev Exposed Message
data-integrator active 1 data-integrator latest/stable 41 no
mysql 8.0.36-0ubun... active 1 mysql 8.0/stable 240 no
Unit Workload Agent Machine Public address Ports Message
data-integrator/0* active idle 1 104.196.104.248
mysql/0* active idle 0 34.138.135.20 3306,33060/tcp Primary
Machine State Address Inst id Base AZ Message
0 started 34.138.135.20 juju-257803-0 [email protected] us-east1-c RUNNING
1 started 104.196.104.248 juju-257803-1 [email protected] us-east1-d RUNNING
Integration provider Requirer Interface Type Message
data-integrator:data-integrator-peers data-integrator:data-integrator-peers data-integrator-peers peer
mysql:database data-integrator:mysql mysql_client regular
mysql:database-peers mysql:database-peers mysql_peers peer
mysql:restart mysql:restart rolling_op peer
mysql:upgrade mysql:upgrade upgrade peer
Once deployed, request the credentials for your newly bootstrapped MySQL database.
For Juju 2.9 use:
juju run-action --wait data-integrator/leader get-credentials
and for newer Juju 3+ use:
juju run data-integrator/leader get-credentials
Output example:
mysql:
data: '{"database": "test123", "external-node-connectivity": "true", "requested-secrets":
"[\"username\", \"password\", \"tls\", \"tls-ca\", \"uris\"]"}'
database: test123
endpoints: 10.142.0.21:3306
password: zDPalkEi1Uaj26oDSYjCoWYl
username: relation-4
version: 8.0.36-0ubuntu0.22.04.1
ok: "True"
At this point, you can access your DB inside GCloud using the internal IP address. All further Juju applications will use the database through the internal network:
> mysql -h 10.142.0.21 -P 3306 -u relation-4 -pzDPalkEi1Uaj26oDSYjCoWYl test123
...
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| performance_schema |
| test123 |
+--------------------+
3 rows in set (0.13 sec)
From here you can use/scale/backup/restore/refresh your newly deployed Charmed MySQL.
Expose database (optional)
To access the database from outside of GCloud (warning: opening ports to public is risky) open the GCloud firewall using the simple juju expose functionality:
juju expose mysql
Once exposed, you can connect your database using the same credentials as above. Important: this time, use the GCE Public IP assigned to the MySQL instance:
> juju status mysql
...
Unit Workload Agent Machine Public address Ports Message
mysql/0* active idle 0 34.138.135.20 3306,33060/tcp Primary
...
> mysql -h 34.138.135.20 -P 3306 -u relation-4 -pzDPalkEi1Uaj26oDSYjCoWYl test123
...
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| performance_schema |
| test123 |
+--------------------+
3 rows in set (0.13 sec)
To close public access, run:
juju unexpose mysql
Clean up
Always clean GCE resources that are no longer necessary - they could be costly!
To destroy the Juju controller and remove GCE instance, run:
Warning: all your data will be permanently removed
> juju controllers
Controller Model User Access Cloud/Region Models Nodes HA Version
gce* welcome admin superuser google/us-east1 2 1 none 3.5.4
> juju destroy-controller gce --destroy-all-models --destroy-storage --force
Next, check and manually delete all unnecessary GCloud resources, to show the list of all your GCE instances run the following command (make sure the correct region used!):
gcloud compute instances list
Output example
NAME ZONE MACHINE_TYPE PREEMPTIBLE INTERNAL_IP EXTERNAL_IP STATUS
juju-33f662-0 us-east1-b n1-highcpu-4 10.142.0.17 35.231.246.157 RUNNING
juju-e2b96f-0 us-east1-b n2d-highcpu-2 10.142.0.18 35.237.64.81 STOPPING
juju-e2b96f-1 us-east1-d n2d-highcpu-2 10.142.0.19 34.73.238.173 STOPPING
List your Juju credentials:
> juju credentials
...
Client Credentials:
Cloud Credentials
google juju-gce-account
...
Remove GCloud credentials from Juju:
> juju remove-credential google juju-gce-account
Finally, remove the GCloud json file user credentials (to avoid forgetting and leaking):
rm -f /var/snap/juju/common/sa-private-key.json