< ciso
brief />
Tag Banner

All news with #cloud sql tag

33 articles

Google Previews Assessments for Cloud SQL for PostgreSQL

🧪 Google Cloud has launched a preview of assessments in Database Center for Cloud SQL for PostgreSQL. The agentic workflow clones a production instance and runs automated synthetic benchmarks in isolation, so teams can measure the effect of a recommended change before applying it. Reports compare throughput, latency, CPU, and memory, and the temporary clone is deleted when the run completes.
read more →

Amazon Aurora DSQL adds per-statement SQL metrics

📊 Amazon Aurora DSQL now records per-statement SQL statistics and publishes them as Amazon CloudWatch OpenTelemetry (OTel) metrics for viewing in Amazon CloudWatch Database Insights. The metrics include execution count, latency, rows scanned, returned or changed, and DPUs consumed, and they measure every successful statement rather than sampling. You can inspect detailed per-call charts under Top SQL, query metrics with PromQL, and enable statistics per cluster via the Aurora DSQL console or API. Standard CloudWatch charges apply and the feature is available in all Regions where Aurora DSQL is offered.
read more →

Use DMS to shrink Cloud SQL for SQL Server disk

🔁 This article explains how Google Cloud's Database Migration Service (DMS) can be used beyond one-time migrations to perform near-zero-downtime disk shrinks for Cloud SQL for SQL Server. It outlines how continuous replication with DMS—initial full backup plus ongoing transaction log application—lets you migrate to a new, right-sized instance while keeping applications online. The post covers monitoring metrics, the DMS shrink workflow, and the manual steps needed to move server-level objects, logins, and jobs to ensure a smooth cutover.
read more →

AlloyDB Omni Web UI Brings Cluster Observability

🛠️ The AlloyDB Omni Web UI is now generally available for Red Hat and container deployments, offering a read-only, production-ready console for cluster visibility. It exposes hardware telemetry, query performance, columnar engine diagnostics, and parameter auditing so administrators can troubleshoot without leaving local or enterprise environments. The interface supports profile management, integrates with Prometheus for system metrics, and surfaces AI and ecosystem shortcuts while operating strictly in read-only mode.
read more →

Cloud SQL Blue‑Green Deployments for Minimal Downtime

🚀 Cloud SQL now offers fully managed blue-green deployments, starting with Cloud SQL for MySQL, to simplify major version upgrades and configuration changes with minimal downtime. By creating a continuously synchronized staging clone (green) of the live instance (blue), teams can test against real production data and perform a fast cutover while retaining the original instance as a fallback. The managed workflow automates cloning, replication, verification, and switchover, reducing upgrade risk and operational overhead.
read more →

Aurora DSQL Adds Partial Index Support

🔍 Amazon Aurora DSQL now supports partial indexes, enabling indexes over a subset of table rows defined by a WHERE clause. This reduces index storage and improves query performance for common working sets, such as active orders amid large historical data. Aurora DSQL will use a partial index when a query's filter is covered by the index condition. The feature is available in all AWS Regions where Aurora DSQL is offered.
read more →

AlloyDB Introduces PostgreSQL for Agentic Workloads

🚀 AlloyDB now offers PostgreSQL for agents (preview), enabling sandboxed, serverless PostgreSQL instances that provide up-to-the-second read-only access to production data while isolating agent workloads. These instances spin up in seconds, leverage Colossus-backed unified storage for sub-millisecond I/O and massive scan throughput, and scale down to zero to control costs. The engine remains fully PostgreSQL-compatible with vector, full-text, and spatial search plus strong Google Cloud security integrations.
read more →

Native BM25 search in AlloyDB and Cloud SQL

📰 This post introduces native BM25 full-text search in AlloyDB and Cloud SQL for PostgreSQL 17+ via the open-source pg_textsearch extension from TigerData. The change eliminates the need for separate full-text backends, reducing data duplication and sync complexity while delivering industry-standard BM25 ranking directly in the database. AlloyDB further offers accelerated vector search (ScaNN, HNSW) and an out-of-the-box hybrid search UDF to merge vector and keyword results; Cloud SQL supports hybrid results via CTEs and coalesced RRF scoring.
read more →

AlloyDB Omni RPM Orchestrator Reaches General Availability

🚀 The AlloyDB Omni Red Hat RPM orchestrator is now generally available alongside AlloyDB Omni v18.3.0, bringing production-ready security, resiliency, and low-downtime operations for PostgreSQL workloads on VMs and bare metal. The release supports four deployment modes, including standalone RPM and RPM orchestrator for HA, and targets regulated, edge, and AI-ready environments. The orchestrator simplifies cluster lifecycle, offers read pools, automated backups to GCS/S3, SELinux support, advanced observability, and Low Downtime Maintenance for enterprise-scale operations.
read more →

Replicating SQL Server Logins to Cloud SQL

🔒 This post explains why Database Migration Service (DMS) does not migrate SQL Server instance-level logins and how to migrate them safely. It outlines the security, compliance, and identity-modernization reasons behind that design decision and shows a practical three-step approach using Microsoft's sp_help_revlogin script. The guide covers generating hashed-password CREATE LOGIN statements, applying them to Cloud SQL, and resolving orphaned users, while recommending migration to Customer-Managed Active Directory where possible.
read more →

Spanner relaxes DML mutation limits for transactions

🛠️ Google Cloud Spanner now allows transactions to include any number of DML statements provided each individual statement produces fewer than 80,000 mutation mods. This change moves the previous 80,000 cumulative transaction-level cap to a per-statement limit, enabling larger, more natural transactions without code changes. Existing client libraries remain compatible, though longer transactions may increase lock contention and aborts, so developers should monitor CommitStats and optimize large operations.
read more →

Automating Dual‑Write Migration to Cloud Spanner

🔧 Google’s Finance Engineering team automated a complex migration from a legacy datastore to Cloud Spanner using Antigravity CLI in headless mode to perform repeatable, multi-file refactoring. They standardized DAO refactoring around a MutationConverter interface, enabling deterministic code generation, automated unit tests, and CI-driven verification. The headless pipeline ran batch conversions, executed tests, and fed failures back into Antigravity for self-correction, dramatically reducing manual effort and ensuring high data fidelity.
read more →

Automating PostgreSQL translations with DMS

🔁 This article explains how Google Cloud's Database Migration Service (DMS) automates translating SQL Server stored procedures that return multiple result sets into PostgreSQL equivalents. It outlines the decision matrix that maps simple single-result procedures to PROCEDURE objects and complex multi-result or mixed-return routines to FUNCTIONs returning SETOF refcursor, and describes the testing and application integration changes required.
read more →

Google Cloud Spanner Graph adds native algorithms

🔍 At Google Cloud Next, Google announced the preview of graph algorithms in Spanner Graph, bringing Google Research’s graph mining capabilities natively to Spanner to deliver faster, cost-effective, large-scale structural analytics. The feature integrates with ISO GQL, runs on dedicated compute to avoid transactional impact, and scales to graphs with tens of billions of edges. Results can be written back to Spanner or exported to Cloud Storage.
read more →

AlloyDB Hot Standby: Faster Failovers and Reliability

🚀 AlloyDB for PostgreSQL introduces a Hot Standby HA architecture that keeps the standby node actively replaying WAL records, reducing failover time and preserving cache warmth. This change eliminates standby database startup delays and minimizes post-failover performance degradation, improving RTO and stabilizing application throughput. Hot Standby is rolling out for PostgreSQL 18 and will reach earlier versions in months, with no extra cost and retention of the 99.99% SLA.
read more →

AI Studio expands database choices and Starter Tier

🛠️ At Google I/O 2026, Google announced expanded integration between AI Studio and Google Cloud, allowing new users to deploy up to two full-stack apps on the Starter Tier without a billing account. Developers can now choose between Firestore (non-relational) and Cloud SQL (relational) with Firebase Auth for unified authentication. The AI agent can infer or provision the appropriate database, provision resources, generate schema and code, and deploy apps directly to Cloud Run for rapid prototyping.
read more →

Urban Outfitters Migrates Sterling OMS to AlloyDB Platform

🚀Urban Outfitters, Inc. (URBN) recently migrated its IBM Sterling OMS from an 11TB Oracle backend to Google Cloud’s AlloyDB for PostgreSQL to reduce TCO and improve scalability and performance. The migration was executed through close collaboration among URBN, IBM, and Google Cloud, with embedded engineering teams driving planning, testing, and tuning. Outcomes included optimized storage and compute, two read replicas for higher availability, significant performance improvements, and a shift toward open standards to future-proof operations.
read more →

Introducing QueryData: Near-100% Accurate Data Agents

🔍 QueryData launches in preview, offering near-100% accuracy translating natural language into database queries across AlloyDB, Cloud SQL (MySQL and PostgreSQL) and Spanner. Built on Google Cloud’s Gemini LLM and augmented by rich database context, it uses schema ontologies, query blueprints and ambiguity detection to generate precise queries. Deterministic security is enforced via Parameterized Secure Views (PSVs), and integration is supported through a unified QueryData API, the MCP Toolbox for Databases, and context-engineering tools including an Evalbench framework.
read more →

ID.me Scales Identity Platform with AlloyDB on Google Cloud

🔒 ID.me moved its identity platform to Google Cloud to handle massive scale and improve AI-driven fraud detection. The team migrated over 50 TB across 15 database instances and adopted a two-tier architecture using AlloyDB for heavy workloads and Cloud SQL for standard services. This reduced provisioning and maintenance overhead, sped development from weeks to days, and lowered data-team work time by 40% while enabling real-time fraud analysis.
read more →

Cloud SQL Powers Manhattan Associates' AI Supply Chain

🚀 Manhattan Associates modernized its Manhattan Active SaaS platform by migrating from legacy Oracle and DB2 to Google Cloud databases. Cloud SQL and BigQuery now power core transactions and real-time analytics, enabling over a billion API calls per day with average responses under 150 ms. Containerized microservices on GKE, Pub/Sub streaming, and managed observability deliver automated failover, cross-region recovery, and faster feature delivery. The shift reduced manual scaling and licensing overhead while boosting operational agility and resilience.
read more →