Percona Server for MySQL vs. SAP IQ

It is a good tool to carry out tests that measure the level of effectiveness of the database and it behaves well when, at the project level, we need to process large volumes of data in a massive way. It is not an optimal solution for applications oriented to the distribution of data between different machines.

Incentivized

If you are loading massive datasets or aggregating huge relational datasets, SAP IQ is incredible. Loading 10 million rows in seconds is incredibly impressive.

Incentivized

• Feature Rich: Percona Server for MySQL always has some additional features on top of MySQL.
• Performance improvements: Additional performance
• Integration with Native and Community tooling: It supports all native and community developed tooling for MySQL

• Superior performance in getting results for query
• Ability to scale up as data size/volume increase
• In memory solution and hence enhanced speed

Incentivized

• A distributed database offering to scale writes with native sharding. Currently we make use of sharding managed by the application to scale writes. There is the option to place ProxySQL in front of the shards, but we need a true cloud native distributed option with an easy migration path. I would not say this is negative in terms of Percona Server for MySQL, but if Percona had a distributed database offering at some stage, we would follow Percona.

• Installation, specifically licensing, is a pain.
• Connectivity is a bit tricky given that the SQL Anywhere drivers aren't native anywhere.

Incentivized

Good community support.

We are using opensource so we have not used customer support.

SAP IQ support is top-notch. I prefer starting all my SAP IQ support tickets with their Instant Messenger, where the majority of our issues are resolved. If it makes it to their ticketing system, they are very prompt at responding and very knowledgeable in the platform.

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

SAP IQ is perhaps an under-marketed product in the sense that it is able to scale up very well and perform much faster and more efficiently than other products such as Oracle - when we ran multiple large queries on both Sybase IQ and Oracle, we found that that results were much faster in Sybase IQ and this gave the confidence to go for this product.

Incentivized

• Increased efficiency with faster querying
• Easy scalability

• The ROI over a number of years has been good. Seeing as how we use it for billing, it has an obvious ROI to us.
• As they have been modifying their licensing structure, it's been difficult to keep up and understand how they work.

Incentivized