Introduction to Google Cloud SQL

Lab Details:

  1. This lab walks you through Google Cloud SQL and its features.

  2. You will be creating a Database Instance initially.

  3. Secondly, you will create your Database.

  4. Finally, you will create your tables and insert data into the table.

  5. Region: us-central1 , Zone: us-central1-a

  6. Duration: 45 minutes

Note: Do not refresh the page after you click Start Lab, wait for a few seconds to get the credentials.
In case while login into Google, if it asks for verification, please enter your mobile number and verify with OTP, Don't worry this Google Account will be deleted after the lab.

What is Google Cloud SQL?

Google Cloud SQL is a relational database service where its main offerings are relational data, transactional data (mainly used in banks). For e.g. Without database transactions your bank would not offer you to transfer money from one account to another, What if the transfer of $100 didn't result in receiving in destination account, your bank just lost $100. That's why SQL is required. It has features like commit or rollback.

  • A classic relational database has a lot of setup required, management, Configuration, maintenance, administer, to get rid of all these. GCP provides you a platform where one can easily manage or administer your database instances.

  • It offers MySQL, PostgreSQL, SQL Server as a fully managed service, it offers a database that is capable of handling terabytes of data (up to 30 TB). You always have an option of running your own DB server in VM machine but then you have management overhead.

  • It provides read replica, external replica, failover features, if there is an outage, it will failover to another zone

  • Backup option is there, either scheduled or on-demand

  • You can scale vertically by changing machine type or horizontally like Read replica

  • Customer data is always encrypted where on google internal network or in DB tables, or in the backup.

  • Cloud SQL is compatible with other Google services like app engine, compute engine, or external applications also like MySQL workbench.

  • It reduces maintenance costs and automates Database provisioning, backups, patches, capacity increases ensuring 99.95% availabilty.

  • It provides you High Availability with automatic failover.

  • Data is always encrypted at rest or in transit

  • It helps you focus on your app rather than management.

Architectural Diagram:

  • The primary instance writes logs to the system database every second in terms of the heartbeat signal, in any case, if heartbeats aren't detected for 60 seconds, a failover process is initiated. This may also occur if the zone containing the primary instance experiences an outage. In case of failover, the standby instance serves as a backup database from the secondary zone.

Lab Tasks:

  1. Starting Cloud Shell.

  2. Creating a Database instance.

  3. Creating a MySQL Database.

  4. Creating a table in your database.

  5. Inserting data into your table.

Join Whizlabs_Hands-On to Read the Rest of this Lab..and More!

Step 1 : Login to My-Account
Step 2 : Click on "Access Now" to view the course you have purchased
Step 3 : You will be taken to our Learn Management Solution (LMS) to access your Labs,Quiz and Video courses

Open Console