Use a customer-managed certificate authority (CA)

This page describes how to use the customer-managed certificate authority (CA) option as the server CA mode for your Cloud SQL instance.

Overview

With the customer-managed CA option, you set up your own CA pool and CA in Certificate Authority Service (CA Service) . When you select the customer-managed CA option, you set up the CA hierarchy and manage the rotation of CA certificates for your Cloud SQL instances.

Before you can configure a Cloud SQL instance to use the customer-managed CA option, you must create a CA pool in the same region as your instance and at least one CA in that pool using CA Service. The CA can be a root CA or a subordinate CA . You also have the option to create a subordinate CA in CA Service and then chain the subordinate CA to an external root CA. When you configure your instance, you specify the CA pool. Your request is delegated to a project-specific service account, which has the permission to use the CA pool. The service account requests a CA from the pool and Cloud SQL uses that CA to sign the server certificate for the instance.

For the server CA mode for your instance in Cloud SQL, you can choose from the following three options:

• internal per-instance CA
• Google-managed shared CA
• customer-managed CA

You might choose the customer-managed CA option if you need to manage your own CA for compliance reasons. For more information about using the other options, see Authorize with SSL/TLS certificates .

Workflow

To use the customer-managed CA option, the workflow is as follows:

1. Create a service account for your Cloud SQL project.
2. Create a CA pool in CA Service.
3. Create a CA in CA Service.
4. Configure the Cloud SQL instance to use the CA. When you configure your instance, you delegate the permission to the service account to sign the server certificate with the CA pool that you created.

Before you begin

Before you use the customer-managed CA option, make sure you meet the following requirements.

Required roles

To get the permissions that you need to create a Cloud SQL-specific service account, ask your administrator to grant you the Service Account Creator ( roles/iam.serviceAccountCreator ) IAM role on for each individual project. For more information about granting roles, see Manage access to projects, folders, and organizations .

You might also be able to get the required permissions through custom roles or other predefined roles .

To get the permissions that you need to create a CA pool and CA, ask your administrator to grant you the CA Service Operation Manager( roles/privateca.caManager ) IAM role on CA Service. For more information about granting roles, see Manage access to projects, folders, and organizations .

You might also be able to get the required permissions through custom roles or other predefined roles .

Create a project-specific service account

In the project where you plan to create your Cloud SQL instances, create a dedicated service account that will handle the request to create and sign the server certificates for your Cloud SQL instances.

gcloud  
beta  
services  
identity  
create  
 \ 
  
--service = 
sqladmin.googleapis.com  
 \ 
  
--project = 
 PROJECT_ID 

Create a CA pool

Create a CA pool in CA Service.

You can create a CA pool in the same project where you plan to create your Cloud SQL instances, or you can create the CA pool in a different project. However, if you create the CA pool in a different project, then VPC Service Controls might block you from creating any Cloud SQL instances depending on organization policy. To fix the issue, make sure that the project that hosts the CA pool and CA and the project that hosts Cloud SQL belong to the same service perimeter. For more information, see Service perimeters and Manage service perimeters .

To create a CA pool, follow the instructions in Create a CA pool . You can accept the default values for the CA pool, with the following required configuration settings:

• Create the CA pool in the same region where you plan to create your Cloud SQL instance. For a list of regions that are supported by Cloud SQL, see Regions .
• Allow configuration based certificate requests.
• Allow DNS names in subject alternative names (SAN). When you configure the identity constraints of the CA pool, don't set any restrictions on the format for the DNS names that might conflict with what Cloud SQL might add to the SAN.

Provide the service account with access to the CA pool

To make sure the service account has the permissions to request and sign certificates for your Cloud SQL instances, grant the following role to the service account for the CA pool that you created:

• roles/privateca.certificateRequester

gcloud  
privateca  
pools  
add-iam-policy-binding  
 CA_POOL_ID 
  
 \ 
  
--project = 
 PROJECT_ID 
  
 \ 
  
--location = 
 REGION 
  
 \ 
  
--member  
serviceAccount: SERVICE_ACCOUNT_NAME 
  
 \ 
  
--role = 
roles/privateca.certificateRequester

Create a CA in the CA pool

Create at least one CA in the CA pool that you created.

You can create a root CA or a subordinate CA.

To create a root CA, follow the instructions in Create a root CA . You can accept the default values for the CA, but make sure that you create the CA in the Enabled state.

If you create a subordinate CA, then you need to create and configure your root CA first.

• To create a subordinate CA in CA Service, follow the instructions in Create a subordinate CA .

• To create a subordinate CA from an external root CA, follow the instructions in Create a subordinate CA from an external root CA .

Configure a Cloud SQL instance to use a customer-managed CA

You can configure a Cloud SQL instance to use the customer-managed CA option when you create the instance. You can also update the server CA mode of an existing an instance from using the per-instance CA or shared CA option to use a customer-managed CA instead.

Create an instance

To create a Cloud SQL instance that uses the customer-managed CA option, do the following.

gcloud  
sql  
instances  
create  
 " INSTANCE_NAME 
" 
  
 \ 
  
--database-version = 
 DATABASE_VERSION 
  
 \ 
  
--project = 
 PROJECT_ID 
  
 \ 
  
--region = 
 REGION 
  
 \ 
  
--server-ca-mode = 
CUSTOMER_MANAGED_CAS_CA  
 \ 
  
--server-ca-pool = 
projects/ PROJECT_ID_CAS 
/locations/ REGION 
/caPools/ CA_POOL_ID 

POST https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/instances

{
  "name":" INSTANCE_ID 
",
  "region":"  REGION 
 
",
  "databaseVersion": " DATABASE_VERSION 
",
  "settings":{
     "ipConfiguration":
      {
         "serverCaPool": "projects/ PROJECT_ID_CAS 
/locations/ REGION 
/caPools/ CA_POOL_ID 
",
         "serverCaMode": "CUSTOMER_MANAGED_CAS_CA"
      }
   }
}

curl -X POST \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json; charset=utf-8" \
-d @request.json \
"https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/instances"

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method POST `
-Headers $headers `
-ContentType: "application/json; charset=utf-8" `
-InFile request.json `
-Uri "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/instances" | Select-Object -Expand Content

{
  "kind": "sql#operation",
  "targetLink": "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/instances",
  "status": "PENDING",
  "user": "user@example.com",
  "insertTime": "2025-01-16T02:32:12.281Z",
  "operationType": "UPDATE",
  "name": " OPERATION_ID 
",
  "targetId": " INSTANCE_ID 
",
  "selfLink": "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID_CSQL 
/operations/ OPERATION_ID 
",
  "targetProject": " PROJECT_ID 
"
}

Update an instance to use a customer-managed CA

Before you update an instance to use a customer-managed CA, do the following:

• Review the list of Google Cloud services that don't support connections to Cloud SQL instances that are configured to use a customer-managed CA. If your deployment is required to use the service, then you might need to delay the update.
• If you're using the Cloud SQL Auth Proxy or any of the Cloud SQL Language Connectors to connect to the instance, then make sure that they're running the minimum required versions. For the Cloud SQL Auth Proxy, make sure you're using version 2.14.3 or later. For the minimum required versions of the Cloud SQL Language Connectors, see Cloud SQL Language Connectors requirements .
• Make sure that you've already created a CA pool and you've provided the service account with access to the CA pool .
• Make sure there's at least one CA in the CA pool.
• To avoid any interruptions after the update, download the certificates from your customer-managed CA and set up your database clients to trust your CA.

Use the following procedure to update a Cloud SQL instance to use the customer-managed CA option.

gcloud  
sql  
instances  
patch  
 INSTANCE_NAME 
  
 \ 
--server-ca-mode = 
CUSTOMER_MANAGED_CAS_CA  
 \ 
--server-ca-pool = 
 projects/ PROJECT_ID_CAS 
/locations/ REGION 
/caPools/CA_POOL_ID 

PATCH https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/instances/ INSTANCE_ID 

{
  "settings":{
     "ipConfiguration":
      {
         "serverCaPool": "projects/ PROJECT_ID_CAS 
/locations/ REGION 
/caPools/ CA_POOL_ID 
",
         "serverCaMode": "CUSTOMER_MANAGED_CAS_CA"
      }
   }
}

curl -X PATCH \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json; charset=utf-8" \
-d @request.json \
"https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/instances/ INSTANCE_ID 
"

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method PATCH `
-Headers $headers `
-ContentType: "application/json; charset=utf-8" `
-InFile request.json `
-Uri "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/instances/ INSTANCE_ID 
" | Select-Object -Expand Content

{
  "kind": "sql#operation",
  "targetLink": "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/instances/ INSTANCE_ID 
",
  "status": "PENDING",
  "user": "user@example.com",
  "insertTime": "2025-01-16T02:32:12.281Z",
  "operationType": "UPDATE",
  "name": " OPERATION_ID 
",
  "targetId": " INSTANCE_ID 
",
  "selfLink": "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/operations/ OPERATION_ID 
",
  "targetProject": " PROJECT_ID 
"
}

Switch an instance from customer-managed CA to shared CA

You can update an instance that uses customer-managed CA to use a shared CA ( GOOGLE_MANAGED_CAS_CA ). However, you can't update an instance that's configured to use a customer-managed CA to use the per-instance CA ( GOOGLE_MANAGED_INTERNAL_CA ).

Before you update an instance to use a shared CA, download the global and regional CA bundles , copy them to your database clients, and let them trust these CAs. Setting up the certificates before switching server CA mode configuration can help avoid potential interruption for your database clients.

To switch the server CA mode of your instance to use the shared CA, use the following procedure.

gcloud  
sql  
instances  
patch  
 INSTANCE_NAME 
  
 \ 
--server-ca-mode = 
GOOGLE_MANAGED_CAS_CA  
 \ 
--server-ca-pool = 
 "" 

PATCH https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/instances/ INSTANCE_ID 

{
  "settings":{
     "ipConfiguration":
      {
         "serverCaPool": "",
         "serverCaMode": "GOOGLE_MANAGED_CAS_CA"
      }
   }
}

curl -X PATCH \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json; charset=utf-8" \
-d @request.json \
"https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/instances/ INSTANCE_ID 
"

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
-Method PATCH `
-Headers $headers `
-ContentType: "application/json; charset=utf-8" `
-InFile request.json `
-Uri "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/instances/ INSTANCE_ID 
" | Select-Object -Expand Content

{
  "kind": "sql#operation",
  "targetLink": "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/instances/ INSTANCE_ID 
",
  "status": "PENDING",
  "user": "user@example.com",
  "insertTime": "2025-01-16T02:32:12.281Z",
  "operationType": "UPDATE",
  "name": " OPERATION_ID 
",
  "targetId": " INSTANCE_ID 
",
  "selfLink": "https://sqladmin.googleapis.com/v1/projects/ PROJECT_ID 
/operations/ OPERATION_ID 
",
  "targetProject": " PROJECT_ID 
"
}

Troubleshoot

What's next

• Learn more about CA hierarchies in Cloud SQL
• Set up a custom DNS name for your instance