Google Cloud SQL Tutorial

Instance Management

1. Create SQL Instance and Connect via SSMS
2. Start, Stop, Restart SQL Instances in GCP
3. Edit SQL Instance Settings in GCP

Backup, Recovery & Upgrades

1. Backup Strategies and Limitations
2. Enable Point in Time Recovery in MySQL
3. Upgrade SQL Server Editions
4. In-place PostgreSQL Upgrade (v12 to v14)

High Availability & Replication

1. Setup HA and Failover for SQL Server
2. Create MySQL 8.0 with HA
3. Create SQL Server Read Replicas
4. MySQL Read Replicas & Promotion

Connectivity & Access

1. Clone SQL Instances
2. Connect PostgreSQL with Private IP
3. Connect MySQL via Private IP
4. Connect SQL Server via Private IP
5. Install PostgreSQL 14.5 on Windows
6. Install psql CLI for PostgreSQL

Performance & Logs

1. Enable Slow and General Logging in MySQL
2. Stop Logging Clear Text Passwords in PostgreSQL

Scheduling & Maintenance

1. Automate SQL Start/Stop with Cloud Scheduler
2. Schedule PostgreSQL Maintenance with pg_cron

Migration & Security

1. Migrate SQL Server to GCP using BAK
2. Drop User or Role in PostgreSQL
3. Fix SQL Server Error 53

Advanced Features

1. Cross DB Queries in PostgreSQL (GCP)
2. Cross DB Queries between Google SQL PostgreSQL Instances
3. CDC from MySQL to BigQuery via DataStream