We performed a comparison between IBM Netezza Performance Server and MySQL based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."We are able to execute very complex queries. Over 90 percent of our query executions are one second or less. We do millions of queries everyday."
"IBM Netezza Performance Server is a cost-effective solution."
"The performance is most important to me, and it helps our ability to make business decisions quickly."
"Distribution concurrency control."
"The most valuable feature would be the fact that it has been running for awhile in an appliance format."
"The benefit is really because of the additional speed that we have and, truth be told, the more updated ETL processes and the revamped scheduler in general."
"The underlying hardware that IBM provides with this appliance is made for a specific purpose, to serve performance on a large amount of data, and to do analytics as well. It is faster, when you compare it to any other product."
"The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."
"I rate the solution's stability a ten out of ten since it has been running flawlessly."
"The solution is free to use, which is its most valuable aspect."
"The solution helps us perform with our databases and extract data."
"I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures."
"Support for enterprise-grade features like clustering, master-slave replication, even Sharding (to some extent) which is an advanced feature."
"It is a very stable solution. I deployed the product six years ago, and it still works fine."
"It's a mature solution that's been around for decades."
"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."
"LIke Teradata, we can’t add a node/SPU to the existing appliance."
"The only issue is that it's not expandable."
"We are not able to scale. The only way to scale is to get another appliance, but we have a customers who would need us to hydrate the data between the two appliances, and Netezza does not do that."
"The scalability is not as expected. The capacity in the black box is not enough."
"Concurrency limit needs to be increased somewhat."
"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."
"Our main problem with it is concurrency. When there are too many users running Netezza at the same time, this is when we have the most complaints."
"Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server."
"I am looking for the Temporal SQL feature, which basically means that there is complete history for each table. This feature is currently available in MariaDB. PostgreSQL has something called a foreign-data wrapper, which is another way to access external data from inside. MySQL could have a similar feature."
"The solution is expensive."
"The only service which could be improved is its usability. The entire user experience needs to be revamped to meet the 2018 design standards."
"MySQL could introduce more indexing strategies."
"The GUI interface probably can be improved. Let us say I want to see the relationships in the database. In the query analyzer, I would like to go and drop the tables and create relationships between the tables. I haven't found a feature like that in MySQL. It was a shortcoming even in SQL Server. MySQL can have more performance monitoring tools. I know Google has these tools, but within MySQL, there are not that many tools to monitor things like performance and database locking. They might be in there, and I might not be familiar enough to know where they are. I am a pretty new user of MySQL."
"The availability of tools could be improved in the MySQL open-source platform. They can provide more analytical tools. I haven't had any particularly difficult issues to troubleshoot on MySQL, but in the past, on Microsoft SQL Server, I had to troubleshoot some difficult issues, and better tools were in place to see what was going on in real-time on the server. So, that's the bit that is lacking on the MySQL open-source platform."
"The manuals or documentation could be better."
"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."
More IBM Netezza Performance Server Pricing and Cost Advice →
IBM Netezza Performance Server is ranked 10th in Data Warehouse with 33 reviews while MySQL is ranked 1st in Open Source Databases with 142 reviews. IBM Netezza Performance Server is rated 8.0, while MySQL is rated 8.2. The top reviewer of IBM Netezza Performance Server writes "A cost-effective data warehousing tool, but security features like TDE encryption are missing". On the other hand, the top reviewer of MySQL writes "Good beginner base but it should have better support for backups". IBM Netezza Performance Server is most compared with Oracle Exadata, Oracle Database, Teradata, Snowflake and Altibase, whereas MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, Teradata and SAP HANA.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.