Google Cloud SQL vs. Percona Server for MySQL

Although Google Cloud SQL has room for improvement by addressing a minor lack of features, its features and services keep it high among other SQL database products. It is very fast compared to others. Since it is cloud-based, maintenance is also easier. Integration capabilities are also more than expected.

Incentivized

Percona Server for MySQL covers 100% of our requirements in terms of our OLTP traffic and provides the High Availability levels required through a typical primary and 2 replica's using semi-synchronous replication. We're able to scale our writes using sharding, but a true distributed database would be a great option on top of this. In terms of OLAP traffic, we leverage columns stores available, but Percona Server fairs well

• Highly scalable without worrying about sudden transaction explosion during peak hours.
• Highly available with multiple geographical locations and regions for nearly 0 downtime to the users.
• Extremely reliable and responsive for high latency applications due to superb networking at the core.

Incentivized

• Faster than other server solutions
• Installation and configuration process is easy from the user's standpoint
• Easy to learn and good support

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.

• Better documentation
• A better UI

On demand scalability helps us provision extra resources as per our requirement and load on the application. Reduced cost due to fully managed services and no need to manage underlying infrastructure which reduced time of patching and maintaining underlying infrastructure. Easy to configure as per application requirements. Supports monitoring which is not available in custom hosted database instance on own computing infrastructure

Incentivized

It is easy to install and use. Using it along with Percona Monitoring and Management makes it even easier to use.

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 are using opensource so we have not used customer support.

Google SQL was great as a first SQL provision. It quickly enabled the apps to be built and scaled as needed for a while. It was robust and adaptable as needed and easy to export as needed when ready, depending on growth. Cost-wise, it's a good choice and requires little investment to get going.

Incentivized

Performance and stability sets Percona Server for MySQL apart from the rest. Percona embraces the upstream version and contributes towards the upstream version making MySQL stronger on two fronts and thus having a much larger community. Many quality contributions have been made by Percona into the base code. Percona provides great tools to support Percona Server for MySQL and this makes the monitoring and management easier

• With managed database system, it has given us near 100% data availability
• It has also improved web layer experience with faster processing and authentication using database fields
• Google Cloud SQL also gels up well with Google Analytics and other analytics systems for us to join up different data points and process them for deeper dives and analysis

Incentivized

• At the performance level, it maintains and even improves other open-source databases such as MariaDB or some commercial ones such as Oracle.
• If we compare it with MySQL, we could have up to 50% improvement in performance.
• For some small companies or startups, the price of the complete solution and the support can be a bit high.

Incentivized