What's changed: Created Professional Cloud Database Engineer Chapter 4 (Domain 4 "Deploy HA": provisioning and testing = HA provisioning/IaC automation/failover drills/Cloud Monitoring; multi-regional replication and read replicas = regional resilience/read-write separation/continuous replication-lag monitoring/Spanner native multi-region).
4.1Provisioning and testing HA databases
Understand provisioning highly available database solutions, testing HA and DR strategies (failover drills), automating instance provisioning, and monitoring highly available databases.
Provision the designed high availability and prove it with tests. Availability is valuable only when failover is verified to work, not merely configured.
4.1.1Provisioning and automation
Provision highly available databases (Cloud SQL HA, Spanner, AlloyDB, etc.). Rather than manual clicks, automate instance provisioning with Infrastructure as Code (Terraform/Infrastructure Manager) for reproducible, consistent setups that deploy across environments. Map "reproducible setup = automate provisioning with IaC."
4.1.2Testing HA/DR and monitoring
Prove HA and DR strategies by testing: run planned failover drills to confirm switchover to standby, RTO/RPO attainment, and app reconnection. In production, monitor HA databases with Cloud Monitoring and alert on replication lag and failover state. Map "verify HA via failover drills, not just config" and "monitor replication lag."
Continue reading — free sign-up
You're reading the free preview. Sign up free to read this section in full, plus every chapter (including 4+) and all questions.