What users are saying about
Top Rated
150 Ratings
Top Rated
836 Ratings
Top Rated
150 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.7 out of 100
Top Rated
836 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100

Likelihood to Recommend

Elasticsearch

Elasticsearch's best use case is when you want to store loosely-structured data and be able to search for it near-instantly. And you want to do that in a highly tolerant distributed system. My company doesn't use it this way but I've heard of other companies using ES to store system logs. Another company uses it to store giant store-catalogs.
Anonymous | TrustRadius Reviewer

MySQL

  • It is a suitable database for web applications where we have a large size of users. It is also easily scalable and provides good user management and access controls at the security level.
  • MySQL is a very fast database to read when using the non-transactional MyISAM engine, but it can cause integrity problems in high-concurrency environments when modifying. Thus, for applications with many parallel transactions and modifications, MySQL is probably not the best solution
Jose Manuel Ortega | TrustRadius Reviewer

Pros

Elasticsearch

  • Super-fast search on millions of documents. We've got over 2 billion documents in our index and the retrieve speeds are still in the < 1-second range.
  • Analytics on top of your search. If you organize your data appropriately, Elasticsearch can serve as a distributed OLAP system
  • Elasticsearch is great for geographic data as well, including searching and filtering with geojson, and a variety of geospatial algorithms.
Anatoly Geyfman | TrustRadius Reviewer

MySQL

  • The Community Server edition remains a strong candidate for a SQL-based database solution that supports a wide array of data structures.
  • It scales well for both small business and enterprise use.
  • It performs very well provided your database schema is well-planned and carefully considered (which is the case for any database solution).
  • It has a number of interface solutions including GUI-based ones such as phpMyAdmin and MySQL Workbench that allow for easy management of your databases.
Joel Tanzi | TrustRadius Reviewer

Cons

Elasticsearch

  • Setting Java memory thresholds can be a pain for those not accustomed to things like Eden Space & Old Generation which can lead to over allocation, or more likely, under allocation. Apache Solr had a similar issue. It would be nice if the program would take an extra step and dogfood it's own advice by analyzing the system & processes to return a solid recommendation for that configuration. The proper configuration information is outlined in the documentation, it would be nice if that was automated.
  • The only health check that ElasticSearch reports back is a "red" status without any real solid information about what is going on, though its usually memory thresholds or disk I/O. I am currently on ElasticSearch 1.5 so that may have changed for newer versions. When the status goes "red", I as the administrator of the software, feel like I lose control of whats going on which should rarely happen. Something more verbose would eliminate that.
  • This is more of a critique of the ElasticStack in general. The whole top to bottom stack is starting to get feature creep with things that are better suited in other software and increasing the barrier for entry for people to get started with setting up a robust logging infrastructure. ElasticSearch as a storage search engine, is pretty streamlined, but I can see that the tools that comprise the ELK Stack are going to require a certification with constant study at some point. During major release for Logstash a while back, it literally took a month to learn a new language because Elastic completely changed the syntax. For a medium sized organization of only a couple of admins, that is a pretty high bar where time is money. They really should work on refining/automating the tools & search engine they have, instead of shoehorning/changing things on to an already rock solid foundation.
Colby Shores | TrustRadius Reviewer

MySQL

  • MySQL doesn't provide good data wrangling functionalities, such as parsing JSON or XML. We had to transform them outside MySQL on the web application server side using JSP.
  • As we move forward to adopt more genomics information, MySQL may lack of dealing with "big data" functionalities.
  • It is a freely available S/W and easy to manage budget, but there are possibilities to spend cost for additional technical support.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Elasticsearch

Elasticsearch 10.0
Based on 1 answer
We're pretty heavily invested in ElasticSearch at this point, and there aren't any obvious negatives that would make us reconsider this decision.
Aaron Gussman | TrustRadius Reviewer

MySQL

MySQL 9.9
Based on 4 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.
Anonymous | TrustRadius Reviewer

Usability

Elasticsearch

Elasticsearch 10.0
Based on 1 answer
To get started with Elasticsearch, you don't have to get very involved in configuring what really is an incredibly complex system under the hood. You simply install the package, run the service, and you're immediately able to begin using it. You don't need to learn any sort of query language to add data to Elasticsearch or perform some basic searching.If you're used to any sort of RESTful API, getting started with Elasticsearch is a breeze. If you've never interacted with a RESTful API directly, the journey may be a little more bumpy. Overall, though, it's incredibly simple to use for what it's doing under the covers.
Anonymous | TrustRadius Reviewer

MySQL

MySQL 8.2
Based on 5 answers
I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.
Kenneth Hess | TrustRadius Reviewer

Support Rating

Elasticsearch

Elasticsearch 7.5
Based on 12 answers
We've only used it as an opensource tooling. We did not purchase any additional support to roll out the elasticsearch software. When rolling out the application on our platform we've used the documentation which was available online. During our test phases we did not experience any bugs or issues so we did not rely on support at all.
Anonymous | TrustRadius Reviewer

MySQL

MySQL 8.6
Based on 2 answers
The support staff is friendly, knowledgeable, and efficient. I only had to get part way through my explanations before they had a solution. They will walk you through a fix or actually connect in and fix the problem for you--or would if you can allow it. I've done it both ways with them. They are always forthcoming with 'how to do this if it happens again' information. I love working with MySQL support.
Kenneth Hess | TrustRadius Reviewer

Implementation Rating

Elasticsearch

Elasticsearch 9.0
Based on 1 answer
Do not mix data and master roles. Dedicate at least 3 nodes just for Master
Anonymous | TrustRadius Reviewer

MySQL

MySQL 8.0
Based on 1 answer
1. Estimate your data size.2. Test, test, and test.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Elasticsearch

As far as we are concerned, Elasticsearch is the gold standard and we have barely evaluated any alternatives. You could consider it an alternative to a relational or NoSQL database, so in cases where those suffice, you don't need Elasticsearch. But if you want powerful text-based search capabilities across large data sets, Elasticsearch is the way to go.
Anonymous | TrustRadius Reviewer

MySQL

After Oracle bought MySQL, I have pivoted some projects to use MariaDB instead, which is a fork of MySQL and maintained by the community and original developers of MySQL. This is free under the GNU GPL, and is not impacted by decisions Oracle makes for MySQL. RDS has the ability to run managed MySQL instances which make it even easier to setup and configure a database. RDS also has support for MariaDB.InfluxDB is a great Time Series DB Platform which was designed to collect measurements with timestamps, and works more efficiently than MySQL for this type of data. I would recommend InfluxDB for anyone who is on the fence about implementing a collection agent and having the stats go into MySQL or another Database system
Anonymous | TrustRadius Reviewer

Return on Investment

Elasticsearch

  • Faster searches on our application have resulted in better usability and increased application use
  • Analytics dashboard has given our managers a better understanding of day-to-day activities
  • Being a backup data store, we need not touch SQL database while doing data dumps for local data science projects
Swastik Nath | TrustRadius Reviewer

MySQL

  • Since MySQL is a free database package, if you have someone on staff that understands databases and how to use them, the ROI is very high when using MySQL.
  • If you need to hire a MySQL developer to implement and manage your database then it can be quite costly to manage and that will negatively impact your ROI when using this product.
  • Since there are some very expensive alternatives in the SQL database space, if you compare the overall costs of using MySQL to those other products, I think you will find your ROI is always better when using MySQL
Andrew Shannon | TrustRadius Reviewer

Pricing Details

Elasticsearch

General

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

Elasticsearch Editions & Modules

Edition
Standard$16.001
Gold$19.001
Platinum$22.001
EnterpriseContact Sales
  1. per month
Additional Pricing Details

MySQL

General

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

MySQL Editions & Modules

Additional Pricing Details

Add comparison