What users are saying about

1010data

5 Ratings

MySQL

Top Rated
593 Ratings

1010data

5 Ratings
Score 4.7 out of 101

MySQL

Top Rated
593 Ratings
Score 8 out of 101

Add comparison

Likelihood to Recommend

1010data

The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.

MySQL

MySQL is fantastic for those who just want to dip their toes in the water, as well as those Olympic style swimmers who are much more advanced. It is extremely flexible and there is a ton of support out there due to its increased popularity as a BI tool. I would definitely recommend using another BI tool that could integrate several MySQL databases together to avoid any lag times with reporting.

Pros

  • Crunches huge datasets
  • Has versatility in functionality and grouping capabilities
  • Native XML macro language is easy to master
  • The platform has great visualization tools
  • Help and Support - Being open sourced there is massive amount of help on the internet via a simple search. 99.99% of the time someone had exactly the same problem! - So this should help reduce, in a production environment, incident handling times . Likewise plenty of info for your development team to read up on to.
  • Easy to Setup - Out of the box a simple MySQL environment is just a few clicks of an install shield! It will run on any modern laptop and you may want to install a companion Apache / Tomcat and PHP software to give your dev people their local dev environments.
  • Scaleable - MySQL will scale to almost the largest data warehouses (assuming here you can a good db design and implementation). We have been using in a multi-node HA cluster with no problems.
  • Management and Development Tools - There are a number of good quality software tools that provided admin and development work spaces features. MySQL Workbench and TOAD for MySQL are good examples.
  • Software Cost - Depending upon what you are doing with MySQL the cost for the software licences will be nothing if your application is covered under the GPL licence. There will be technical support costs (if you choose to have these) but these are likely not to be as great as other DB platforms.
  • Training - If you have development staff experienced in SQL then they should be able to pick MySQL up with little training. Administration isn't the headache much larger DBs come with.
  • Works well with the following - Apache/TomCat - Oracle Weblogic - JAVA, PHP, JSP, Perl.
  • Hardware Cost - When comparing against Oracle we found the costs for a MySQL cluster were less than an Oracle cluster (either an Oracle RAC and defiantly EXADATA environment).

Cons

  • The ten.do interface could use more detailed documentation
  • Some of the bells and whistles of the larger DB solutions are missing. Examples of this include some types of table encryption, solutions like data vaulting, and utilisation of an entire disk for MySQL (not like some DBs that can do file/disk management instead of the OS e.g Oracles ASM). You will also find some types of index and certain forms of partitioning are missing. However you have to ask yourself how often you would use these features anyway!
  • PL/SQL - It is now possible to use/create PL/SQL procedures in MySQL but in my opinion this isn't as mature in terms as programming structures as Oracle PL/SQL.
  • Backups/Restore - Personally I am not a great fan of the backup/restore features built in to MySQL. I have found they can take a long long time to import/export a table with many many millions of rows of data.
  • Table Fields - We have had problems with MySQL to store large binary files (e.g. images/video ) and they are some quirky gotchas covering 'fulltext' searches and indexes that you have to be aware of. These are minor but important and annoying if you want to do something you can't!

Likelihood to Renew

No score
No answers yet
No answers on this topic
MySQL9.1
Based on 2 answers
For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
MySQL8.2
Based on 2 answers
You can use MySQL for TOAD or MySQL Workbench for a nice GUI experience.

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
Compared to Oracle MySQL is lacking some of the advanced features Oracle provides but through a detailed business and technical requirements capture process it became clear we would not need these very advanced features. Oracle is stronger on the backup and restore side of things and here I mean it does seem quicker using Oracle to import/export very large databases/indexes and partitions however we decide to live with the difference. All in all set up and ongoing costs was a significant factor in our decision to use MySQL.Our business doesn't have significant SQL Server expertise and with the costs and limited choice of OS involved of using SQLServer we eliminated it at a very early stage.

Return on Investment

  • This has sped up the process of analysis.
  • We can now automate process which were performed manually.
  • Analysis can be performed more frequently.
  • Moving to MySQL 5.6 has allowed us to see a near 35% increase in database throughput and I/O operations
  • By clustering our MySQL instance, we're able to increase the performance of the entire system substantially--it should scale to (potentially) a petabyte level as our business grows
  • The lack of great support for UDFs and window functions has meant our development time has increased slightly when needing to extract data from MySQL

Pricing Details

1010data

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

MySQL

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details