Setting up Clusters with Prisma Cloud and Google Cloud SQL

This guide gets you up and running with Prisma Cloud and Google Cloud SQL.

In Google Cloud you are able to receive 300$ credit for free for 12 months.

In the following sections, you are going to learn how to:

• Provision a MySQL database instance using Google Cloud SQL
• Set up a new Prisma cluster using the Prisma Cloud Console
• Use the MySQL database as a backing data store for your Prisma cluster

1 Signing up for Google Cloud

If you don't have an Google account yet, sign up here. If you have you can use your Google account.

This process might take a little while, but you'll get there! Note that you'll have to provide credit card info as well as your phone number at some point during the process.

Follow the steps to add your credit card, ...

1.1 Creating a new Google Cloud SQL instance

Create a new project

Click on the red box shown below in the image to create a new project.

Create a name for your project.

Navigate to Google Cloud SQL

In this section, you'll spin up a new Google Cloud SQL instance in the us-east1 region. If you prefer, feel free to choose any of the other supported regions instead:

• us-central1 / US Central (Iowa)
• us-east1 / US East (South Carolina)
• us-east4 / US East (Northern Virginia)
• us-west1 / US West (Oregon)
• southamerica-east1 / South America East (São Paulo)
• northamerica-northeast1 / Canada North-East (Montréal)
• europe-west1 / Belgium (St. Ghislain)
• europe-west2 / Belgium (St. Ghislain)
• europe-west3 / Belgium (St. Ghislain)
• europe-west4 / Belgium (St. Ghislain)
• australia-southeast1 / Australia (Sydney)
• asia-east1 / Asia Pacific (Changhua County, Taiwan)
• asia-northeast1 / Asia Pacific (Tokyo)
• asia-south1 / India (Mumbai)

1.2 Get started

To setup a new Google Cloud SQL instance in the us-east1 region, go in the navigation on the left to Storage/SQL. And click the button Create Instance

1.3 Select DB type

In the Select MySQL, click Next. And you will be prompted between First and Second Generation. Click Choose Second Generation.

1.4 Fill in the instance details

For the the purpose of this you can use whatever you want. For example:

• Instance ID: prisma
• Root password: prisma12345
• Region: us-east1
• Zone: Any

You can change the advanced configurations. But for the purpose of this tutorial we won't get in it.

And click Create

Now your instance is being created. This can take some time.

1.2 Configure access from an external IP-address

Click the name of your instance, in this case prisma.

And continue to the tab Authorization.

Here a network needs to be added. Click Add Network (Step 1), and a box above will appear (Step 2.). And put 0.0.0.0/0 in the Network input (Step 3.), name is optional.

Click Done (Step 4.) to save the changes. Now Prisma Cloud should be able to reach your Google Cloud SQL instance using user root and the password you defined using the public ip of the instance.

The public ip can be found in the tab Overview of your instance located on Connect to this instance.

2. Creating a Prisma cluster

Note: Creating your own Prisma Cluster requires you to provide valid credit card information. Pricing starts at $45 / month per cluster in a pay-as-you-go fashion. Find more info about the pricing here.

2.1 Signing into Prisma Cloud

Navigate to the Prisma Cloud Console and login or sign up.

2.2 Cluster View

To create a new Prisma cluster that is connected to your newly created MySQL database, navigate to the Clusters view by selecting the corresponding tab in the top-menu.

To move on to the form where you can provide the details about your database to connect it with your cluster, click the Create Clusters button.

2.3 Database and cluster information

Note: To learn more about the required information to create a new cluster, you can check out this 3-min tutorial video.

Insert the required data:

• Host: This is the endpoint from the previous section 2.6 Instance settings
• Port: If you haven't made any changes, the default port if 3306
• User: The username you chose in section 2.4 Specify DB details (e.g. myusername)
• Password: The password you chose in section 2.4 Specify DB details (e.g. prismagraphql)

When you're done with that, select click Test connection.

After the connection was successfully tested, you need to provide a Cluster name (e.g. my-cluster) and optionally a Description.

Finally, you need to select a Cluster region - choose the one that's closest to where the majority of your users is supposably located.

If you haven't done so before, you need now need to provide your credit card information. Finally, click Create Cluster.

2.4 Provisioning a cluster

The process of setting up a cluster usually shouldn't take longer than a few seconds. The provisioning status of your cluster will be printed continuously.

You can navigate back to the cluster overview and follow the provisioning status. Once your cluster is up and running, the status says Healthy.

3. Deploying a Prisma service to the cluster

Now that you provisioned a cluster, you can use it as a runtime environment for your Prisma services by using it as a deployment target.

Install the latest CLI version with the following command:

npm install -g prisma

Then, log into your Prisma Cloud account:

prisma login

This will store your cloud session key in ~/.prisma/config.yml. This key is used by the CLI to authenticate you against Prisma Cloud.

Next, go ahead and create a new service:

prisma init hello-world

When prompted by the CLI, choose the Minimal setup: database-only option. Then navigate into the newly created directory and deploy the service:

cd hello-world
prisma deploy

After running prisma deploy, the Prisma CLI will prompt you to choose a cluster you'd like to use as a deployment target. Among the options, you'll find the cluster that you've just setup.

Select the cluster that you just created in the CLI.

This is it - your Prisma service is now deployed to your own Prisma Cloud cluster 🚀

Author

Google Cloud SQL - Maarten Coppens