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
- LOAD DATA INFILE
- SELECT … INTO OUTFILE / DUMPFILE
- INSTALL / UNINSTALL PLUGIN
- CREATE FUNCTION … SONAME …
- 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