Published in


Google Cloud Associate Certified Engineer — 100daysoflearning (Part 7)

Day 43 & 44

In continuation to the course for Google Cloud Associate Certified engineer lets move on with next set of learning topics.

In this section we will lean about variety of Storage options provided by Google cloud. There is not much of practical in this section so I will be writing some stuff about the storage of whatever I understood and also will be pointing to the official documentation at times.
Below is the official flowchat provided by Google for selecting the right Storage option:

GCP Storage Options.

Ok So first I was about to tell and define the flowchart but since it is a flowchart so its quite explanatory so lets do it the other way . I will write all the storage options and then define them and you can fit according to the flowchart. It might act as a glossary or GCP Storage Dictionary . Lets go

Cloud Storage : Cloud storage is an object storage for Google Cloud where you can store different types of files and metadata (key value pairs about the file ). Objects in Cloud Storage are immutable ie. they cannot be changed. Objects a stored in a bucket which is nothing but a folder . For Comparison its like Amazon s3 and Google Cloud Storage have 4 different variety of storage options which comes with different costs:
Multi-Regional- spanned across regions with highest availability of 99.95% SLA it is for very frequent access of data eg content fetching, video applications etc.
Regional- Data Accessed frequently within a region. eg includes Analytics. Its availability is 99.9% SLA
Nearline- This is for Infrequently accessed Data with 99% SLA eg. Rarely accessed Documents.
Coldline- Similar to Glacier its for backup and Archiving Data .
Apart form this there is common terminology for the cloud storage like Objects are the file with metadata and they can have same name within different UNIQUE buckets. So Buckets have to be unique globally but the objects can have same name withing different buckets. Objects are immutable in Nature. You can do versioning of the buckets and can have access to different versions of the same object. You can have a Lifecycle management for your objects which Actions and Condition eg. when the object is 30 days old condition is met then action of moving the object or deleting the object can be performed. You can create Signed URL’s for the read write access with expiry. There is Encryption enabled by default for Storage by Google Cloud by you can use your own keys even manage your own keys or can have client side encryption enabled as per the needs.
So this was the Cloud Storage option in a nutshell.

Cloud Storage Firebase : same as Cloud storage with additional functionality of Mobile SDK support.

Cloud Bigtable — As the Name suggests its a massive table that stores billion of rows. Here columns do not consume any space so there can empty columns as well which leads to thousands of columns. it uses the ‘row key ’ mechanism for finding data. Its often used for Analytics , IOT , Financial data analysis etc. BigTable is really used for MASSIVE amounts of data petabytes of data . So fir Bigtable you create a cluster with 3 nodes (ideal for production environment) all running bigtable and you are getting charged for all the nodes but for that level of data its very cheaper. Master to master replication is very easy between the cluster for High availability and durability.

BigQuery — If you are working with the analytical data and you do not need the frequent updates then you can go for Big Query. it is fully managed data warehouse. you pay for what you use means for the queries you run . So before running the query you can actually check how many bytes its gonna read and this can be done via UI, CLI as well as REST call. So not down the bytes and use google pricing calculator for calculating the costs.

Cloud SQL- Managed Database that supports MYSQL and Postgres, this makes it very easy to migrate on premise application to cloud. It is mainly use for relational data without horizontal scaling like wordpress or drupal applications.

Cloud Spanner- Modern Database built for the cloud. It is Globally Distributed and strongly consistent which makes is highly available , secure and easy to use as it uses sql syntax. Automatic replication is enabled in Cloud Spanner. Google manages the instance created for cloud spanner and so can anytime increase or decrease that.

Cloud Datastore- It is Fully managed Nosql database option provided by google which is built on top of BigTable. Unlike the BigTable it provides sql like query language to query data. It allows strong and eventual consistency when you look up data by key its strong and when you look up by query its eventual .It is a very good option for web and mobile applications if the complex queries are not required.

Cloud Firestore for Firebase- same as Cloud Datastore with support for mobile SDK.

That was all about at a very high level for the different storage options provided by Google Cloud. There is more stuff that has to be done in order to prepare for the certification though like going through each of the database and creating them via console to see what all options are provided and what all things can be don from the Google cloud console. This I will try to cover in a separate post where I will post some screenshots of the different cloud storage options so have a pictorial idea of how each database will look like while creating and after creation. But all in a nutshell briefly this is what Google cloud has to offer for the Database, they have variety of options and the Google price calculator always helps for calculating the cost before you run anything.

Happy Learning
Saiyam Pathak




This publication of my jourey and learning in 100daysof learning challange

Recommended from Medium

How much does a server cost for a small business?

How to write a program

Setting up a Cut Scene in Unity Step 1: Blocking the Shot

Aavegotchi Ecosystem Grants launches to support game development, dapps and moar!

Perl and XML in 2021: A few lessons learned

You should rewrite the application

Hands On With Docker — The Basics

How To Set Up A Medium Article Feed On Your Blog

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Saiyam Pathak

Saiyam Pathak

l CNCF Ambassador | CKA | CKAD | Influx ACE | Multi-cloud certified | Rancher Ranch Hands member

More from Medium

My Learning Path to GCP Associate Cloud Engineer

Google Cloud Associate Cloud Engineer (ACE) certification — Best 2022 resources

Google cloud certified associate cloud engineer badge

Keeping Your Data Safe: Cloud Security(Part 1)

Google Cloud Database