Demonstration: Getting Started with Cloud Storage and Cloud SQL

Loading...

From the course by Google Cloud

Google Cloud Platform Fundamentals: Core Infrastructure

11141 ratings

Google Cloud

Google Cloud Platform Fundamentals: Core Infrastructure

11141 ratings

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

***NEW! Specialization Completion Challenge, receive Qwiklabs credits valued up to $180! See below for details.*** 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. SPECIALIZATION COMPLETION CHALLENGE As if learning new skills wasn’t enough of an incentive, we're excited to announce a special completion challenge for the 'Infrastructure' specializations. Here’s how it works: Our completion challenge runs through 11:59pm PT May 5, 2019. Complete any course in this Specialization including this one, anytime in this period and we'll send you 30 Qwiklabs credits for each course completed (upto $180 value given there are 6 courses in the Architecting with GCP specialization). You can use these credits to take additional labs and earn badges, which you can then add to your resume and social profiles. Your challenge awaits – begin learning on Coursera today! Note: •Google services are currently unavailable in China.

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

Meet the Instructors

Google Cloud Training

First we create a web server.

In the GCP Console's Product 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