CODEWITHSUNDEEP
google-compute-enginegoogle-cloud-sql
Amine Jallouli
Amine Jallouli

Reputation: 3949

GCE with LAMP VS GCE with Cloud SQL

What are the advantages for choosing the GCE instance linked with a Google Cloud SQL compared to a GCE with LAMP installed on it?

I am sure that the GCE are scalable, but what about the scalability of the mysql database installed on it?

What about the availablity of the backups for the mysql database on the GCE instance with LAMP?

Thanks...

Upvotes: 5

Views: 639

Answers (1)

cflewis
cflewis

Reputation: 7401

If you use GCE on LAMP, you're basically assigning yourself the sysadmin role. This is great if you want the most customizability out of your instance, but it's on you to take backups and ensure the database stays up-to-date with security patches and such. You can scale out MySQL however you wish.

If you go with Cloud SQL, we take the sysadmin role for you, but this means we can't let you flip various options to ensure you don't prevent us taking backups. We do all the database upgrades for you.

Before I worked at Google, I would generally use SQL providers versus running my own. If I decided I needed more control, I could always dump the database and self-host later. But the headache of self-hosting, particularly for small traffic sites, was always more painful than just getting an SQL instance from an IaaS provider.

Upvotes: 7

Related Questions