Google Cloud Platform(GCP)-Google Cloud SQL

What is Google Cloud SQL

It is part of Google Cloud Platform(GCP), GCP have lot of software for different type of problem

Google Cloud Platform

• Google Cloud SQL is based on MySQL 5.5 standard
• Very flexible and low cost- Google Provide several Pricing mechanism.
• secure and durable- Google Cloud SQL instance run inside Google infrastructure (Google data center), we can reliable on Google for their security track record.
• easier migration
• lot of control - provide browser based WEB UI as well as CLI to manage Google Cloud SQL instance.
• Fully managed -  don't need to worry about backup and recovery
• Easily integrated with other application or other GCP application.

Why MySQL

• Easy to use
• Time tested run from near 70s
• most popular database in world

 Getting Started With Google Cloud SQL

Introduction to Admin Tools

First we look some admin tools available to use and for up and running Google Cloud SQL

3 way to create and work with Google Cloud SQL i.e. Admin Tools for managing Google Cloud SQL instance

1. Developer's Console( Web UI)
2. GCloud Utility Command Line Interface
3. Client Libaray API

These are not tools to write query, these are tools that actually create Google Cloud SQL instance.
        Some interesting fact about Google Cloud SQL instance
Google Cloud SQL instance is in memory database, i.e. it is not located any where at disk, it reside in memory of SERVER.

 1. Google Cloud SQL - Admin Tool - DEVELOPER'S Console (Web UI)

• Browser Based
• Easy to use
• Feature Rich but not feature complete.

You can compare this interface with any MySQL Server interface like PHPMyadmin etc.

2. Google Cloud SQL - Admin Tool - GCloud Utiltiy (CLI)

      It is more robust tools, for managing Google Cloud SQL instances

• it is locally installed software , we need to installed Google Cloud SDK.
• it is totally CLI based tools
• it has more feature than Web UI

3. Google Cloud SQL - Admin Tool - CLIENT LIBRARIES
   Its is programmatic API


These three tools are based on REST API-  All Three managing tool actually invoke Restful -API

Introduction to Google Cloud SQL Pricing Model 

Pricing for the Google Cloud SQL product  is not relatively inexpensive but it is also  fairly straight forward.

Google Divide his Google Cloud SQL pricing model in Two Category.

1. Cloud SQL Second Generation Pricing

 This is a Beta release of Cloud SQL.


2. Google Cloud SQL First Generation Pricing
For first Generation instance, Google offers two billing plans : Package and Per USe

Package Pricing model include per day charge for that particular instance active and it also includes some storage and IOPS.Any thing above the base include storage and IOPS is going to be charge according to Per use pricing model.

Package Pricing (Source : Google Website)

Per-Use Pricing Model is better option if your use is less.

Per Use Pricing (Source Google Website)

you also pay for network uses but you only pay for that traffic that leave Google Cloud Infrastructure.

If you required static IP for your instance than you need to pay for that.

For more information you can visit https://cloud.google.com/sql/pricing

Create Google Cloud Platform Account

Step 1 : Open https://cloud.google.com/  in web browse.

Step 2 : Login using existing Google Account

Step 3 : After Login Screen will appear like this, Click on My Console.

Step 4 : Set up Billing Account, You need to provide Basic Detail and credit card information for creating billing account after that you are able to create Google Cloud SQL instance.

Step 5 : Google Provide free $300 for trying Google Cloud Platform Product.

Step 6.  Create Project