What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
946 Ratings
188 Ratings

MySQL

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
946 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.6 out of 100
188 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Attribute Ratings

  • Amazon Redshift is rated higher in 2 areas: Likelihood to Recommend, Support Rating
  • MySQL and Amazon Redshift are tied in 1 area: Usability

Likelihood to Recommend

8.5

MySQL

85%
133 Ratings
9.3

Amazon Redshift

93%
34 Ratings

Likelihood to Renew

9.9

MySQL

99%
4 Ratings

Amazon Redshift

N/A
0 Ratings

Usability

10.0

MySQL

100%
6 Ratings
10.0

Amazon Redshift

100%
9 Ratings

Support Rating

8.6

MySQL

86%
4 Ratings
9.1

Amazon Redshift

91%
12 Ratings

Implementation Rating

8.0

MySQL

80%
2 Ratings

Amazon Redshift

N/A
0 Ratings

Contract Terms and Pricing Model

MySQL

N/A
0 Ratings
10.0

Amazon Redshift

100%
1 Rating

Likelihood to Recommend

Oracle

For smaller database backends, this product works well. Our backend printer management software is using MySQL as its backend and we have not had any issues since it went live 2 years ago. It's also free so no licensing worries.
Read full review

Amazon AWS

If the number of connections is expected to be low, but the amounts of data are large or projected to grow it is a good solutions especially if there is previous exposure to PostgreSQL. Speaking of Postgres, Redshift is based on several versions old releases of PostgreSQL so the developers would not be able to take advantage of some of the newer SQL language features. The queries need some fine-tuning still, indexing is not provided, but playing with sorting keys becomes necessary. Lastly, there is no notion of the Primary Key in Redshift so the business must be prepared to explain why duplication occurred (must be vigilant for)
Read full review

Pros

Oracle

  • Security: is embedded at each level in MySQL. Authentication mechanisms are in place for configuring user access and even service account access to applications. MySQL is secure enough under the hood to store your sensitive information. Also, additional plugins are available that sit on top of MySQL for even tighter security.
  • Widely adopted: MySQL is used across the industry and is trusted the most. Therefore, if you face any problems, simply Google it and you shall land in plenty of forums. This is a great relief as when you are in a need of help, you can find it right in your browser.
  • Lightweight application: MySQL is not a heavy application. However, the data you store in the database can get heavy with time, but as in the configuration and MySql application files, those are not very heavy and can easily be installed on legacy systems as well.
Read full review

Amazon AWS

  • [Amazon] Redshift has Distribution Keys. If you correctly define them on your tables, it improves Query performance. For instance, we can define Mapping/Meta-data tables with Distribution-All Key, so that it gets replicated across all the nodes, for fast joins and fast query results.
  • [Amazon] Redshift has Sort Keys. If you correctly define them on your tables along with above Distribution Keys, it further improves your Query performance. It also has Composite Sort Keys and Interleaved Sort Keys, to support various use cases
  • [Amazon] Redshift is forked out of PostgreSQL DB, and then AWS added "MPP" (Massively Parallel Processing) and "Column Oriented" concepts to it, to make it a powerful data store.
  • [Amazon] Redshift has "Analyze" operation that could be performed on tables, which will update the stats of the table in leader node. This is sort of a ledger about which data is stored in which node and which partition with in a node. Up to date stats improves Query performance.
Read full review

Cons

Oracle

  • Although you can add the data you require as more and more data is added, the fixity of it becomes more critical.
  • As the demand, size, and use of the system increase, you may also need to change or acquire more equipment on your servers, although this is an internal inconvenience for the company.
Read full review

Amazon AWS

  • We've experienced some problems with hanging queries on Redshift Spectrum/external tables. We've had to roll back to and old version of Redshift while we wait for AWS to provide a patch.
  • Redshift's dialect is most similar to that of PostgreSQL 8. It lacks many modern features and data types.
  • Constraints are not enforced. We must rely on other means to verify the integrity of transformed tables.
Read full review

Pricing Details

MySQL

Starting Price

Editions & Modules

MySQL editions and modules pricing
EditionModules

Footnotes

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    Amazon Redshift

    Starting Price

    $0 per hour

    Editions & Modules

    Amazon Redshift editions and modules pricing
    EditionModules
    Current Generation$0.25 - $13.041
    Previous Generation$0.25 - $4.082
    Redshift Spectrum$5.003
    Redshift Managed Storage$0.244

    Footnotes

    1. per hour
    2. per hour
    3. per terabyte of data scanned
    4. per GB per month

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    Likelihood to Renew

    Oracle

    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.
    Read full review

    Amazon AWS

    No answers on this topic

    Usability

    Oracle

    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.
    Read full review

    Amazon AWS

    Just very happy with the product, it fits our needs perfectly. Amazon pioneered the cloud and we have had a positive experience using RedShift. Really cool to be able to see your data housed and to be able to query and perform administrative tasks with ease.
    Read full review

    Support Rating

    Oracle

    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.
    Read full review

    Amazon AWS

    The support was great and helped us in a timely fashion. We did use a lot of online forums as well, but the official documentation was an ongoing one, and it did take more time for us to look through it. We would have probably chosen a competitor product had it not been for the great support
    Read full review

    Implementation Rating

    Oracle

    1. Estimate your data size. 2. Test, test, and test.
    Read full review

    Amazon AWS

    No answers on this topic

    Alternatives Considered

    Oracle

    MongoDB is an application oriented solution with unstructured data. Percona Server for MySQL is a good solution when looking for performance peaks and the amount of data grows continuously over time. MySQL is the ideal solution when we have a data schema defined and we do not have great requirements at the performance level.
    Read full review

    Amazon AWS

    Than Vertica: Redshift is cheaper and AWS integrated (which was a plus because the whole company was on AWS).
    Than BigQuery: Redshift has a standard SQL interface, though recently I heard good things about BigQuery and would try it out again.
    Than Hive: Hive is great if you are in the PB+ range, but latencies tend to be much slower than Redshift and it is not suited for ad-hoc applications.
    Read full review

    Contract Terms and Pricing Model

    Oracle

    No answers on this topic

    Amazon AWS

    Redshift is relatively cheaper tool but since the pricing is dynamic, there is always a risk of exceeding the cost. Since most of our team is using it as self serve and there is no continuous tracking by a dedicated team, it really needs time & effort on analyst's side to know how much it is going to cost.
    Read full review

    Return on Investment

    Oracle

    • It has made site management through a CMS like WordPress or Drupal infinitely easier to manage.
    • It is a critical part of the LAMP, WAMP and MAMP stack and has been a major driver of innovation in the content-management-system space, pushing site and web-application development toward greater democratization.
    • It has proved to be very reliable and easy to set up and administer and saves me tremendous time troubleshooting query and performance issues.
    Read full review

    Amazon AWS

    • Our company is moving to the AWS infrastructure, and in this context moving the warehouse environments to Redshift sounds logical regardless of the cost.
    • Development organizations have to operate in the Dev/Ops mode where they build and support their apps at the same time.
    • Hard to estimate the overall ROI of moving to Redshift from my position. However, running Redshift seems to be inexpensive compared to all the licensing and hardware costs we had on our RDBMS platform before Redshift.
    Read full review

    Add comparison