1. Home
  2. Training Library
  3. Google Cloud Platform
  4. Courses
  5. Data Management on Google Cloud Platform

MySQL-based databases with Google Cloud SQL

Start course
Overview
Difficulty
Beginner
Duration
27m
Students
697
Description

Data Management is critical for all server infrastructures - whether cloud-based or earth-bound. Even small applications need to process, manage, and digest large quantities of data, either as files, objects, or items in a database. So it's not surprising that all the major cloud platforms provide multiple data management solutions.

This course, designed and produced by our expert Linux System Administrator David Clinton, offers a great overview of the data solutions available from Google. You will see Google's two managed DBMS, its Object Storage service, and BigQuery - the Big Data service into which Google poured its years of experience performing analytics and queries on massive datasets.

Who should take this course

"Data Management on Google Cloud Platform" is a beginner level course, so it's available without any special prerequisites. Nevertheless, you might benefit by first going through our "Introduction to Google Cloud Platform" course for a more general view of the whole GCP family. Also, some experience with the Linux CLI might be helpful for those videos that include terminal operations.

After this course, you might want to try "Getting Started with Google Compute Engine",to round out your GCP knowledge. And after that, check out our Google quiz questions: Test yourself and increase your understanding at the same time thanks to our exclusive learning technology.

 

Transcript

Hi, and welcome to cloudacademy.com's video series on Google Cloud platform data management. In this video we'll learn how to work with Google Cloud SQL, how to create a Google Cloud SQL instance, how to connect with it from within a local MySQL shell and how to manipulate its environment and data sets.

What is Google Cloud SQL

Cloud SQL by the way is actually a relational database management system built to be largely compatible with the widely used open source package MySQL, but first I should point out that not all MySQL statements are currently supported in Google Cloud SQL. For instance low data in-file won't work, although low data local in-file is supported, select into either out-file or dump-file won't work, install or uninstall plugin, create function, load file and grant all privileges all won't work right now in Cloud SQL.

Create a Google Cloud SQL instance 

Now for our purposes will assume that a client instance with MySQL up and running already exist, now let's create a Google Cloud SQL instance from the Google developers console. We'll click on Storage and Cloud SQL, we'll create an instance, we'll call it "my instance" and we'll leave it in the United States region and Tier D1-512 Megabyte of RAM. For the amount of time we're going to have this running that won't make any difference one way or the other.

We're running, let's click on SQL instance and move immediately to Access Control. Let's set a root password, click on Set, that's done. Of course, we also have to remember the root password, let us also add an authorized network.

For this we'll need the IP address the public IP address of our client instance, that's the address we've been given let's add that. Finally, let's request an IP address for our SQL instance, we have that it's 173.194.84.207 we'll remember that or save it for later. Now we're in our client instance and we're ready to login to the Cloud SQL instance from the clients. We run my SQL but we pointed to host 173.194.84.207 which is the external IP of our Google Cloud SQL instance, we'll login as root and we'll be prompted for a password.

I'll enter the password and we're in, well let's see what we can do. Let's try selecting user, host and password from mysql.user. There's a root user and nothing else, so let's create a new user. Let's create user "testuser" to be identified by the password. Actually that was a double quote and it should actually been only single quote. Syntax really makes a difference in MySQL, let's see how that goes. Seems to be successful, let's once again select all our users and we now have a test user.

How to create a Google Cloud SQL table

Now just to show that Google Cloud SQL can do just about anything that most other SQL environments can do it just remotely, let's create a database called "gooddata", let's select use "gooddata." Now let's create a table within "gooddata" called Names.

One column will be ID it'll be an integer, one column will be "LastName" and one column will be "FirstName" and close parenthesis and semicolon. We're done, we created a database. Obviously just about anything else you can do in SQL except for those exceptions that we mentioned at the beginning of the video, you can do pretty much just as easily remotely and with very safe and secure online storage using Google Cloud SQL.

About the Author
Avatar
David Clinton
Linux SysAdmin
Students
11905
Courses
12
Learning Paths
4

David taught high school for twenty years, worked as a Linux system administrator for five years, and has been writing since he could hold a crayon between his fingers. His childhood bedroom wall has since been repainted.

Having worked directly with all kinds of technology, David derives great pleasure from completing projects that draw on as many tools from his toolkit as possible.

Besides being a Linux system administrator with a strong focus on virtualization and security tools, David writes technical documentation and user guides, and creates technology training videos.

His favorite technology tool is the one that should be just about ready for release tomorrow. Or Thursday.