What is better approach “mysql on VM GCE” vs Google SQL Cloud

1
votes

I want to use a small mysql database in order to store some data that i going to calculate on a VM of GCE (by using Talend).

After store the data on the mysql i want to connect to it by using Excel, and update some registries.

What should be the best approach, install mysql on the VM or use Google Cloud SQL?

Kind Regards

2
mysqlgoogle-compute-enginegoogle-cloud-sql

2 Answers

2
votes

Only you can decide what better fits your needs, but you may consider the following:

Local Mysql Pros:

  • Faster performances. This could be important if generating a lot of queries you would need a bigger Cloud SQL instance to have similar speed.
  • Minor costs

Cloud SQL Pros:

  • High reliability. Data is backed-up without the need of taking snapshots.
  • Possibility to stop or delete GCE instance and keep database active.
  • Easier and faster to scale if required
  • Easily add a read replica.
  • Less load on the GCE

Sincerely, Paolo

0
votes

For better performance you can run your MySQL server on a virtual machine. I have tried that with the same server specifications (1 CPU, 3.75 GB memory) and it runs much better.