Cloud SQL

  1. 2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. gcloud sql connect --tunnel-through-iap

    gcloud sql connect should get an option --tunnel-through-iap much like gcloud compute ssh already has.

    Ie, it should be easy as a developer to connect to an instance regardless of local IP. And importantly, this should work also for instances on private ip/service networking.

    While it is curently possible to accomplish something like this using:

    gcloud compute ssh BASTIONVM --tunnel-through-iap -- PGPASSWORD=$(gcloud auth print-access-token) PGUSER=$(gcloud config list account --format "value(core.account)") PGHOST=CLOUDSQLDNSEDHOSTNAMEORIP psql NAMEOF_DB

    it is kind of cumbersome and there is a bastion VM that needs to be maintained.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Implement Database Level Backup

    The automated instance level backups are great! However, in my experience it is more common to restore a single database rather than an entire database server instance.

    At present, database restores from instance backups are time-consuming and tedious. This is an issue because often restores are highly time-critical and is beneficial to streamline the process so that a restored database can be operational as soon as possible.

    For example, the steps required might look like the following:
    1. Clone SQL server instance to a new instance so that other databases are not overwritten by the backup.
    2. Restore backup to…

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. postgis 3.1.0

    I wanted to use STSquareGrid and STHexagonGrid earlier today. maybe I'll have to spin up pg in ComputeEngine until postgis 3.1.0 is supported in CloudSQL

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Enable X Plugin in MySQL

    Enable the X plugin in MySQL and allow clients to connect to MySQL using the X Dev API.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Managed Upgrade for Postgres Instances

    With Postgres 9.6 EOL on the horizon (November 11, 2021), we need to start thinking about our upgrade process to get on the latest version of Postgres. The main reason we use Cloud SQL is that we do not have expertise in DB administration, so we are worried about this upgrade process.

    Unfortunately, Cloud SQL does not support managed upgrades of instance. It would be great if Cloud SQL could manage this for us by leveraging pg_upgrade (a la RDS).

    50 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  7. Update MySQL 8 minor version to MySQL 8.0.21

    It would be nice if the recently announced Cloud SQL version of MySQL 8 (currently 8.0.18) would be updated to the latest minor version 8.0.21. In 8.0.18, I'm experiencing a bug using a select statement joining two grouped statements with rollup that does not occur on 5.7 or 8.0.21.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. active directory

    Microsoft active directory support for Cloud SQL - SQL Server

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Support CDC for SQL Server databases

    I would liek CDC running for several reasons in user databases, but this seems not supported. I did a quick test like below:

    CREATE DATABASE dummyDB;
    GO

    USE dummyDB;
    GO
    EXEC sys.spcdcenable_db;

    Output:
    Msg 22902, Level 16, State 1, Procedure sys.spcdcenable_db, Line 20 [Batch Start Line 5]
    Caller is not authorized to initiate the requested action. Sysadmin privileges are required.

    Also tried to import a database (with cdc on) backup, and the import fails.

    This is not included in the list of features not supported, and I think that it should. https://cloud.google.com/sql/docs/sqlserver/features#sqlserver-unavailable

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  10. Instance collation configurable for SQL Server

    Haven´t found a way to edit the collation for the whole instance on SQL Server. I have seen the default one is SQLLatin1GeneralCP1CI_AS.

    Among other things, this affects to TempDB collation and all the rest of system databases. Now let's imagine we want to create/import an user database with a different collation, I want that the instance collation (hence Tempdb) to be aligned with the user database collation.

    Not having this option could bring performance issues in the future (tempdb is used by SQL Server Query Engine and queries execution plans), so it means automatically discarding…

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. SQL Server 2019 support

    When will SQL Server 2019 be available in GCloud Cloud SQL?

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. CloudSQL Multi-Master Replication

    The ability to create multi-master replication across different zones. We're looking to expand our MySQL scaling.

    Even giving us access to SUPER to manage our own replication chains would be helpful. There's no simple way to get failover options in different zones at the moment

    21 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. delete instances sql server HTTPError 409

    When attempting to delete a sql server instance it presents the following error: ERROR: (gcloud.sql.instances.delete) HTTPError 409: The instance or operation is not in an appropriate state to handle the request.

    The instances are updating several hours.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. TimescaleDB extension support

    On the issue tracker this is the top #1 feature request: https://issuetracker.google.com/issues/64602105

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Postgres smaller Read Replicas

    Today, when you create a replica for postgres in CloudSQL, it only allows VMs the same size of the master.

    It is very expensive this setup, at least for my team. We use the replica for reports that we do not want to impact the load of the master.

    I think it is a common case, on AWS it works fine.

    It seems to have a validation before doing anything on it. Maybe remove the validation, and show a disclaimer saying "at your own risk". I'm assuming it works behind the scenes.

    Or make it possible to create external replicas…

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Allow placing a lien on a cloud SQL database

    When you use tools like Terraform, one could imagine that due to a bug or error, a cloud sql database instance is removed.

    One way to prevent this from happening is to introduce liens for cloud SQL. That way Terraform's plan would suggest removing the cloud database, but the operation would simply fail because of the lien.

    Liens are now active on both project level, and compute instance level. I think applying this same concept to cloud SQL should not be too difficult and would really help.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. manual trigger maintenance window to test downtime within HA architecture

    Cloud SQL Master and Slaves use the same maintenance window, it cannot be changed.

    If there is a test function to trigger maintenance, we can figure out if there is any downtime within the maintenance window.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Create automated backups that are not stored on the instance

    Cloud SQL automated backups are now stored on the instance itself. So, if the instance is gone or deleted, the backups are as well.

    I know we can export the database to a bucket, but we cannot do this automatically. Only manually.

    What good is a backup if it gets deleted when I delete the instance, the idea of a backup is to restore something especially for when someone accidentally deletes the instance.

    This is even more important because deleting an instances is appearantly really easy to do. There is no 2FA or password asked.

    So, in short, I would…

    32 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Migration service for Postgres

    Currently the only way to migrate Postgres into Cloud SQL is to dump and restore. This necessitates downtime. We need a way to migrate Postgres DB without downtime.

    So in practice GCP needs to do a managed Bucardo service to transfer data into Cloud SQL, and subsequently we can switch the Replica status to Master status.

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Allow Change Data Capturing on Cloud SQL Databases, using Replication slots for Logical Decoding

    Companies are investing into "data lakes" supported by Kafka or Google PubSub. They typically have their data in relational databases like PostgreSQL. In order to make the change on the relational data consumable for other applications (for building caches, search engines, messaging, ...), those companies need Change Data Capturing (CDC) on their database.

    Google should allow to add a Replication Slot in the managed Cloud SQL Postgres instance (https://www.postgresql.org/docs/9.6/static/logicaldecoding-explanation.html) in order to allow to publish row changes to Kafka and/or PubSub.

    313 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Today Cloud SQL for PostgreSQL launched support for change data capture and logical decoding in Public Preview. Users can now stream data for real-time analytics, perform selective replication, set up external replicas, and more. To learn more, see our blog post:

    https://cloud.google.com/blog/products/databases/you-can-now-use-cdc-from-cloudsql-for-postgresql

    Check out our release notes here:
    https://cloud.google.com/sql/docs/postgres/release-notes#June_01_2021

← Previous 1
  • Don't see your idea?

Cloud SQL

Categories

Feedback and Knowledge Base