This document introduces Google Cloud SQL.
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.
- Ability to host your MySQL 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
- 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
- Size limit for individual instances is 500GB
- User defined functions are not supported
- The following MySQL statements are not supported:
LOAD DATA INFILE
SELECT ... INTO OUTFILE/DUMPFILE
INSTALL/UNINSTALL PLUGIN ...
CREATE FUNCTION ...
SUPERprivilege is not supported.
- The following MySQL functions are not supported: