This page walks you through deploying an application and database in multiple regions. It is the fifth and final section of the Develop and Deploy a Global Application tutorial.
Before you begin
Before you begin this section, complete the previous section of the tutorial, Develop a Multi-Region Web Application. After you finish developing and debugging your multi-region application in a local development environment, you are ready to deploy the application and database in multiple regions.
In addition to the requirements listed in Setting Up a Virtual Environment for Developing Multi-Region Applications, make sure that you have the following:
- A Google Cloud account
- The Google Cloud SDK installed on your local machine
- Docker installed on your local machine
Multi-region database deployment
In production, you want to start a secure CockroachDB cluster, with nodes on machines located in different areas of the world. To deploy CockroachDB in multiple regions, we recommend using CockroachDB Dedicated.
You can also deploy CockroachDB manually. For instructions, see the Manual Deployment page of the Cockroach Labs documentation site.
Create a multi-region CockroachDB Dedicated cluster
Log in to your CockroachDB Cloud account.
On the Overview page, select Create Cluster.
On the Create new cluster page:
- For Plan, select CockroachDB Cloud. You won't be charged for the first 30 days of service.
- For Cloud Provider, select Google Cloud.
- For Regions & nodes, add "us-east1", "us-west1", and "europe-west1", with 3 nodes in each region.
- Leave the Hardware and Cluster name as their default values.
- For Additional settings, turn on VPC peering, with the default IP range.
Select Next, and on the Summary page, enter your credit card details.Note:
You will not be charged until after your free trial expires in 30 days.
Select Create cluster.
Your cluster will be created in approximately 20-30 minutes. Watch this video while you wait to get a preview of how you'll connect to your cluster.
Once your cluster is created, you will be redirected to the Cluster Overview page.
On the Cluster Overview page, select SQL Users from the side panel.
Select Add user, give the user a name and a password, and then add the user. You can use any user name except "root".
Select Networking from the side panel, and select Add network.
From the Network dropdown, select Current Network to auto-populate your local machine's IP address. To allow the network to access the cluster's DB Console and to use the CockroachDB client to access the databases, select the DB Console to monitor the cluster and CockroachDB Client to access the databases checkboxes.Note:
After setting up your application's GCP project and GCP VPC network, you will need to return to the Networking page to configure VPC peering.
Open a new terminal window on your local machine, and navigate to the
In the CockroachDB Cloud Console, select Connect at the top-right corner of the page.
Select the SQL User that you created and the Region closest to you, and then select Next.
From the Connection info page, copy the
curlcommand to download the cluster's root certificate, and execute the command in your terminal window. This root certificate is the same for all regions in a cluster.
From the Connection info page, copy the
cockroach sqlcommand. In the terminal window, execute the command with an
-f dbinit.sqloption at the end of the command. For example:
$ cockroach sql --url 'postgresql://user:firstname.lastname@example.org:26257/defaultdb?sslmode=verify-full&sslrootcert='$HOME'/Library/CockroachCloud/certs/root.crt' -f dbinit.sql
This command will initialize the
movrdatabase on your CockroachDB Dedicated cluster.
Global application deployment
To optimize the latency of requests from the application to the database, you need to deploy the application in multiple regions.
This example deploys a secure web application. To take HTTPS requests, the web application must be accessible using a public domain name. SSL certificates are not assigned to IP addresses.
We do not recommend deploying insecure web applications on public networks.
Set up a GCP project
From the GCP console, create a Google Cloud project for the application.Note:
Google Cloud automatically creates a
defaultVPC network for each project.
In the API Library, enable the following APIs for your project:
- Container Registry API
- Cloud Run Admin API
- Serverless VPC Access API
Optional: Enable the Google Maps Embed API, create an API key, restrict the API key to all URLS on your domain name (e.g.,
https://site.com/*), and retrieve the API key.Note:
The example HTML templates include maps. Not providing an API key to the application will prevent the maps from loading, but will not break the rest of the application.
gcloudcommand-line tool to use your project and region.Note:
gcloudis included with the Google Cloud SDK installation.
$ gcloud init
$ gcloud auth login
$ gcloud auth application-default login
Set up VPC peering
Open the CockroachDB Cloud Console for your cluster, select the Networking, and then select VPC peering.
Set up a new VPC peering connection, with your Google Cloud project's ID, the
defaultVPC network created for your Google Cloud project, and a new VPC connection name (e.g.,
gcloudcommand provided by the console, and execute the command in a new terminal window.Note:
The connection strings used to connect to CockroachDB Cloud from an application in a VPC network differ slightly from connection strings to allow-listed IP addresses.
Obtain the VPC connection string for each region:
- Open CockroachDB Cloud Console, and select Connect at the top right of the page.
- Select VPC Peering for Network Security, your SQL username for the SQL User, one of the cluster regions for Region,
movrfor the Database.
- Select Next. On the following page, select the Connection string tab, and then copy the connection string provided.
Take note of each region's connection string. You will need to provide connection information to the Google Cloud Run service in each region.
Open the Google Cloud console for your project. Under the VPC network services, select the Serverless VPC access service.
For each Cloud Run service, create a new VPC connector:
- For Name, use a name specific to the region.
- For Region, use the region of the Cloud Run service.
- For Network, use
- For Subnet, specify a custom IP range. This range must be an unused
/28CIDR IP range (
Containerize the application
Create a new folder named
certsat the top level of the
movr-flaskproject, and then copy the root certificate that you downloaded for your cluster to the new folder. The
Dockerfilefor the application contains instructions to mount this folder and certificate onto the container.
Build and run the Docker image locally.
$ docker build -t gcr.io/<gcp_project>/movr-app:v1 .
If there are no errors, the container built successfully.
Push the Docker image to the Google Cloud project's container registry.
$ docker push gcr.io/<gcp_project>/movr-app:v1
Deploy the application
Create a Google Cloud Run service for the application, in one of the regions in which the database is deployed (e.g.,
- Select the container image URL for the image that you just pushed to the container registry.
Under Advanced settings->Variables & Secrets, do the following:
Set an environment variable named
DB_URIto the VPC connection string for a node on the CockroachDB Dedicated cluster, in the region in which this first Cloud Run service is located.
Verify that the
cockroachdbas the database protocol.
- Includes both the username and password.
- Includes the path to the container-mounted root certificate (e.g.,
Set an environment variable named
REGIONto the CockroachDB Cloud region (e.g.,
Optional: Create a secret for your Google Maps API key and use it to set the environment variable
API_KEY. You may need to enable the Secret Manager API to do this.
Repeat the Google Cloud Run set-up steps for all regions.Note:
Each region has the same root certificate, but different connection strings.
Create an external HTTPS load balancer to route requests to the right service:
- For the backend configuration, create separate network endpoint groups (NEGs) for the Google Cloud Run services in each region.
- For the frontend configuration, make sure that you use the HTTPS protocol. You can create a managed IP address and a managed SSL cert for the load balancer directly from the load balancer console. For the SSL cert, you will need to specify a domain name.
For detailed instructions on setting up a load balancer for a multi-region Google Cloud Run backend, see the GCP Load Balancer docs.
In the Cloud DNS console (found under Network Services), create a new zone. You can name the zone whatever you want. Enter the same domain name for which you created a certificate earlier.
Select your zone, and copy the nameserver addresses (under "Data") for the recordset labeled "NS".
Outside of the GCP console, through your domain name provider, add the nameserver addresses to the authoritative nameserver list for your domain name.Note:
It can take up to 48 hours for changes to the authoritative nameserver list to take effect.
Navigate to the domain name and test out your application.
Develop your own application
This tutorial demonstrates how to develop and deploy an example multi-region application. Most of the development instructions are specific to Python, Flask, and SQLAlchemy, and most of the deployment instructions are specific to Google Cloud Platform (GCP). CockroachDB supports many more drivers and ORM's for development, and you can deploy applications using a number of cloud provider orchestration tools and networking services. We encourage you to modify the code and deployments to fit your framework and use case.
Upgrade your deployment
Some time after you have deployed your application, you will likely need to push changes that you've made locally. When pushing changes, be aware that you defined the database separate from the application. If you change a data type, for example, in your application, you will also need to modify the database schema to be compatible with your application's requests. For information about making online changes to database schemas, see Online Schema Changes.