Orchestrate a GCP Cloud SQL instance
This blog post discusses how you can automate the creation of a Google® Cloud Platform (GCP) Cloud SQL instance by using Ansible® and Jenkins®. The blog also includes an example of spinning up a MySQL® Cloud SQL instance, version 5.7, with an Ansible playbook.
Using Ansible and Jenkins lets 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 rollout Jenkins jobs to users to spin up GCP infrastructure as needed.
To perform this task, you need to use Ansible and Jenkins.
Ansible: 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.
Jenkins: You can use Jenkins as a continuous integration server or as an automation server. Based on Java®, Jenkins has a wide range of plug-ins for different products in the market. You can customize the plug-ins by using Java or Apache® Groovy.
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:
Install Jenkins and Ansible, accessible over the Internet, on the server.
Create a service account, assign a Cloud SQL Admin role to the service account, and download the key of the service account.
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 for enabling the service account by using the following syntax:
https://console.developers.google.com/apis/api/sqladmin.googleapis.com/overview?project= "Project ID"
Use the following commands, as the
rootuser, to install the required packages on the Ansible Server:
yum install python-pip pip install apache-libcloud pip install google-auth
Set up the Ansible playbook
After completing the prerequisites, you need to move the Ansible playbook and service account key file to the Jenkins server.
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:
The playbook in this example uses the following playbook variables files and stores them in vars.yml:
- project_id: cloudsql-258106
- authentification_type: serviceaccount
- credentials_file: /ansible-play/cloudsql-auth.json
- instance_name: cloudsql-instance-mysql
- db_version: MYSQL_5_7
- gcp_region: us-central1
- instance_tier: db-n1-standard-1
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.
The job defines
CloudSQL as the job name.
Ansible plug-in in Jenkins
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 step of the Jenkins job to specify the playbook as shown in the preceding screenshot.
After the CloudSQL job runs, you should see output similar to the following output:
Jenkins user interface
The 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:
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.
Use the Feedback tab to make any comments or ask questions.
Optimize your environment with expert administration, management, and configuration
- eCommerce and Digital Experience platforms
- Enterprise Resource Planning (ERP)
- Business Intelligence
- Salesforce Customer Relationship Management (CRM)
- Email Hosting and Productivity
- Unbiased expertise: We simplify and guide your modernization journey, focusing on the capabilities that deliver immediate value.
- Fanatical Experience™: We combine a Process first. Technology second.® approach with dedicated technical support to provide comprehensive solutions.
- Unrivaled portfolio: We apply extensive cloud experience to help you choose and deploy the right technology on the right cloud.
- Agile delivery: We meet you where you are in your journey and align our success with yours.
Chat now to get started.