- We assume you already read this: https://cloud.google.com/sql/docs/mysql/connect-external-app#proxy and created a service account for Cloud SQL Client
- Download cloud_sql_proxy to
/usr/local/bin - Make the following folders, all chown to
root:root: /var/run/cloud-sql-proxy/var/local/cloud-sql-proxy- Copy downloaded credential json file inside
/var/local/cloud-sql-proxy, make sure only root can read as it is credential for connection. - Copy above gist to
/lib/systemd/system/cloud-sql-proxy.service - Run
systemctl daemon-reload - Run
systemctl start cloud-sql-proxy - Profit$$$$
-
-
Save tajidyakub/77813bff49090c0e4a722165b68ce2df to your computer and use it in GitHub Desktop.
Example Systemd file for starting cloud sql proxy at system start
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [Install] | |
| WantedBy=multi-user.target | |
| [Unit] | |
| Description=Google Cloud Compute Engine SQL Proxy | |
| Requires=networking.service | |
| After=networking.service | |
| [Service] | |
| Type=simple | |
| WorkingDirectory=/usr/local/bin | |
| ExecStart=/usr/local/bin/cloud_sql_proxy -dir=/var/run/cloud-sql-proxy -instances=<instance_connection_name>=tcp:5432 -credential_file=/var/local/cloud_sql_proxy/<credential_json>.json | |
| Restart=always | |
| StandardOutput=journal | |
| User=root |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment