{"results":[{"id":"cloudsql-auth-proxy-recommended-connection","text":"Cloud SQL Auth Proxy is the recommended secure connection method for applications connecting to Cloud SQL instances.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-backup-restore-operationally-seamless","text":"Cloud SQL backups provide seamless disaster recovery with indefinite retention for on-demand backups and consistent connection strings after failover.","truth_value":"OUT","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-backups-encrypted-by-default","text":"Cloud SQL backups are encrypted by default using Google-managed or Customer-Managed Encryption Keys (CMEK).","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-backups-incremental-after-first","text":"All Cloud SQL backups after the first are incremental; when the oldest backup is deleted, the next oldest expands into a full backup.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-cascading-replicas-4-levels-8-siblings","text":"Cascading replicas support up to 4 levels in the hierarchy (including primary) and up to 8 siblings per parent.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-deleted-instance-recovery-4-days","text":"Cloud SQL retains deleted instance backups for 4 days; Customer Care can restore with original IP address.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-disaster-recovery-complete","text":"Cloud SQL provides complete disaster recovery coverage with incremental backups, indefinite on-demand backup retention, 4-day deleted instance recovery by Customer Care, and same-IP failover for HA instances.","truth_value":"OUT","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-enhanced-backups-use-backup-dr-service","text":"Enhanced backups use Backup and DR Service for centralized management; standard backups are stored in the same project as the instance.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-enterprise-plus-sub-second-maintenance","text":"Cloud SQL Enterprise Plus edition supports sub-second downtime during maintenance (for MySQL and PostgreSQL).","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-final-backup-default-retention-30-days","text":"Cloud SQL final backup default retention is 30 days; customizable 1–365 days (standard) or 1 day–10 years (enhanced).","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-ha-costs-double","text":"Cloud SQL HA instances cost 2x a standalone instance (CPU, RAM, and storage).","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-ha-doubles-cost-with-idle-standby","text":"Cloud SQL HA doubles infrastructure cost for automatic failover but the standby instance is idle — it cannot serve read queries, making read replicas in a third zone necessary for both read scaling and maximum resilience.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-ha-failover-60-seconds","text":"Cloud SQL HA failover takes approximately 60 seconds of downtime.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-ha-primary-destroyed-on-failover","text":"After Cloud SQL HA failover, the original primary is destroyed and recreated as the new standby.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-ha-read-replicas-third-zone-best-practice","text":"Best practice is to place Cloud SQL read replicas in a third zone, different from both the primary and standby zones.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-ha-replicas-complementary-not-alternative","text":"Cloud SQL HA and read replicas are complementary, not interchangeable: HA doubles cost with an idle standby for automatic failover, while replicas are strictly read-only without failover capability or independent backups — achieving both availability and read scaling requires deploying both patterns, ideally with replicas in a third zone.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-ha-same-ip-after-failover","text":"Cloud SQL HA uses a shared static IP; applications reconnect using the same IP/connection string after failover.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-ha-standby-different-zone-same-region","text":"Cloud SQL HA uses a standby VM in a different zone within the same region (not a different region).","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-ha-standby-no-read-queries","text":"The Cloud SQL HA standby instance cannot serve read queries.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null},{"id":"cloudsql-ha-synchronous-replication","text":"Cloud SQL HA uses synchronous replication to regional persistent disk, not asynchronous replication.","truth_value":"IN","justification_count":0,"dependent_count":0,"challenges":[],"last_reviewed":null,"review_result":null}],"count":50,"limit":20,"offset":0}