I have highly available CloudSQL Postgres instances. If I add read replicas to each one will it cause any downtime, will it require a restart? It is highly likely there is no restart at all, I could not find something…
I am trying to use the Database Migration Service to migrate an existing database into CloudSQL. When I start the migration, I receive the following error: finished setup replication with errors: [api_production]: error importing schema: failed to restore schema: stderr=pg_restore:…
I'm trying to connect to a public IP CloudSQL Postgres database from a cloud function with Prisma. The database has SSL enforced. I assume I can use the Cloud Auth Proxy, and it works locally, but when I deploy it…
I have a PostgreSQL instance running on Cloud SQL in GCP. I am connecting to it via a psql client from another machine. The connection is working fine. However I want to know what happens when you run the following…
Based on the descriptions it seems that for the Read Replicas for Postgresql, the Write-Ahead Log Shipping is used. Is it logical? I have tables without primary keys, however when I spin up a read replica I have no problems…
Hi I am trying to connect my CloudRun to CloudSQL MySQL using public IP. I can connect successfully with public ip but I needed to allow all networks 0.0.0.0 for CloudSQL. I am now trying to connect this way: public…
I created a private CloudSQL instance for a postgres db. I followed the documentation at https://cloud.google.com/sql/docs/postgres/connect-kubernetes-engine and applied the yaml changes and restarted the deployment. Added the below to my existing Yaml for deployment. I was wondering if there is…
I have a pretty "basic" app that we designed that was originally on a local plesk server and we migrated to GAE/GSQL/GCS. app engine, mysql, cloud storage. Here's some background info: App is PHP based, and runs great on the…
I am testing the following configuration. Cloud SQL (tetsql-1) in Region X Zone A A Compute Engine VM (TestVM-1) in the same Region X Zone A. OS is Centos 7 Compute Engine VM is running cloud SQL proxy on non…
We're setting up a Moodle for our LMS and we're designing it to autoscale. Here are the current stack specifications: -Moodle Application (App + Data) baked into an image and launched into a Managed Instance Group -Cloud SQL for database…