Google Cloud — What is it and should you use it?
After a long night of fruitless attempts to get MySQL to run perfectly on Ubuntu 16.04, I was finally fed up with this abysmal piece of “software.” Sure I could get it to work easily on Ubuntu 14.04, but why should I need to run it on such an outdated OS? In a few days it will be 3 whole years old! I decided I really needed to find another solution to this horrible problem.
As I brainstormed ideas of how I could do this easily, I made a list of options that would give me the best of security, reliability, and usability. My current options were to use the practically outdated version of Ubuntu, use a preinstalled VM with it already installed, or use a cloud provider. I could automatically remove the first two choices from the list as they were both, in my opinion, insecure. I couldn't easily setup my own security measures on a preinstalled VM, support will slowly be discontinued for older versions of Ubuntu, both weren't ideal situations.
Due to the fact that I only had one option, I decided to look around at various cloud providers. At first I wanted to go with AWS as they were by far the most popular. I decided to skip them due to the fact that they would not have let me provision VMs with them on the past. Rackspace was way too expensive for my needs so I finally had narrowed it down to Google Cloud and Microsoft Azure.
Seeing as I was more of a Google fan, I decided to give them a shot first. I am glad I decided to as it has been nothing but a great experience.
Provisioning the SQL server took around 5–10 minutes.
It had a nice set of graphs to see how much storage was being taken up.
It had also easy access controls to whitelist remote IPs and create/delete users + assign them to databases.
Security appears to be pretty damn good. Whitelisting IPs, allowing users to only access certain IPs, basically all the security features you can normally do on MySQL.
I hope you found this article helpful in deciding if Google Cloud SQL is right for you!