Google Cloud/MySQL
From charlesreid1
To set up MySQL on Google Cloud, create a new project using the Google Cloud Platform Console.
Link to google cloud platform console: https://console.cloud.google.com/project
Contents
Setting up Google Cloud SDK
This uses the gcloud command line tool (see Google Cloud/Gcloud). This tool uses the Compute Engine API, so you have to enable that first. Also, need to install Google Cloud SDK (which installs the gcloud tool). There are also client libraries that allow you to write scripts in various languages.
Link to enabling compute engine API: https://console.cloud.google.com/flows/enableapi?apiid=compute_component
Link to google cloud sdk: https://cloud.google.com/sdk/docs/
Create MySQL Compute Instance
Manually Allocate Instance and Install MySQL
Start by setting up project:
$ gcloud config set project project-name
Set up compute zone:
$ gcloud config set compute --zone us-west1
Now to set up a MySQL server, create a compute instance. This sets up a plain, empty Debian VM that you can SSH to and install MySQL onto. Other operating systems are available too.
Create the instance:
$ gcloud instances create dummy
SSH to the instance:
$ gcloud compute ssh dummy
Install MySQL on the compute instance:
$ sudo apt-get update $ sudo apt-get -y install mysql-server
When you run the installation process, you will be prompted to set a root password.
Secure the installation using the MySQL command mysql_secure_installation
:
$ sudo mysql_secure_installation
Connect to the server:
$ mysql --user=root --password
To do a "hello world" with MySQL, run the commands:
mysql> show processlist; mysql> SELECT User, Host, Password FROM mysql.user;
Use Container
The other option here, which I suppose would bypass all of the Cloud SQL stuff, is to just use a Docker container and set up the SQL server yourself. This would use the Container Engine product instead.
Link to info about container engine: https://cloud.google.com/container-engine/
Link to container engine documentation: https://cloud.google.com/container-engine/docs/
Connect to MySQL Compute Instance
Once you've created the MySQL compute instance, you have a MySQL server running, and you can connect to the server using MySQL clients.
There are multiple ways to do this:
- Log into Google Cloud console, find the compute engine instance, and get a shell on the machine via the browser
- Connect to the MySQL server instance (in the cloud) from a MySQL client instance (on your local machine) by setting the proper connection parameters
How to connect to a remote MySQL server: MySQL#Get_a_remote_MySQL_shell (basically, just specify --host and --port arguments)
Now, can perform actions like creating a database, inserting sample data, etc.
mysql> CREATE DATABASE guestbook; mysql> USE guestbook; mysql> CREATE TABLE entries (guestName VARCHAR(255), content VARCHAR(255), entryID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(entryID)); INSERT INTO entries (guestName, content) values ("first guest", "First!"); INSERT INTO entries (guestName, content) values ("second guest", "What a jerk."); mysql> SELECT * FROM entries;
Basic operations like configuring users [1] and creating databases [2] can be done using the standard MySQL client.
Connecting to MySQL Compute Instance from External Application
Can also connect to MySQL compute instance from an external application like JDBC (Java), Go, Docker, or a secure SSL proxy.
To connect via a secure SSL proxy, the client machine and server machine must both be running Cloud Proxy: https://cloud.google.com/sql/docs/mysql/sql-proxy
(NOTE: Not trivial to carry out successfully!)
Configuring Default User
Configure the default user account. By default, the default user is root.
Delete MySQL Compute Instance
Once you're finished with the MySQL server you'll want to delete the VM that was allocated. I am unable to find a way to do this using the gcloud interface.
$ gcloud compute instances delete dummy --zone us-west1
Link to gcloud documentation that mentions this command: https://cloud.google.com/compute/docs/gcloud-compute/