Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Lost MySQL connection

Hi please help us if anyone faced such issue:
We have VM instance at VPC network and MySQL server with enabled High Availability at the same VPC. MySQL server provided by GCP (not VM with MySQL at it), it has no public IP, connection via private IP address. We have faced at least to periods when VM could not see MySQL server (our app has queue process that asks DB about new jobs every second):
FROM 29.05.2024 19:19:34 (UTC)
TO 29.05.2024 19:21:05 (UTC)
and
FROM 06.06.2024 14:17:48 (UTC)
TO 06.06.2024 14:24:38 (UTC)

MySQL server was up and running, no any spikes or even warning logs. No logs about operations with MySQL at the time.

Could this be some kind of internal google issue and switch between two DBs (provided by HA)?

1 3 271
3 REPLIES 3

Hello @Pingviek  ,Welcome on Google Cloud Community.

I see only 3 events during provided dates:

DamianS_0-1718099599127.png

I've searched also at status.cloud.google.com but didn't found any issues with connectivity  / SQL / Network  / VM during provides dates.

https://status.cloud.google.com/summary

 

--
cheers,
DamianS
LinkedIn medium.com Cloudskillsboost

Hi @DamianS thanks for the reply, screenshot that you posted, is it Service Health dashboard of your account? I just enabled it, but see no incidents, it might show only those that have effect on our project and only after enabling?

Hello @Pingviek ,

yes, it's Personalized Service Health scoped with project where this API has been enabled. Unfortunately it will start "looking" for events, when enabled. Before that, I've used this site to being notified about issues and anomalies around Google Cloud: https://status.cloud.google.com/

I've wrote also medium.com article about Personalized Service Dashboard: https://medium.com/google-cloud/stay-ahead-of-the-storm-comprehensive-insights-into-google-cloud-per...

--
cheers,
DamianS
LinkedIn medium.com Cloudskillsboost