Connect from Cloud Run

Create a cluster and its primary instance

1. In the Google Cloud console, go to the Clusters page.

   Go to Clusters

2. Click Create cluster.

   The Google Cloud console presents you with a choice of cluster types. Select Highly available.

3. Click Continue.

   The Configure your cluster section expands.

4. Under Basic info, in the Cluster ID field, enter my-cluster.

5. In the Password field, enter any password you'd like. Take note of this password. You use it again later in this quickstart.

6. In the Region field, select us-central1 (Iowa).

7. Under Networking, select default.

   If you have not set up private services access yet, a dialog labeled Private service access connection required appears.

   In the Private service access connection required dialog, to create private services access connection, complete the following:

   1. Click Set up connection.

      A new pane labeled Enable Service Networking API appears.

   2. In the pane, select Use an automatically allocated IP range.

   3. Click Continue.

   4. Click Create connection, and wait for the connection configuration to finish.

      The pane is removed.

8. Click Continue.

   The Configure your primary instance section expands.

9. Under Basic info, in the Instance ID field, enter my-primary.

10. For a Machine value, select 2 vCPU, 16 GB.

11. Click Create cluster.

    Wait for the cluster to get created.

Connect to your instance and create a database

1. If you are not in your newly created cluster Overview page, then in the Google Cloud console, go to the Clusters page.

   Go to Clusters

2. To display the cluster Overview page, click the my-cluster cluster name.

3. In the navigation menu, click AlloyDB Studio.

4. In the Database list on the Sign in to AlloyDB Studio page, select postgres.

5. In the User drop-down list, select postgres.

6. In the Password field, enter the password you created in Create a cluster and its primary instance.

7. Click Authenticate. The Explorer pane displays a list of the objects in your database.

8. In the Editor 1 tab, create a database:

   CREATE DATABASE quickstart_db;
   

9. Click Run. Wait for the Statement executed successfully message to display in the Results pane.

Find your project ID

1. Go to the Dashboard page in the Google Cloud console.

   Go to Dashboard

2. Find the project ID on the Project info card.

3. Take note of your project ID. You need it for the following step of this quickstart.

Populate Artifact Registry with an image of the sample application

1. In the Google Cloud console, open Cloud Shell.

   Open Cloud Shell

2. In Cloud Shell Editor, use the following command to clone the repository with the sample application code from GitHub:

   cloudshell_open --repo_url \
   "https://github.com/GoogleCloudPlatform/alloydb-auth-proxy" \
   --dir \
   "examples/go" \
   --force_new_clone

3. Create a repository in Artifact Registry for docker images:

   gcloud artifacts repositories create cloud-run-source-deploy --location us-central1 --repository-format=docker --project PROJECT_ID

   Replace PROJECT_ID with the ID of your project.

4. In the Authorize Cloud Shell dialog, click Authorize. This prompt does not appear if you have done this step previously.

5. To build a Docker container and publish it to Artifact Registry, use the following command:

    gcloud builds submit --tag  us-central1-docker.pkg.dev/PROJECT_ID/cloud-run-source-deploy/run-sql --project PROJECT_ID

   Replace PROJECT_ID with the ID of your project.

Find the IP address for your new instance

1. In the Google Cloud console, go to the Clusters page.

   Go to Clusters

2. Find the row in the table whose Resource name is my-primary.

3. Take note of that row's Private IP address. You need it for the following step of this quickstart.

   The example format of the IP address is 172.19.209.2:5432.

Create a service for Cloud Run

1. In the Google Cloud console, go to the Cloud Run page.

   Go to Cloud Run

2. In the Services tab, click Create Service.

3. In the Container image URL field, click Select.

4. In the Select container image pane, complete the following steps:

   1. Select the Artifact registry tab.
   2. Expand us-central1-docker.pkg.dev/PROJECT_ID/cloud-run-source-deploy.
   3. Expand run-sql.
   4. Select the latest image.
   5. Click Select.

5. In the Service name field, enter quickstart-service.

6. Make sure us-central1 (Iowa) is selected in the Region list by default.

7. In the Authentication section, select Allow unauthenticated invocations.

8. Ensure that CPU is only allocated during request processing is selected in the CPU allocation and pricing section.

9. Expand the Container(s), Volumes, Networking, Security section.

10. In the Container(s) tab, select the Variables & secrets tab and complete the following steps:

    1. In the Environment variables section, click Add variable.

    2. Enter the following in the Name and Value fields:

       • DB_NAME: quickstart_db
       • DB_USER: postgres
       • DB_PASS: The password that you entered when you created the cluster in Create a cluster and its primary instance.
       • DB_PORT: 5432
       • INSTANCE_HOST: The IP address of your cluster's primary instance, which you found in Find the IP address for your new instance. Don't include the port number—for example, set to 172.19.209.2, and not 172.19.209.2:5432.

11. Switch from the Container(s) tab to the Networking tab and complete the following steps:

    1. Select the Connect to a VPC for outbound traffic checkbox.

    2. Select the Send traffic directly to a VPC option.

    3. In the Network drop-down list, choose the default value.

    4. In the Subnet drop-down list, ensure that the default value is selected.

12. Click Create to create the Cloud Run service.

    After the Cloud Run service is deployed, the quickstart-service page displays the URL of the sample application in the URL field.

    The application uses AlloyDB as its datastore.

View the sample application

1. In the Google Cloud console, go to the Cloud Run page.

   Go to Cloud Run

2. On the quickstart-service page, click content_copy Copy to clipboard to copy the application URL.

3. In a new browser tab, paste the copied application URL and click Enter.

   The sample vote-collecting web application that appears looks similar to the following: