devopswithcloud / cloudrun-cloudsql-integration-java-app

Create a CloudSql instance

 gcloud sql instances create cloudrun-db-instance \
--database-version=MYSQL_8_0 \
--cpu=1 \
--memory=4GB \
--region=us-central1 \
--authorized-networks 0.0.0.0/0 \
--root-password=Gcp@2022

Create a database

gcloud sql databases create compare_db --instance=cloudrun-db-instance

Run the gcloud sql users create command to create the user.

gcloud sql users create cloud-user \
--instance=cloudrun-db-instance \
--password=Gcp@2022

(Optional) Configure a Cloud Run service account

gcloud iam service-accounts list

gcloud projects add-iam-policy-binding testingiamproject-369302 \
  --member="serviceAccount:SERVICE_ACCOUNT_EMAIL" \
  --role="roles/cloudsql.client"

Configure a Cloud SQL sample app

mvn clean package com.google.cloud.tools:jib-maven-plugin:2.8.0:build \
 -Dimage=gcr.io/testingiamproject-369302/cloudsqlrun:v1 -DskipTests

CLoud run Deploy

gcloud run deploy run-sql --image gcr.io/testingiamproject-369302/cloudsqlrun:v1 \
  --region us-central1 \
  --allow-unauthenticated \
  --add-cloudsql-instances testingiamproject-369302:us-central1:cloudrun-db-instance \
  --set-env-vars INSTANCE_UNIX_SOCKET="/cloudsql/testingiamproject-369302:us-central1:cloudrun-db-instance" \
  --set-env-vars INSTANCE_CONNECTION_NAME="testingiamproject-369302:us-central1:cloudrun-db-instance" \
  --set-env-vars DB_NAME="compare_db" \
  --set-env-vars DB_USER="cloud-user" \
  --set-env-vars DB_PASS="Gcp@2022"

Note

Make sure to create VPC connector in the same n/w where ur cloud sql instance is created