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
You can use Google Cloud SQL for Google App Engine applications that are written in Java, Python, PHP, and Go, and with external applications using the standard MySQL protocol. You can also access Google Cloud SQL using MySQL Client and other administration and reporting tools that work with MySQL databases.
- 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, temporary files, and backups
- Synchronous or asynchronous replication between multiple zones with automatic failover
- Import and export databases using mysqldump, or import and export CSV files.
- Java and Python compatibility
- Support for MySQL wire protocol and MySQL connectors
- Support for connections over IPv4 and IPv6
- Support for connecting with the Secure Sockets Layer (SSL) protocol
- Automated backups and point-in-time recovery
- ISO/IEC 27001 compliant
- Size limit for individual instances is 500GB
- User defined functions are not supported
- The following MySQL statements are not supported:
LOAD DATA INFILE
LOAD DATA LOCAL INFILEis supported.
SELECT ... INTO OUTFILE/DUMPFILE
INSTALL/UNINSTALL PLUGIN ...
CREATE FUNCTION ...
SUPERprivilege is not supported.
- The following MySQL Client Program features are not supported:
mysqlimportwithout using the
--localoption. This is due to the
LOAD DATA INFILErestriction. If you need to load data remotely, use the Cloud SQL import function.
--taboption or options that are used with
--tab. This is because the FILE privilege is not granted for instance users. All other mysqlimport options are supported.