Cloud SQL Features Google Professional Data Engineer GCP

  1. Home
  2. Cloud SQL Features Google Professional Data Engineer GCP

Common Features

  • Create and manage instances in the Google Cloud Console in US, EU, Asia or Australia.
  • Cloud SQL instances run on top of managed Compute Engine VMs whose type affects performance
  • Customer data encrypted on Google’s internal networks and in database tables, temporary files, and backups.
  • Access by
    • direct connection, needs whitelisting
    • proxy, whitelisting not needed
    • private access
  • Support for secure external connections with the Cloud SQL Proxy or with the SSL/TLS protocol.
  • Read replica can only be in same region
  • Cloud SQL data is stored within the same region that the instance is hosted in.
  • For data availability, backups are stored in two separate regions
  • Binary logging needed for point in time restore, failover replication
  • Data replication between multiple zones with automatic failover.
  • Automated and on-demand backups, and point-in-time recovery.
  • Instance cloning.
  • Connections to Cloud SQL can be established either by using traditional IP whitelisting or by the Cloud SQL Proxy
  • With Cloud SQL Proxy clients can connect to Cloud SQL instances over an encrypted TCP tunnel, without needing authorized networks /SSL certificates,


MySQL Features

  • Fully managed MySQL Community Edition databases in the cloud.
  • Second Generation instances support MySQL 5.6 or 5.7, and provide up to 416 GB of RAM and 30 TB of data storage, with the option to automatically increase the storage size as needed.
  • First Generation instances support MySQL 5.5 or 5.6, and provide up to 16 GB of RAM and 500 GB of data storage.
  • Support for private IP (private services access).
  • Import and export databases using mysqldump, or import and export CSV files.
  • Support for MySQL wire protocol and standard MySQL connectors.
  • Does not supports
    • CREATE TABLE … SELECT statements
    • CREATE TEMPORARY TABLE statements inside transactions
    • Transactions or statements that update both transactional and nontransactional tables
    • LOAD_FILE() function
    • client program features – mysqlimport, mysqldump


PostgreSQL Features

  • Fully managed PostgreSQL databases in the cloud, based on the Cloud SQL Second Generation platform.
  • Custom machine types with up to 416 GB of RAM and 64 CPUs.
  • Up to 30 TB of storage available, with automatic storage size increase
  • Support for PostgreSQL client-server protocol and standard PostgreSQL connectors.
  • Support for multiple PostgreSQL versions.
  • Not supported
    • Point-in-time recovery (PITR)
    • Import/export in CSV format using Cloud Console or the gcloud command-line tool.
    • Low-Level Virtual Machine (LLVM) Just-in-Time (JIT) compilation
    • Logical replication

SQL Server Features

  • Fully managed SQL Server databases in the cloud.
  • Custom machine types with up to 416 GB of RAM and 64 CPUs.
  • Up to 30 TB of storage available, with automatic storage size increase
  • Import databases using native BAK and SQL files.
  • Export databases using native BAK files.
  • SQL Server Agent enabled to facilitate replication and other jobs.
  • Not supported
    • SSRS, SSAS, SSIS, MSDTC, Data Quality Services
    • AD Authentication
    • SP_Configure settings
    • BULK INSERT and OPENROWSET(BULK…) features
    • Resource Governor, SQL Server Audit, Server-level triggers