We performed a comparison between MySQL, SAP SQL Anywhere, and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases."The main advantage is the very large user base. This enables users to fix about any issue by answering any question."
"The solution is very stable."
"Compared to other databases, MySQL is cheaper and we were using the community edition which was free of cost. ML is fully integrated with the database in HeatWave. It has also many other features. MySQL is a far better solution in terms of pricing."
"The easy access to the data and the ability to sort the data with multiple methods are very valuable features."
"The solution is a small application and is very easy to deploy."
"MySQL has cross-platform support for multiple operating systems. The backups on a Linux machine can be restored on a Windows machine, and vice versa."
"MySQL's clustering features are very strong, and you can automate scripting, so that helps. We wrote a Terraform script and ran it."
"It is very easy to install and has all basic database features."
"SAP SQL Anywhere is very helpful."
"The auto-backup replication is a perfect feature. That is the feature I liked the most."
"The most valuable features of SAP SQL Anywhere are the ease of use and the user interface is intuitive."
"It works well in general."
"We've found the solution very reliable overall. It's very fast."
"The performance is very good and the aggregate records are fast."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"Its projections and encoding are excellent tools for tuning large volumes."
"The full-text search feature must be improved."
"It should have some code analytical functions. It can also have a monitoring tool."
"It could be more secure."
"If the customer is already using or has already used Oracle for a long time they will know the look and feel and the character of this database that can fit into their business."
"This solution needs to be improved when it comes to working with desktop applications on the developer side."
"In an upcoming release, there should be something added similar to EPL. For example, when using the flow diagram, we can create a schema. We have two useful features to add or create the table, but there should be some UI features to allow us to drag and drop to create other schemas. This would be very helpful."
"We want high availability and replication features, which are currently missing in this solution. It would be great if they can provide an in-built replication feature, similar to Oracle RAC, in MySQL."
"The analytics features are in need of improvement."
"A problem we are experiencing now is when doing a backup in SQL 2012 and 14."
"SAP SQL Anywhere needs to incorporate functionalities like SAP S/4HANA."
"The interface is not easy in comparison to the SQL Server. It could be more user-friendly."
"It is not as secure as it could be."
"We have had some stability issues with SAP SQL Anywhere, but I am not sure if it is an application or network issue. We sometimes have a large amount of data being queried and it cannot handle it."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"It would be great if this were a managed service in AWS."
"Support is an area where it could get better."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"They could improve the integration and some of the features in the cloud version."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"They could improve on customer service."