{"id":7409,"date":"2020-08-01T11:39:58","date_gmt":"2020-08-01T11:39:58","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/orchestrate-a-gcp-cloud-sql-instance\/"},"modified":"2026-11-03T19:28:39","modified_gmt":"2026-11-03T19:28:39","slug":"orchestrate-a-gcp-cloud-sql-instance","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/en-gb\/blogs\/orchestrate-a-gcp-cloud-sql-instance\/","title":{"rendered":"Orchestrate a GCP Cloud SQL instance"},"content":{"rendered":"

This blog post discusses how you can automate the creation of a Google\u00ae Cloud Platform (GCP) Cloud SQL instance by using Ansible\u00ae and Jenkins\u00ae. The blog also includes an example of spinning up a MySQL\u00ae Cloud SQL instance, version 5.7,
\nwith an Ansible playbook.<\/p>\n

Ansible and Jenkins let you spin up a GCP Cloud SQL instance quickly by accessing Cloud SQL with a project-specific GCP account. This option ensures additional security by providing access to the GCP console only to users with GCP admin access. You can write playbooks for different GCP services and roll out Jenkins jobs to users to spin up GCP infrastructure as needed.<\/p>\n

Necessary tools<\/strong><\/p>\n

To perform this task, you need to use Ansible and Jenkins.<\/p>\n

Ansible – <\/strong>Use this for configuration management and as an orchestration tool in DevOps. Ansible has a wide variety of prebuilt modules written in Python for different products in the market that you can customize by using Python.<\/p>\n

Jenkins – <\/strong>You can use Jenkins as a continuous integration server or as an automation server. Based on Java\u00ae, Jenkins has a wide range of plug-ins for
\ndifferent products. You can customize the plug-ins by using Java or Apache\u00ae Groovy.<\/p>\n

Prerequisites<\/strong><\/p>\n

In this task, Ansible acts as an orchestration tool, and Jenkins acts as an automation server. Prerequisites for doing this task include the following items:<\/p>\n

    \n
  1. Install Jenkins and Ansible, accessible over the Internet, on the server.<\/li>\n
  2. Create a service account, assign a Cloud SQL Admin role to the service account, and download the key of the service account.<\/li>\n
  3. After you create the service account, enable the Cloud SQL Admin API for the project in which you created the service account. Find the URL here<\/a> for enabling the service account by using the following syntax.<\/li>\n
  4. Use the following commands, as the `root` user, to install the required packages on the Ansible Server:<\/li>\n<\/ol>\n

            yum install python-pip
    \n        pip install apache-libcloud
    \n        pip install google-auth<\/em><\/p>\n

    Set up the Ansible playbook<\/strong>
    \nAfter completing the prerequisites, you need to move the Ansible playbook and service account key file to the Jenkins server.<\/p>\n

    Ansible playbook<\/strong><\/p>\n

    An Ansible playbook contains a set of instructions written in YAML. This example uses a gcp\\_sql\\_instance module to spin up the Cloud SQL instance. The following playbook creates a GCP Cloud SQL instance of MySQL database version 5.7:<\/p>\n

    \"ansible<\/p>\n

    The playbook in this example uses the following playbook variables files and
    \nstores them in vars.yml<\/strong>: <\/p>\n

    \n–  project\\_id: cloudsql-258106
    \n–  authentification\\_type: serviceaccount
    \n–  credentials\\_file: \/ansible-play\/cloudsql-auth.json
    \n–  instance\\_name: cloudsql-instance-mysql
    \n–  db\\_version: MYSQL\\_5\\_7
    \n–  gcp\\_region: us-central1
    \n–  instance\\_tier: db-n1-standard-1<\/p>\n

    Jenkins server<\/strong><\/p>\n

    Jenkins is an automation server, and the job is a basic component in Jenkins that you use to define the task that you want to automate.<\/p>\n

    \"ansible<\/p>\n

     <\/p>\n

    The job defines CloudSQL<\/em> as the job name. <\/p>\n

    \"annsible<\/p>\n

     <\/p>\n

    Ansible plug-in in Jenkins <\/strong><\/p>\n

    To run the playbook in a Jenkins job, you must install the Ansible plug-in in Jenkins. Then use that plug-in in the Build<\/strong> step of the Jenkins job to specify the playbook as shown in the preceding screenshot<\/p>\n

    \"ansible<\/p>\n

    After the CloudSQL job runs, you should see output similar to the following output: <\/p>\n

    \"ansible<\/p>\n

     <\/p>\n

    Jenkins user interface <\/strong>
    \nThe following screenshot shows the user interface (UI) in Jenkins that you use to run or make changes to the job. The screenshot shows the MySQL Cloud SQL instance created in GCP after Jenkins job completes:<\/p>\n

    \"ansible<\/p>\n

    Conclusion <\/strong><\/p>\n

    Use Jenkins and Ansible to implement Infrastructure as a Code (IaaC), which helps to avoid human errors during infrastructure spin up and restricts access to the GCP console to a limited set of users. Automating this task by using Ansible and Jenkins provides a GUI for authorized Jenkins users who don’t know GCP or how to spin a Cloud SQL instance.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Orchestrate a GCP Cloud SQL instance<\/p>\n","protected":false},"author":2,"featured_media":7411,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26412","content_type":"blog","created_by":"10130","authored_on":"2023-12-21T12:39:58+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Dinesh Miriam, Oracle Database Administrator, Rackspace Technology","seo_description":"Data clean rooms in Snowflake and implementation of row access policies. Derive information without sharing details.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26412-insights_image-productivity-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"AWS Data","product":"","publisheddate":"2020-08-01T11:39:58","rxt_solutions":"Cloud, Cloud Adoption & Migration","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"GCP Cloud SQL Instance | Rackspace Technology","field_topics":"","field_slug":"orchestrate-a-gcp-cloud-sql-instance","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-7409","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/comments?post=7409"}],"version-history":[{"count":3,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7409\/revisions"}],"predecessor-version":[{"id":9443,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/blogs\/7409\/revisions\/9443"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media\/7411"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/media?parent=7409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/categories?post=7409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/en-gb\/wp-json\/wp\/v2\/tags?post=7409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}