SQL

1. Overview

  • A transactional database that supports clients such as CloudTrail, App Engine and G Suite Scripts.
  • Patches and updates are automatically applied by Google to MySQL, PostgreSQL and MSSQL databases.
  • A fully managed MySQL, PostgreSQL and MSSQL database service.
  • Supports applications and tools such as Toad, and other external applications using Standard transactional database drivers.
  • A transactional database capable of handling up to terabytes of storage.
  • Suitable for those who need full SQL support.
  • Instances include firewall rules.
  • Supports MySQL and PostgreSQL databases services.
  • Provides terabytes of transactional database capacity.
  • Ideal for storing transaction data from online web applications
  • Provides replica services for relational databases.
  • Backups data either on-demand or on a scheduled basis.
  • Offers a choice MySQL, PostgreSQL and MSSQL database engines as a fully managed service.
  • Can scale vertically by changing the machine type, and horizontally via read replicas.
  • Can replicate transactional data between zones for failover.
  • Customer data is stored in transactional database tables.
  • A managed service for open source transactional databases.
  • Supports open source relational database.
  • A structured relational data storage service based on open source technologies.
  • Supports InnoDB as the storage engine.
  • Cloud SQL does not support user-defined functions.
  • Supports on demand activation policy.
  • Provides on-demand backups with point in time recovery.
  • Enables databases to be imported and exported to CSV files.
  • Cloud SQL can scale up with a machine restart
  • Can scale out using read replicas.
  • Can be granted access through IP address authorisation.
  • Supports connections over both IPv4 and IPv6 addresses
  • MySQL functionality is similar to functionality provided by a locally hosted Instance.
  • Cloud SQL replica service replicates data between multiple zones with automatic failover.
  • Cloud SQL MySQL databases can be exported using MySQL dump command.
  • For more secure access, users can temporarily whitelist IP addresses.
  • SSL certificate management can be configured to allow Cloud SQL clients to connect using SSL.
  • Cloud SQL enables instance level access from a Compute Engine or Google App Engine instance.
  • Native MySQL access control features can be used to control which MySQL users can access data in a Cloud SQL instance.