Great production database
August 20, 2024

Great production database

Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Google Cloud SQL

We use Google Cloud SQL as our primary production Postgres database, as well as our development/staging database. We love it because of its autoscaling features, automated backups, and excellent security. We primarily connect to the database via our Google Cloud Run instance, and it's all securely tied down in a VPC. It also serves well as a development/staging database - we just turn off some of the more premium features like autoscaling.

Pros

  • Automated backups
  • Autoscaling functionality
  • Great security via VPC

Cons

  • Currently to connect to the database locally, the Cloud Auth tool provided by Google is a bit cumbersome to use, and we end up making more use of "allowed networks" and just enabling our personal IP addresses
  • Google Cloud SQL autoscales up and down based on need and that has definitely saved us on cloud expenses
Everything is great about using Google Cloud SQL, but I only dock marks for requiring the Cloud Auth Proxy to connect locally without using allowed networks. I get that it's necessary since it's behind a VPC but it's just a bit clunky to use. That being said, I wouldn't really call that a big deciding factor for Google Cloud SQL's usability.
The documentation is really clear, and there's especially a lot of documentation when it comes to connecting from services within the Google Cloud platform. It has also been easy to connect from outside of it - we connect to it in our continuous integration environment and have no problems there.
I 100% prefer Google Cloud SQL over Amazon Aurora in terms of ease of use and clarity in terms of understanding how the autoscaling is going to work. Connecting to the database directly is also much more straightforward.

Do you think Google Cloud SQL delivers good value for the price?

Yes

Are you happy with Google Cloud SQL's feature set?

Yes

Did Google Cloud SQL live up to sales and marketing promises?

Yes

Did implementation of Google Cloud SQL go as expected?

Yes

Would you buy Google Cloud SQL again?

Yes

Google Cloud SQL works perfectly as a production database - it's really got all the features you'd want to have good production-related practices and it stays affordable via autoscaling. It probably would be overkill as a development/staging database, but it's also nice to reuse the same configuration between them.

Google Cloud SQL Feature Ratings

Database-as-a-Service
9.5
Database scalability
10
Automated backups
10
Database security provisions
10
Monitoring and metrics
8

Comments

More Reviews of Google Cloud SQL

  1. Home
  2. Database-as-a-Service (DBaaS)
  3. Google Cloud SQL Reviews
  4. User Review of Google Cloud SQL