Set up Gemini in Databases

To set up Gemini in Databases, your team needs to perform the setup steps that are described in this document:

1. Enable the Recommender API.

2. Enable Index Advisor (only applicable to Cloud SQL for PostgreSQL and Cloud SQL for MySQL.)

3. Enable Gemini in Databases.

Important: You cannot disable Gemini in Databases after you enable it.

Enable the Recommender API

• Enable the Recommender API.

  Enable the API

Enable Index Advisor

Do one of the following:

• To enable Index Advisor for Cloud SQL for PostgreSQL instances, run the following Google Cloud CLI command:

  gcloud sql instances patch INSTANCE_NAME \
      --database-flags=cloudsql.enable_index_advisor=on
  

  Replace INSTANCE_NAME with your instance's name.

• To enable Index Advisor for Cloud SQL for MySQL instances, run the following gcloud CLI command:

  gcloud sql instances patch INSTANCE_NAME \
      --database-flags=cloudsql_index_advisor=on,performance_schema=on
  

  Replace INSTANCE_NAME with your instance's name.

Enable Gemini in Databases

Important: It might take between 24 and 48 hours for Gemini in Databases to be enabled.

1. In the Google Cloud console, go to the Database Center page.

   Database Center

2. Select a project.

3. Do one of the following:

   • In the page banner, click Explore the rest of Gemini in Databases.
   • At the end of the page, click Explore Gemini in Databases.

   The Explore Gemini pane is displayed.

4. Click Enable.

To enable Gemini in Databases, you must have the roles/billing.admin Identity and Access Management (IAM) role.