Wednesday, July 20, 2022

[google-cloud-sql-discuss] Re: Is anyone else noticing cloud sql for postgres 12 not working

Right now, there is an incident affecting europe-west2 Cloud SQL instances. The Software team is aware of it and is currently working on it to solve it ASAP.

You can get updates of this incident at:

On Thursday, July 14, 2022 at 5:06:19 PM UTC-5 jki...@northwell.edu wrote:
I see errors in the logs that appear to be a misplaced comma in the query used by cloudsqladmin

the query
reads SELECT wait_event current_timestamp, count(*) as num_queries, FROM pg_catalog.pg_stat_activity WHERE wait_event_type='IO' GROUP BY wait_event_type, wait_event

its should read

SELECT wait_event, current_timestamp, count(*) as num_queries FROM pg_catalog.pg_stat_activity WHERE wait_event_type='IO' GROUP BY wait_event_type, wait_event

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/4ab14943-c810-4a5c-b48f-6245d8eaa024n%40googlegroups.com.

Tuesday, July 19, 2022

[google-cloud-sql-discuss] Cloud SQL Mysql - Failover operation in progress

Hi,

My Cloud SQL - MySQL 5.7.37 Highly Available instance is stuck in: "Failover operation in progress. This may take a few minutes. While this operation is running, you may continue to view information about the instance."

It is a fairly small database and it has been stuck like this for 5 hours and the failover is not available so all DB queries are failing. Since it is in an updating mode no command are available. No errors are found in the error log and the operations log only has this stuck operation and completed backups.

I hope anyone can help me as there is no way to get support from Google other than pay for it (which I think is pretty bad since this is a fully managed service they are selling).

Best,
Carl-Fredrik

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/e9c5cb30-61b1-42b5-afdd-84693b3d9c80n%40googlegroups.com.

Thursday, July 14, 2022

[google-cloud-sql-discuss] Is anyone else noticing cloud sql for postgres 12 not working

I see errors in the logs that appear to be a misplaced comma in the query used by cloudsqladmin

the query
reads SELECT wait_event current_timestamp, count(*) as num_queries, FROM pg_catalog.pg_stat_activity WHERE wait_event_type='IO' GROUP BY wait_event_type, wait_event

its should read

SELECT wait_event, current_timestamp, count(*) as num_queries FROM pg_catalog.pg_stat_activity WHERE wait_event_type='IO' GROUP BY wait_event_type, wait_event

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ba00e577-bb10-49e7-8b0f-997890fa23b4n%40googlegroups.com.

Tuesday, July 12, 2022

[google-cloud-sql-discuss] Important Google Group update: Moving to the Google Cloud Community August 1st, 2022

Hi there, 

My name is Willie and I am a Community Manager here at Google. You're receiving this message because you've previously engaged with one of our Google Cloud Google Groups. This message is to inform you of an upcoming change to Google Cloud support via Google Groups, which will help streamline and accelerate the rate at which you receive answers to your questions.

Beginning on August 1st, 2022, you can no longer submit questions or receive answers in the Google Group in which you are receiving this message. You'll still be able to read historic messages within the Google Group, but you can no longer submit new messages or replies. 

All future questions and discussions around Google Cloud SQL will take place in the Google Cloud Community via the corresponding forum linked below.

Cloud SQL

Don't have a Google Cloud Community account yet? It's easy and free to sign up by following the steps here

9sPFdHNK6zFsWVd (2).png

Then you can ask questions, find answers, subscribe to receive the latest news, and more. Have questions about creating an account or publishing a post? You can reach out to the Google Cloud Community team at gc-customer-community@google.com 


Thank you! We look forward to seeing you in the Community. 


Willie, on behalf of The Google Cloud Community team


--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/a39f1e9b-7b38-4b4e-9471-eab9d23a2261n%40googlegroups.com.

Friday, July 8, 2022

Re: [google-cloud-sql-discuss] Shareing CloudSQL

Two ways:

1) Use Public IP. Safest way to do that is use Public IP but don't authorize any networks, and use the Cloud SQL Auth Proxy to connect to it from the other project (you'll need an IAM service account key from the Cloud SQL project to do this).

2) Set up VPC Sharing at the organization level and host the Cloud SQL's project with the project you want to access it from. This treats the VPCs as essentially the same between the two projects.

Gabe Weiss (he/him) | Developer Advocate | gweiss@google.com



On Fri, Jul 8, 2022 at 9:18 AM Kenika Pandey <pa.kenika_st@tni.ac.th> wrote:

Is it possible to share the ClouldSQL provisioned with one project with the other? If yes, could you please guide me on how to achieve it?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/36e626f0-d645-4511-b9d4-a41b125f8bbdn%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAM9LKEq%3DN%2B2xhmWGK8uJ48%2B8RVbNBvuN6n9PhbQUJ0Ug%3D-9RYw%40mail.gmail.com.

Re: [google-cloud-sql-discuss] Is it possible to connect through vpc peering?

Unfortunately no, not easily. Cloud SQL is a service deployed from Private Services (a Google-managed VPC) and when you instantiate an instance of it, that Cloud SQL is peered to your project's VPC where you deploy it. That means there's already one degree of VPC peering happening. VPC peering is not transitive sadly. So e.g. you have VPC A peered to VPC B, and VPC B is peered to VPC C. VPCs A and C cannot see each other.

Ways around this are to use VPC Sharing instead of peering, and use hosted projects to house your data (shared VPCs can see each other okay), or use Public IP on your Cloud SQL instance (but don't use authorized networks which becomes more of a security issue) and use the SQL Proxy like you are. You can also set up a bastion instance in the VPC with Cloud SQL. Use a VM with a public IP that you lock down to only be able to communicate with the application VPC, and use something like a Socks5 proxy on the bastion instance.

Gabe Weiss (he/him) | Developer Advocate | gweiss@google.com



On Fri, Jul 8, 2022 at 9:18 AM 변재천 <byunddong88@gmail.com> wrote:
I made two VPCs and connected them with peering.
Can I access Cloud SQL in B-VPC from VM in A-VPC?
SQL Proxy and Public IP are not being used.
Cloud SQL is using private IP.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/871246a5-5c07-413d-8a17-cbba2e0fb0a8n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAM9LKEr%3DtB2Wq%3DXEY94EGzXgDSeZ%2ByOmSgEkKCrDt-vMZ7paVQ%40mail.gmail.com.

Thursday, July 7, 2022

[google-cloud-sql-discuss] Shareing CloudSQL

Is it possible to share the ClouldSQL provisioned with one project with the other? If yes, could you please guide me on how to achieve it?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/36e626f0-d645-4511-b9d4-a41b125f8bbdn%40googlegroups.com.