Google Cloud SQL vs. InfluxDB

Does what it promises well, for instance, as a sidecar for the main enterprise data warehouse. However, I would not recommend using it as the main data warehouse, particularly due to the heavy business logic, as other dedicated tools are more suitable for ensuring scalable operations in terms of change management and multi-developer adjustments.

Incentivized

InfluxDB is a time series database and should be used in that intent. Each data ingestion streams should be properly configured to ensure optimal database performance. InfluxDB works very well but like any other databases requires maintenance and tuning. We have been using the TICK stack and are very happy with the results.

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

• Time series data
• Very fast queries
• Many options to configure and tune database

Incentivized

• Increasing support for more database engines may enable a wider range of application needs to be met.
• Implementing and updating cutting-edge security features on a constant basis.
• Streamlining and enhancing the tools for transferring data to Google Cloud SQL from on-premises databases or other cloud providers.

• Small, but growing community - This database engine's community is much smaller than alternatives. This can make finding a DBA or support less easy, but not impossible.
• Documentation could be improved - The docs for getting started don't effectively lead first-time users to understand how the underlying systems are designed.
• Performance Analysis - There seems to be a lack of tools to give context to slow queries or other performance issues
• Out-of-the-box security - The out of the box security is designed to operate in an internal network and is limited.

Incentivized

It fits the current needs and bandwith of out lean organization.

Incentivized

InfluxDB is a near perfect product for time series database engines. The relatively small list of cons are heavily outweighed by it's ability to just work and be a very flexible and powerful database engine. The community and support provided by the corporation are the only areas I have little experience.

Incentivized

As with other cloud tools, users must learn a new terminology to navigate the various tools and configurations, and understand Google Cloud's configuration structure to perform even the most basic operations. So the learning curve is quite steep, but after a few months, it gets easier to maintain.

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

We have worked with the InfluxDB support team a few times so far and it has been positive. Issues submitted are worked on promptly and we have good feedback.

Incentivized

Unlike other products, Google Cloud SQL has very flexible features that allow it to be selected for a free trial account so that the product can be analyzed and tested before purchasing it. Integration capabilities with most of the web services tools are easier regarding Google Cloud SQL with its nature and support.

Incentivized

We have looked around to find different options we had when we first started to move to cloud. At that time, the options we had is Google Cloud BigTable and InfluxDB. But quickly we realized that InfluxDB is the database specialized in time series database and performs better than other options we have.

Incentivized

• The first one is it's performance is very good and it comes up with different solution.
• Security can be improved for external resources or the schemas which are selected in it.
• It can be more fragile so one can use it in the business purposes and this will make it a great product.

Incentivized

• Provided us a time series DB.
• With the SQL-like language, it is very easy to learn.
• Empowered us to keep track of our events.

Incentivized