#google cloud sql

Taking your on-premises SQL Server databases to the cloud opens a world of benefits such as scalability, flexibility, and often, reduced costs. However, the journey requires meticulous planning and execution. We will delve into the migration process to three of the most sought-after cloud platforms: Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP), providing you with…

今回はGoogle Cloud SQLを作成してみましょう。データベースのマネージドサービスで、AWSでいうRDS/Auroraが相当します。GoogleのマネージドDBのGoogle Cloud SQLはIPベースでのホワイトリスト化で接続できます。しかし、少し手間にはなりますが認証キーによるAPIで接続するのが推奨されています、理由としてはオートスケールなどを考えるとスマートになるのですね。     Google Cloud SQLを作成しよう！ サイドバーから【SQL】を選んでね。   【インスタンスを作成】をクリックするよ。       MySQLを選択するよ。PostgreSQLはベータの品質だから、本番利用では気をつけてね。     もちろん、【第2世代を選択】をクリックしよう。過去は振り返らないよ。   インスタンスIDに任意の名前を。パスワードは好きなものを設定してね。…

New Post has been published on http://www.oneclickz.net/google-cloud-sql-getting-started/

Google Cloud SQL Getting Started

Google Cloud SQL: Relational Databases in Google’s Cloud

Fully managed, highly available relational databases. Create, configure, and use MySQL databases that live in Google’s Cloud. We manage replication, encryption, patch management, and backups, so you focus on your applications and services.

Easy to use, flexible configuration. Create, configure, manage, and monitor your database instances with just a couple of clicks in our console or using a command line tool. Manage your instances using any applications and tools you already use with MySQL.

Exceptional security and integration with Google Cloud. All data is encrypted when stored and in flight on Google’s network. Connections to instances are accepted only from authorized IP addresses, and can be secured with SSL, and MySQL user grants can control access at the database, table, or even column level. All data is replicated multiple times in multiple locations for great durability and availability.

Cloud SQL is tightly integrated with Google App Engine, Compute Engine, Cloud Storage, and other Google services, so you can work across multiple products easily, get more value from your data, move your data into and out of the cloud, and get better performance.

Learn More

Try it now

Sign up

If you don’t already have one, sign up for a Google account.

Create a Cloud SQL enabled project via the Google Developers Console.

Enable billing from your project’s Settings tab.

Create and configure a Google Cloud SQL instance

From your project’s overview page, select Cloud SQL, and click NEW INSTANCE.

Enter a name for the instance and click Confirm.

Once the instance is running, click Access Control and then:

Click Request an IP Address and use this as your instance-IP in Step 3.

In the Set Root Password box, enter a root password, and click Set.

Click Add Authorized Network and add your IP address.

Connect to the instance

Install the MySQL Client.

Connect to the instance.

$ mysql --host=instance-IP --user=root --password

Create a database and table, enter some data, and query the data.

CREATE DATABASE guestbook; USE guestbook; 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", "hello world!"); SELECT * FROM entries;

New Post has been published on http://www.oneclickz.net/google-cloud-sql-getting-started/

Google Cloud SQL Getting Started

Google Cloud SQL: Relational Databases in Google’s Cloud

Fully managed, highly available relational databases. Create, configure, and use MySQL databases that live in Google’s Cloud. We manage replication, encryption, patch management, and backups, so you focus on your applications and services.

Easy to use, flexible configuration. Create, configure, manage, and monitor your database instances with just a couple of clicks in our console or using a command line tool. Manage your instances using any applications and tools you already use with MySQL.

Exceptional security and integration with Google Cloud. All data is encrypted when stored and in flight on Google’s network. Connections to instances are accepted only from authorized IP addresses, and can be secured with SSL, and MySQL user grants can control access at the database, table, or even column level. All data is replicated multiple times in multiple locations for great durability and availability.

Cloud SQL is tightly integrated with Google App Engine, Compute Engine, Cloud Storage, and other Google services, so you can work across multiple products easily, get more value from your data, move your data into and out of the cloud, and get better performance.

Learn More

Try it now

Sign up

If you don’t already have one, sign up for a Google account.

Create a Cloud SQL enabled project via the Google Developers Console.

Enable billing from your project’s Settings tab.

Create and configure a Google Cloud SQL instance

From your project’s overview page, select Cloud SQL, and click NEW INSTANCE.

Enter a name for the instance and click Confirm.

Once the instance is running, click Access Control and then:

Click Request an IP Address and use this as your instance-IP in Step 3.

In the Set Root Password box, enter a root password, and click Set.

Click Add Authorized Network and add your IP address.

Connect to the instance

Install the MySQL Client.

Connect to the instance.

$ mysql --host=instance-IP --user=root --password

Create a database and table, enter some data, and query the data.

CREATE DATABASE guestbook; USE guestbook; 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", "hello world!"); SELECT * FROM entries;

New Post has been published on http://www.oneclickz.net/google-cloud-sql-getting-started/

Google Cloud SQL Getting Started

Google Cloud SQL: Relational Databases in Google’s Cloud

Fully managed, highly available relational databases. Create, configure, and use MySQL databases that live in Google’s Cloud. We manage replication, encryption, patch management, and backups, so you focus on your applications and services.

Easy to use, flexible configuration. Create, configure, manage, and monitor your database instances with just a couple of clicks in our console or using a command line tool. Manage your instances using any applications and tools you already use with MySQL.

Exceptional security and integration with Google Cloud. All data is encrypted when stored and in flight on Google’s network. Connections to instances are accepted only from authorized IP addresses, and can be secured with SSL, and MySQL user grants can control access at the database, table, or even column level. All data is replicated multiple times in multiple locations for great durability and availability.

Cloud SQL is tightly integrated with Google App Engine, Compute Engine, Cloud Storage, and other Google services, so you can work across multiple products easily, get more value from your data, move your data into and out of the cloud, and get better performance.

Learn More

Try it now

Sign up

If you don’t already have one, sign up for a Google account.

Create a Cloud SQL enabled project via the Google Developers Console.

Enable billing from your project’s Settings tab.

Create and configure a Google Cloud SQL instance

From your project’s overview page, select Cloud SQL, and click NEW INSTANCE.

Enter a name for the instance and click Confirm.

Once the instance is running, click Access Control and then:

Click Request an IP Address and use this as your instance-IP in Step 3.

In the Set Root Password box, enter a root password, and click Set.

Click Add Authorized Network and add your IP address.

Connect to the instance

Install the MySQL Client.

Connect to the instance.

$ mysql --host=instance-IP --user=root --password

Create a database and table, enter some data, and query the data.

CREATE DATABASE guestbook; USE guestbook; 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", "hello world!"); SELECT * FROM entries;

Google Cloud SQL Getting Started

Google Cloud SQL: Relational Databases in Google’s Cloud

Fully managed, highly available relational databases. Create, configure, and use MySQL databases that live in Google’s Cloud. We manage replication, encryption, patch management, and backups, so you focus on your applications and services.

Easy to use, flexible configuration. Create, configure, manage, and monitor your database…

Google Cloud SQL is a new service which runs mySQL databases in Google's cloud. You can try out this service without charge until June 2013 under a introductory trial.

Usually, you would need a database if you develop applications with the Google App Engine platform. Of course, there should be a possibility to connect Cloud SQL from external applications. This is possible with the command line tool and via JDBC. Here comes the next use case for our QlikView JDBC Connector.

To connect Google Cloud SQL you need to create OAuth 2.0 tokens to authorize applications to connect to your instance on your behalf. This can be done by using the command line tool (section Setup).

After following the command line tool setup steps the OAuth 2.0 tokens are created and stores in Windows registry under the key:

HKCU\Software\JavaSoft\Prefs\com.google.cloud.sqlservice

You need to copy this entries for the user who will be running the application on the deployment machine.

In the next step we configure the Google Cloud SQL JDBC driver in the connector:

Now we can start connecting Cloud SQL in QlikView. Just open the script editor choose JDBC Connector and click connect. Enter the JDBC connect string:

jdbc:google:rdbms://<your_instance_name>/<your_database_name>? connector.driverClass=com.google.cloud.sql.Driver;

Leave the user/password properties free.

Now we can select the objects from an example mySQL schema I've created before with the Google API Console SQL Prompt. Use the dialog as usual to build your SELECT statements to load the data into QlikView: