New Post has been published on OneClickz
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;
Sources : Google Cloud SQL
