WorryFree Computers   »   [go: up one dir, main page]

Cloud SQL logo

Cloud SQL

Focus on your application, and leave the database to us

Fully managed, cost-effective relational database service for PostgreSQL, MySQL, and SQL Server. Try Enterprise Plus edition for a 99.99% availability SLA and category-leading performance.

New customers get $300 in free credits to try Cloud SQL and other Google Cloud products.

Features

Fully managed

Cloud SQL manages your databases so you don't have to, enabling your business to run without disruption. We automate all your backups, replication, patches, encryption, and storage capacity increases to give your applications the reliability, scalability, and security they need.

Price performance options

Cloud SQL provides the flexibility to choose the right capabilities based on your performance, availability, and data protection needs for your database workloads. The Enterprise edition provides the lowest cost with balanced performance, while the Enterprise Plus edition is suitable for the most demanding transactional workloads, providing the highest performance with a fully optimized software and hardware stack featuring a data cache option. The data cache leverages flash memory on your MySQL and PostgreSQL database instances to lower read latency and improve throughput by intelligently caching data across memory and high speed local storage.

Chess com logo
Learn how Chess.com used Enterprise Plus to cut response time by 71%

High availability with near sub-second downtime maintenance

Easily configure built-in high availability with automatic failover across zones to protect your applications from a variety of possible failures. The Enterprise edition provides a 99.95% availability SLA for general purpose workloads, while the Enterprise Plus edition offers a 99.99% availability SLA for the most demanding workloads featuring maintenance and instance scale-up with typically sub-second downtime. It also offers enhanced disaster recovery capabilities that allow failover and switchback to your original topology with zero data loss and no application changes.

Gemini in Cloud SQL

Simplify all aspects of the database journey with AI-powered assistance, helping you focus on what matters most. Gemini in Cloud SQL, in preview, simplifies all aspects of database operations including development, performance optimization, fleet management, governance, and migration. It offers insights into database performance, security, reliability, and cost to help you quickly understand and resolve issues of all types.

Gemini also makes database migrations simpler and faster with AI-powered assistance. Gemini in Database Migration Service, in preview, helps you review and convert database-resident code like stored procedures, triggers, and functions and run it in Cloud SQL for PostgreSQL.

Cloud storage icon
Learn how you can supercharge database development and management with Gemini in Cloud SQL

Firebase Data Connect

Firebase Data Connect bridges the gap between Firebase's powerful mobile/web development features and PostgreSQL's rich data management capabilities. Leverage the power of Cloud SQL for PostgreSQL as your backend while enjoying the seamless Firebase development experience. Build faster, smarter, and more effectively.

Firebase

Vector Search

Vector search is a critical capability for building useful and accurate gen AI-powered apps. Cloud SQL for PostgreSQL and MySQL support two search approaches for balancing speed and accuracy. Approximate nearest neighbor (ANN) vector search is ideal for large datasets where close matches suffice, while exact nearest neighbor (KNN) vector search is typically used for high precision on smaller datasets. Integrate vector search directly into your existing AI-powered apps without needing to learn and manage a separate system.

Cost-effective

According to an IDC study, Cloud SQL customers achieved a three-year ROI of 246% and a payback period of 11 months. Committed use discounts offer additional savings for one to three year commitments.

Cloud storage icon
Learn how companies achieved a three-year ROI of 246% in this IDC report

Open and standards-based

Cloud SQL supports the most popular open source and commercial engines, including MySQL, PostgreSQL, and SQL Server with rich support for extensions, configuration flags, and popular developer tools. It's easy to get started—simply bring your existing skills over and enjoy the flexibility to work the way you want. You can create a database with just a few clicks in the console and connect your application.

LangChain integration

Easily build gen AI applications with LangChain. Cloud SQL features three LangChain integrations - Document loader for loading and storing information from documents, Vector stores for enabling semantic search, and Chat Messages History for saving/fetching previous chat conversations. Visit the Github repository for PostgreSQL, MySQL, and SQL Server to learn more.

Easy migrations

No matter where your database is located—whether on-premises, on Compute Engine, or in other clouds—Database Migration Service (DMS) can migrate it securely and with minimal downtime. DMS leverages the native replication capabilities of the source database to maximize the reliability of your migration. And lift and shift migrations to Cloud SQL are available at no additional charge.

Integrated

Cloud SQL seamlessly integrates with Google Cloud services, such as Compute Engine, Cloud Run, Google Kubernetes Engine, and Cloud IAM, allowing developers to build and deploy applications with ease. Provision your database via APIs and third-party tools, and use federated queries from BigQuery and low-latency database replication with Datastream for near real-time insights on operational data.

Data protection and compliance

Configure backups for data protection and restore your instance to an earlier point in time with a retention period of up to 35 days. Configure where your data is stored to comply with data residency requirements. Cloud SQL automatically encrypts data, is SSAE 16, ISO 27001, and PCI DSS compliant, and supports HIPAA compliance.

Cloud storage icon
Learn how to secure a Cloud SQL for PostgreSQL instance

Secure access and connectivity

Cloud SQL data is encrypted when in transit on Google’s internal networks and when at rest in database tables, temporary files, and backups. It supports private connectivity with Virtual Private Cloud (VPC), and every Cloud SQL instance includes a network firewall, allowing you to control public network access. Cloud SQL also supports Private Service Connect, which allows you to access your database instances via private IP without going through the internet or using external IP addresses.

Scalability

Easily scale up as your data grows—add compute and storage, and scale out by adding read replicas to handle increasing read traffic. Cloud SQL can also automatically scale up storage capacity when you’re near your limit. Read replicas support high availability, can have their own read replicas, and can be located across regions.

Change data capture and replication

Stream data across heterogeneous databases, storage systems, and applications reliably and with minimal latency with Datastream and Datastream for BigQuery. Scale up or down with a serverless architecture and no resources to provision or manage, and enable near real-time insights on operational data.

How It Works

Cloud SQL scales up in minutes and replicates data across zones and regions. It uses agents for maintenance, logging, monitoring, and configuration, with services backed by a 24/7 SRE team. Manage your database via the console, CLI, or REST API and connect your app via standard database drivers. 

Database Configurations with Cloud SQL video thumbnail

Common Uses

Database migration

Migrate to a fully managed database solution

Self-managing a database, such as MySQL, PostgreSQL, or SQL Server, can be inefficient and expensive, with significant effort around patching, hardware maintenance, backups, and tuning. Migrating to a fully managed solution has never been simpler—you can lift and shift your database from any on-premises or cloud location using Database Migration Service with minimal downtime.
Evolution of managed databases graph

Migrate to a fully managed database solution

Self-managing a database, such as MySQL, PostgreSQL, or SQL Server, can be inefficient and expensive, with significant effort around patching, hardware maintenance, backups, and tuning. Migrating to a fully managed solution has never been simpler—you can lift and shift your database from any on-premises or cloud location using Database Migration Service with minimal downtime.
Evolution of managed databases graph

Database modernization

Modernize your application with open source

A cloud deployment is a good opportunity to modernize your database environment by transitioning off legacy, proprietary databases and onto open source databases, such as PostgreSQL. With open source databases having become enterprise-ready, you don't need to compromise on performance, reliability, or security.
Learn how to get started with Database Migration Service
Modernization image

    Modernize your application with open source

    A cloud deployment is a good opportunity to modernize your database environment by transitioning off legacy, proprietary databases and onto open source databases, such as PostgreSQL. With open source databases having become enterprise-ready, you don't need to compromise on performance, reliability, or security.
    Learn how to get started with Database Migration Service
    Modernization image

      New application development

      Build data-driven applications

      Cloud SQL accelerates application development via integration with the larger ecosystem of Google Cloud services, Google partners, and the open source community, while giving you the freedom to work the way you want. Reuse your existing database skills while freeing yourself from mundane database administration tasks and leveraging AI/ML-driven insights and recommendations.

      Try the lab: Building a containerized app with a scalable database
      Architecture image of containerized application with scalable database

      Build data-driven applications

      Cloud SQL accelerates application development via integration with the larger ecosystem of Google Cloud services, Google partners, and the open source community, while giving you the freedom to work the way you want. Reuse your existing database skills while freeing yourself from mundane database administration tasks and leveraging AI/ML-driven insights and recommendations.

      Try the lab: Building a containerized app with a scalable database
      Architecture image of containerized application with scalable database

      Third-party applications

      Deploy applications with confidence

      Many software vendors build and certify their applications for MySQL, PostgreSQL, and SQL Server. Since Cloud SQL offers standard versions of these databases, including extensions, configuration flags, and drivers, applications can run unmodified. Make your journey to the cloud and let us take tedious database administration tasks off your plate.
      Find a Google Cloud partner
      Partners

        Deploy applications with confidence

        Many software vendors build and certify their applications for MySQL, PostgreSQL, and SQL Server. Since Cloud SQL offers standard versions of these databases, including extensions, configuration flags, and drivers, applications can run unmodified. Make your journey to the cloud and let us take tedious database administration tasks off your plate.
        Find a Google Cloud partner
        Partners

          Pricing

          How Cloud SQL pricing worksPricing varies with editions, engine, and settings, including how much storage, memory, and CPU you provision. Cloud SQL offers per-second billing.
          ServiceDescriptionPrice

          Compute

          Cloud SQL Enterprise

          Best for general purpose workloads. It offers:

          1-96 vCPUs

          1:6.5 core memory ratio

          99.95% SLA

          < 60s of planned downtime

          Starting at

          $0.0413

          per vCPU/hour

          Cloud SQL Enterprise Plus

          Best for high performance workloads. It offers:

          Up to 128 vCPUs

          1:8 core memory ratio

          99.99% SLA

          < 10 seconds of planned downtime

          2x read and write performance

          Starting at

          $0.05369

          per vCPU/hour

          Memory

          Cloud SQL Enterprise

          up to 624 GB

          Starting at

          $0.007

          per GB/hour

          Cloud SQL Enterprise Plus

          up to 824 GB

          Starting at

          $0.0091

          per GB/hour

          Storage - SSD

          Storage and networking prices depend on the region where the instance is located; Cloud SQL Enterprise pricing and Cloud SQL Enterprise Plus pricing are the same

          $0.17

          per GB/month

          Storage - Local SSD

          This is only available for Cloud SQL Enterprise Plus

          $0.16

          per GB/month

          PITR Logs on Google Cloud Storage

          Cloud SQL Enterprise

          Up to 7 days

          Free

          Cloud SQL Enterprise Plus

          Up to 35 days

          Free

          How Cloud SQL pricing works

          Pricing varies with editions, engine, and settings, including how much storage, memory, and CPU you provision. Cloud SQL offers per-second billing.

          Compute

          Description

          Cloud SQL Enterprise

          Best for general purpose workloads. It offers:

          1-96 vCPUs

          1:6.5 core memory ratio

          99.95% SLA

          < 60s of planned downtime

          Price

          Starting at

          $0.0413

          per vCPU/hour

          Cloud SQL Enterprise Plus

          Best for high performance workloads. It offers:

          Up to 128 vCPUs

          1:8 core memory ratio

          99.99% SLA

          < 10 seconds of planned downtime

          2x read and write performance

          Description

          Starting at

          $0.05369

          per vCPU/hour

          Memory

          Description

          Cloud SQL Enterprise

          up to 624 GB

          Price

          Starting at

          $0.007

          per GB/hour

          Cloud SQL Enterprise Plus

          up to 824 GB

          Description

          Starting at

          $0.0091

          per GB/hour

          Storage - SSD

          Description

          Storage and networking prices depend on the region where the instance is located; Cloud SQL Enterprise pricing and Cloud SQL Enterprise Plus pricing are the same

          Price

          $0.17

          per GB/month

          Storage - Local SSD

          Description

          This is only available for Cloud SQL Enterprise Plus

          Price

          $0.16

          per GB/month

          PITR Logs on Google Cloud Storage

          Description

          Cloud SQL Enterprise

          Up to 7 days

          Price

          Free

          Cloud SQL Enterprise Plus

          Up to 35 days

          Description

          Free

          Pricing Calculator

          Estimate your monthly Cloud SQL costs, including region specific pricing and fees.

          custom quote

          Connect with our sales team to get a custom quote for your organization.

          Start your proof of concept

          New customers get $300 in free credits to try Cloud SQL and other Google Cloud products

          Learn how to use Cloud SQL

          Build a resilient architecture with Cloud SQL

          Federate queries from BigQuery into Cloud SQL

          Migrate a database to Cloud SQL using DMS

          Business Case

          More than 95% of Google Cloud’s top 100 customers use Cloud SQL


          Linear Logo

          “Given Linear’s existing data volume and our goals for finding a cost-efficient solution, we selected Cloud SQL for PostgreSQL once support for pgvector was added. We were impressed by its scalability and reliability. This choice was also compatible with our existing database usage, models, ORM, etc. and this meant the learning curve was non-existent for our team.”

          Tom Moor, Head of US Engineering, Linear

          Leveraging the power of Cloud SQL for PostgreSQL with pgvector support, Linear was able to keep pace with its expanding customer base–improving the efficiency, scalability, and reliability of data management, scaling up into the tens of terabytes without increasing engineering effort.

          Read customer story

          Featured benefits


          Standard connection drivers and built-in migration tools allow you to create and connect to your first database in just a few minutes.

          Scale your instances effortlessly with a single API call whether you start with simple testing or you need a highly available database in production.

          Data encryption at rest and in transit. Private connectivity with Virtual Private Cloud and user-controlled network access with firewall protection. Compliant with SSAE 16, ISO 27001, PCI DSS, and supports HIPAA compliance.

          • Wayfair logo
          • MLB logo
          • BBVA logo
          • Autotrader logo

          Partners & Integration

          Accelerate your workloads by working with a partner
          • Dataiku logo
          • Deepnote logo
          • Hex logo
          • Starburst logo
          • Tellius logo
          • Zing logo
          • Dataiku logo
          • Deepnote logo
          • Hex logo
          • Starburst logo
          • Tellius logo
          • Zing logo
          • Percona logo
          • Pythian logo
          • Quantiphi logo
          • SADA logo
          • Searce logo
          • 66 degrees logo
          • Airbyte logo
          • CData logo
          • Arcion logo
          • Census logo
          • Confluent logo
          • Dataddo logo
          • Denodo logo
          • Fivetran logo
          • Hasura logo
          • Hevo logo
          • Integrate.io logo
          • KingswaySoft logo
          • Nexla logo
          • Qlik logo
          • Quest logo
          • Rivery logo
          • Retool logo
          • Skyvia logo
          • Striim logo
          • Talend logo
          • Datadog logo
          • Dynatrace logo
          • Masthead logo
          • New Relic logo
          • Soda logo
          • Heimdall Data logo
          • PolyScale logo
          • Vaultree logo

          Build data-driven applications with Google Cloud Ready - Cloud SQL validated partners, and visit the partner directory for a full list of Cloud SQL partners.

          FAQ

          What is Cloud SQL?

          Cloud SQL is a service that delivers fully managed relational databases in the cloud. It offers MySQL, PostgreSQL, and SQL Server database engines.

          Cloud SQL is valued for its openness, ease of use, security, cost-efficiency, and Google Cloud integration—in fact, more than 95% of Google Cloud’s top 100 customers use it. If you're comparing PostgreSQL options on Google Cloud, view our comparison chart.

          The Enterprise Plus edition brings enhanced availability, performance, and data protection capabilities. Specifically, it provides a 99.99% availability SLA with near-zero downtime maintenance, optimized hardware and software configurations, intelligent data caching for read-intensive transactional workloads, a configurable data cache option, 35 days of log retention and advanced failover capabilities like orchestrated switchover and switchback (Cloud SQL for MySQL only).

          Use Database Migration Service to migrate securely and with minimal downtime, no matter where your source database is located.

          Go to the Cloud SQL console and create a database instance. Get up and running quickly with a Quickstart for MySQL, PostgreSQL, or SQL Server.

          New customers get $300 in free credits to spend on Cloud SQL. You won’t be charged until you upgrade.

          Other questions and support
          Google Cloud
          • ‪English‬
          • ‪Deutsch‬
          • ‪Español‬
          • ‪Español (Latinoamérica)‬
          • ‪Français‬
          • ‪Indonesia‬
          • ‪Italiano‬
          • ‪Português (Brasil)‬
          • ‪简体中文‬
          • ‪繁體中文‬
          • ‪日本語‬
          • ‪한국어‬
          Console