Amazon Athena vs. Google Cloud SQL

If you are looking to take a lot of the traditional "database administration" work off someone's plate, going with Amazon Athena certainly has "no code" options to optimize lots of database tasks. I would say this option is less appropriate if you have other Microsoft things at play, such as Power BI.

Incentivized

[Google Cloud SQL] is a big help for IT administrators to ensure the security of databases and data backups as well as replacing replica databases in failover situations, It is very powerful and fast in managing and migrating databases and it only takes a few minutes to create and connect to your first database using the built-in migration tools.

Incentivized

• Nested Schemas like JSON data structure
• Ability to adapt the data model to fit your queries better
• Performance Improvement

Incentivized

• Very easy to use and migrate existing database systems to Google Cloud SQL system
• Easy to query with real-time query assessment as well as processing metrics to help optimize the queries
• No need to learn any other querying language (like in Hadoop ecosystem), as SQL works pretty fine
• Easy-to-use GCP portal to type in queries and see the results on the screen (no need to go on command line )
• Easy to set up

Incentivized

• Query manager can incoperate GUI based query designer
• Auto-completion engine sometimes overwrite the query
• Time range selection should be implicit

Incentivized

• Secure access is complicated to set up - This is the nature of secure access, but it can be frustrating spending much time simply configuring access.
• No custom IP - It isn't possible to customize an instance's IP. This makes it harder to replace an instance since a new or clone instance always gets a new IP.
• Cost tends to increase - This is the nature of cloud hosting, but over time costs creep up as utilization increases.

Incentivized

GCP support in general requires a support agreement. For small organizations like us, this is not affordable or reasonable. It would help if Google had a support mechanism for smaller organizations. It was a steep learning curve for us because this was our first entry into the cloud database world. Better documentation also would have helped.

Incentivized

Amazon Athena, a product from Amazon, competes with offerings from Google and Microsoft. Overall, I think your database choice depends on some of the other applications you are running at your company. For example, if you are using Microsoft Power BI for reporting needs, you might want to consider going the Azure route.

Incentivized

At first, we choose Google Cloud SQL only for demo purposes. It is so easy to set up and It is fully managed. we have worked with Azure SQL as well but Google SQL is more simple to use and It fully secure, reliable, provides high availability, and very Low Latency.

• Easy to query terabytes of data with faster response
• Pricing model is also cheap
• No indexing and partitioning

Incentivized

• When first migrated to a cloud environment, the Cloud SQL instance had a higher cost than our former MySQL VM instance, but many other infrastructure costs had also been reduced and the total balance of our migration to the cloud was a reduction of 45% of our infrastructure costs.
• DB performance has increased and maintenance tasks reduced in a high percentage.
• Disaster recovery plans are easier to follow now than before our cloud migration.

Incentivized