Google Cloud/MySQL - Revision history

Admin: /* Connect to MySQL Compute Instance */

2017-10-24T07:37:12Z

Connect to MySQL Compute Instance

← Older revision		Revision as of 07:37, 24 October 2017
Line 83:		Line 83:

	There are multiple ways to do this:		There are multiple ways to do this:
	* ~~Use~~ the ~~web console to~~ get a shell on the ~~cloud instance using~~ the ~~little cloud shell icon, then use the <code>gcloud sql</code> command~~		* 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 from a MySQL client instance by setting the proper connection parameters		* 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)		How to connect to a remote MySQL server: [[MySQL#Get_a_remote_MySQL_shell]] (basically, just specify --host and --port arguments)

	~~Link to Cloud SQL for MySQL that mentions the web console method: https://cloud.google.com/sql/docs/mysql/quickstart~~

	Now, can perform actions like creating a database, inserting sample data, etc.		Now, can perform actions like creating a database, inserting sample data, etc.
Line 105:		Line 103:
	</pre>		</pre>

	Basic operations like configuring users [https://cloud.google.com/sql/docs/mysql/create-manage-users] and creating databases [https://cloud.google.com/sql/docs/mysql/create-manage-databases] can be done using the standard MySQL client~~, or the web console~~.		Basic operations like configuring users [https://cloud.google.com/sql/docs/mysql/create-manage-users] and creating databases [https://cloud.google.com/sql/docs/mysql/create-manage-databases] can be done using the standard MySQL client.

	===Connecting to MySQL Compute Instance from External Application===		===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.		Can also connect to MySQL compute instance from an external application like JDBC (Java), Go, Docker, or a secure SSL proxy.

	~~Link with list of external applications~~: https://cloud.google.com/sql/docs/mysql/~~external-connection~~-~~methods~~		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

	~~Link with info about SSL proxy for secure connections~~ to ~~compute instances (need proxy server running on both client and server~~)~~: https://cloud.google.com/sql/docs/mysql/sql-proxy~~		(NOTE: Not trivial to carry out successfully!)

	===Configuring Default User===		===Configuring Default User===

	~~The one operation that is not performed using a standard MySQL client or standard MySQL commands is configuring~~ the default user account~~. This is required before you can connect to the instance~~. By default, the default user is root.		Configure the default user account. By default, the default user is root.

	~~To configure the default user, can use the <code>gcloud sql</code> command:~~

	~~<pre>~~
	~~$ gcloud sql users set-password root % \~~
	~~--instance dummy --password YOUR-SECRET-PASSWORD-HERE~~
	~~</pre>~~

	==Delete MySQL Compute Instance==		==Delete MySQL Compute Instance==

Admin: /* Managing MySQL Compute Instance */

2017-10-24T07:33:54Z

Managing MySQL Compute Instance

← Older revision		Revision as of 07:33, 24 October 2017
Line 77:		Line 77:

	Link to container engine documentation: https://cloud.google.com/container-engine/docs/		Link to container engine documentation: https://cloud.google.com/container-engine/docs/

	~~==Managing MySQL Compute Instance==~~

	~~The gcloud command line tool can be used to manage yer cloud SQL databases.~~

	==Connect to MySQL Compute Instance==		==Connect to MySQL Compute Instance==

Admin: /* Managing MySQL Compute Instance */

2017-10-24T07:33:46Z

Managing MySQL Compute Instance

← Older revision		Revision as of 07:33, 24 October 2017
Line 81:		Line 81:

	The gcloud command line tool can be used to manage yer cloud SQL databases.		The gcloud command line tool can be used to manage yer cloud SQL databases.

	~~SQL-specific commands are accessed by executing the <code>gcloud sql</code> command.~~

	~~Some things you can do:~~
	* Manage specific databases
	* Back up databases
	* Perform Cloud SQL operations
	* Connect to Cloud SQL instances

	~~Link to gcloud sql command documentation: https://cloud.google.com/sdk/gcloud/reference/sql/~~

	==Connect to MySQL Compute Instance==		==Connect to MySQL Compute Instance==

Admin: /* Manually Allocate Instance and Install MySQL */

2017-10-24T07:32:32Z

Manually Allocate Instance and Install MySQL

← Older revision		Revision as of 07:32, 24 October 2017
Line 24:		Line 24:

	<pre>		<pre>
	$ gcloud config set compute//zone ~~the~~-~~zone~~		$ gcloud config set compute --zone us-west1
	</pre>		</pre>

Admin: /* Delete MySQL Compute Instance */

2017-10-24T07:31:42Z

Delete MySQL Compute Instance

← Older revision		Revision as of 07:31, 24 October 2017
Line 145:		Line 145:

	<pre>		<pre>
	$ gcloud compute instances delete dummy --zone ~~the~~-~~zone~~		$ gcloud compute instances delete dummy --zone us-west1
	</pre>		</pre>

Admin: /* Connect to MySQL Compute Instance */

2017-10-24T07:30:55Z

Connect to MySQL Compute Instance

← Older revision		Revision as of 07:30, 24 October 2017
Line 96:		Line 96:
	Once you've created the MySQL compute instance, you have a MySQL server running, and you can connect to the server using MySQL clients.		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:		There are multiple ways to do this:
	* Use the web console to get a shell on the cloud instance using the little cloud shell icon, then use the <code>gcloud sql</code> command		* Use the web console to get a shell on the cloud instance using the little cloud shell icon, then use the <code>gcloud sql</code> command
	* Connect to the MySQL server instance from a MySQL client instance by setting the proper connection parameters		* Connect to the MySQL server instance from a MySQL client instance by setting the proper connection parameters

Admin at 23:24, 12 September 2017

2017-09-12T23:24:25Z

← Older revision		Revision as of 23:24, 12 September 2017
Line 154:		Line 154:
	[[Category:SQL]]		[[Category:SQL]]
	[[Category:MySQL]]		[[Category:MySQL]]
			[[Category:Databases]]

Admin at 23:24, 12 September 2017

2017-09-12T23:24:10Z

← Older revision		Revision as of 23:24, 12 September 2017
Line 152:		Line 152:

	[[Category:Google Cloud]]		[[Category:Google Cloud]]
			[[Category:SQL]]
			[[Category:MySQL]]

Admin: /* Use Container */

2017-09-12T01:11:50Z

Use Container

← Older revision		Revision as of 01:11, 12 September 2017
Line 72:		Line 72:
	===Use Container===		===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: https://cloud.google.com/container-engine/		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/

	==Managing MySQL Compute Instance==		==Managing MySQL Compute Instance==

Admin: /* Create MySQL Compute Instance */

2017-09-12T01:10:42Z

Create MySQL Compute Instance

← Older revision		Revision as of 01:10, 12 September 2017
Line 12:		Line 12:

	==Create MySQL Compute Instance==		==Create MySQL Compute Instance==

			===Manually Allocate Instance and Install MySQL===

	Start by setting up project:		Start by setting up project:
Line 47:		Line 49:

	When you run the installation process, you will be prompted to set a root password.		When you run the installation process, you will be prompted to set a root password.

	~~(I suppose you could also use a [[Docker]] or [[Kubernetes]] image and run that in the cloud - but not sure exactly how that process would mesh with Google Cloud.)~~

	Secure the installation using the MySQL command <code>mysql_secure_installation</code>:		Secure the installation using the MySQL command <code>mysql_secure_installation</code>:
Line 70:		Line 70:
	</pre>		</pre>

			===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: https://cloud.google.com/container-engine/

	==Managing MySQL Compute Instance==		==Managing MySQL Compute Instance==