Explore
For Enterprise
Join for Free
Log In

Arts and Humanities
Business
Computer Science
Data Science
Information Technology
Health
Math and Logic
Personal Development
Physical Science and Engineering
Social Sciences
Language Learning
Degrees
Certificates

Explore all of Coursera

Browse
Search
For Enterprise
Log In
Join for Free

Demonstration: Getting Started with Cloud Storage and Cloud SQL

Loading...

Google Cloud Platform Fundamentals: Core Infrastructure

4.7 (13,913 ratings) | 140K Students Enrolled

Course 1 of 4 in the Architecting with Google Kubernetes Engine Specialization

This course introduces you to important concepts and terminology for working with Google Cloud Platform (GCP). You learn about, and compare, many of the computing and storage services available in Google Cloud Platform, including Google App Engine, Google Compute Engine, Google Kubernetes Engine, Google Cloud Storage, Google Cloud SQL, and BigQuery. You learn about important resource and policy management tools, such as the Google Cloud Resource Manager hierarchy and Google Cloud Identity and Access Management. Hands-on labs give you foundational skills for working with GCP. Note: •Google services are currently unavailable in China.

Skills You'll Learn

Google Compute Engine, Google App Engine (GAE), Google Cloud Platform, Cloud Computing

Reviews

4.7 (13,913 ratings)

5 stars
10,312 ratings
4 stars
3,151 ratings
3 stars
362 ratings
2 stars
46 ratings
1 star
42 ratings

SV

Feb 15, 2018

This was one of the best learning I had. Very simple and easy way to do the labs and understand the concepts. Even though the content is around fundamentals, it helps to remember the terminologies.

MS

Jan 06, 2019

Great introductions course. Very nice instructors with great charisma and skills. Useful labs, very thoughtful. I definitely recommend this course everyone who is willing to get started with GCP!

From the lesson

Storage in the Cloud

Every application needs to store data. Different applications and workloads require different storage and database solutions. This module describes and differentiates among GCP's core storage options: Cloud Storage, Cloud SQL, Cloud Spanner, Cloud Datastore, and Google Bigtable.

Demonstration: Getting Started with Cloud Storage and Cloud SQL10:34

Taught By

Google Cloud Training

Transcript

First we create a web server.

In the GCP Console's Products and Services menu,

I scroll down to Compute Engine,

and choose VM instances.

I'll create an instance.

I'll name the instance: bloghost.

And I'll leave it in the offered zone us-central1-a.

I'll take the other defaults.

And I'll configure the firewall to allow HTTP traffic in.

I also want to add a startup script.

This startup script will install a web server.

I click Create,

and the Virtual Machine instance is created for me.

Notice its external IP address. We'll need that later.

Now I'm going to make a Cloud Storage bucket

using Cloud Shell.

I enter the command: gsutil mb -l

then I name the location

in which I want the bucket to reside.

In this case, the US Multi-Region.

The name of my Cloud Storage bucket must be globally unique,

and the easiest way to make sure of this

is to name the bucket after my GCP Project ID,

which is also globally unique.

In the Cloud Shell, the environment variable

$DEVSHELL_PROJECT_ID always contains my project ID.

Now I've created my bucket.

I'm going to copy a graphical image

from another Cloud Storage bucket,

this one called: cloud-training.

Now I have the graphical image here in my directory,

my-excellent-blog.png.

Now I use the gsutil cp command again

to upload it to my own Cloud Storage bucket.

I can see the resulting file,

both from the command line using: gsutil ls...

...and also from the GCP Console's Storage Browser.

There's my bucket,

and there's the object I created in the bucket.

Recall that my VM instance is in zone us-central1-a.

Now we'll create a Cloud SQL instance

in the same zone.

In the Products and Services menu,

we scroll down to SQL.

We choose MySQL for our database engine,

Second Generation.

We name our instance "blog-db"

and we define a root password.

We'll place this instance in the same zone

as our Compute instance.

When the database instance has been made,

we click on its name to configure it.

With my database instance finished provisioning,

I can click on its name to configure it.

I want to create a MySQL username called: blogdbuser.

I'll define a password.

Now I want to configure this database instance so that

it can be only contacted from my Virtual Machine instance.

So I need to go back to its entry

in the VM instance's listing and capture its public IP address.

There it is. We'll copy it.

We return to our SQL instance,

click on our instance name,

and click Authorization.

We wish to authorize a network consisting only of

the desired VM instance.

We'll name the network: web front end

and insert the IP address of that instance

followed by /32.

Now our database instance is protected

from broad internet access.

Now I'm going to return to my Virtual Machine

and configure it to use the resources we've set up.

I'll log into it using SSH.

I'm going to edit its PHP homepage.

I've prepared a page that I can paste in.

I'll fill in my database's IP address and password.

Notice the comment.

In a real blog, we would never store the MySQL password

anywhere in the document root.

Instead, we would store it in a separate configuration file

somewhere else in the web server Virtual Machine.

Now let's try it.

We'll restart the web server daemon.

Now we'll return to the GCP Console's VM instances list

and attempt to view the homepage.

Our database connection succeeded.

If this were a real blog, we would now begin to

load blog content into our SQL database.

Now let's enhance our homepage

by adding our graphical image to it.

In the GCP Console, we'll navigate to the Storage Browser

and create a public link to our graphical image.

There's the image.

We check the box: Share publicly.

That gives us a hyperlink that we can clone.

Now we return to our PHP homepage

and add in an HTML reference to that image.

Now let's return to our PHP homepage and refresh it.

Our page now contains an image hosted in Google Cloud Storage.

Explore our Catalog

Join for free and get personalized recommendations, updates and offers.

Coursera provides universal access to the world’s best education, partnering with top universities and organizations to offer courses online.

© 2019 Coursera Inc. All rights reserved.

Download on the App Store

Get it on Google Play

Coursera
About
Leadership
Careers
Catalog
Certificates
MasterTrack™ Certificates
Degrees
For Enterprise
For Government

Community
Learners
Partners
Developers
Beta Testers
Translators

Connect
Blog
Facebook
LinkedIn
Twitter
Instagram
YouTube
Tech Blog

More
Terms
Privacy
Help
Accessibility
Press
Contact
Directory
Affiliates