To set up Gemini in Databases, your team needs to perform the setup steps that are described in this document:
Enable Index Advisor (only applicable to Cloud SQL for PostgreSQL and Cloud SQL for MySQL.)
Enable the Recommender API
-
Enable the Recommender 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
In the Google Cloud console, go to the Database Center page.
Select a project.
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.
Click Enable.
To enable Gemini in Databases, you must have the
roles/billing.admin
Identity and Access Management (IAM) role.