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:
- MySQL Client
- Third-party tools like SQL Workbench or Toad for MySQL
- External applications using standard MySQL database drivers
- App Engine Java applications
- App Engine Python applications
- Google Apps Script scripts
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.
-
Note:
-
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 theLOAD 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 .