Please note that the contents of this offline web site may be out of date. To access the most recent documentation visit the online version .
Note that links that point to online resources are green in color and will open in a new window.
We would love it if you could give us feedback about this material by filling this form (You have to be online to fill it)



About Google Cloud SQL

This document introduces Google Cloud SQL.

Contents

Overview

Google Cloud SQL is a MySQL database that lives in Google's cloud. It has all the capabilities and functionality of MySQL, with a few additional features and a few unsupported features as listed below. Google Cloud SQL is easy to use, doesn't require any software installation or maintenance, and is ideal for small to medium-sized applications.

You can connect to a Google Cloud SQL instance from:

Features and Restrictions

Google Cloud SQL is currently available for Google App Engine applications that are written in Java, Python, PHP, and Go. You can also access Google Cloud SQL using MySQL Client, and other administration and reporting tools that work with MySQL databases.

Features

  • Ability to host your MySQL 5.5 and 5.6 databases in the cloud
  • All data replicated across multiple zones for greater availability and durability
  • Choice of billing options:
    • Per use option means you only pay for the time you access your data
    • Package option allows you to control your costs for more frequent access
  • Google Cloud SQL instances can have up to 16GB of RAM and 500GB data storage
  • Create and manage instances in the Google Developers Console
  • Instances available in US, EU, or Asia
  • Cloud SQL customer data is encrypted when on Google’s internal networks and when stored in database tables and temporary files (with encryption of backups coming soon)
  • Synchronous or asynchronous replication between multiple zones with automatic failover
  • Import or export databases using mysqldump
  • Java and Python compatibility
  • Support for MySQL wire protocol and MySQL connectors
  • Support for connecting with the Secure Sockets Layer (SSL) protocol
  • Automated backups and point-in-time recovery
  • ISO/IEC 27001 compliant

Restrictions

  • Size limit for individual instances is 500GB
  • User defined functions are not supported
  • The following MySQL statements are not supported:
    • LOAD DATA INFILE
      • Note: LOAD DATA LOCAL INFILE is supported.
    • SELECT ... INTO OUTFILE/DUMPFILE
    • INSTALL/UNINSTALL PLUGIN ...
    • CREATE FUNCTION ...
    • LOAD_FILE()
  • The SUPER privilege is not supported.
  • The following MySQL functions are not supported:
    • SHA2()
  • The following MySQL Client Programs are not supported:
    • mysqlimport without using the --local option. This is due to the LOAD DATA INFILE restriction. If you need to load data remotely, use the Cloud SQL import function .

Usage Policies

The use of this service must adhere to the Google Cloud SQL Terms of Service and Acceptable Use Policy , as well as Google's Privacy Policy .

Pricing

Two pricing plans are available: Packages and Per Use . For details, see Pricing .

Authentication required

You need to be signed in with Google+ to do that.

Signing you in...

Google Developers needs your permission to do that.