google-cloud-sql Archives

[Solved] I need to connect to Google cloud mysql using java but without using spring boot?

March 3, 2023 by Kirat

As @siamsot mentioned, there is an article in the official GCP documentation on how to connect to a Cloud SQL instance. Basically, you have the following options to connect to a Cloud SQL instance: By using the proxy (Second Generation instances only) By configuring access for one or more public IP addresses By using the … Read more

[Solved] Backup/Restore on CloudSQL instances

December 5, 2022 by Kirat

Here I address you questions: 1. Any way to check the size of existing databases in CloudSQL instances? Yes, there is. This depends on the database engine you are using(mysql, postgres or mssql) For mysql, you can run: SELECT table_schema “DB Name”, ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) “DB Size in MB” FROM … Read more