TrustRadius: an HG Insights company

MySQL

Score8.3 out of 10

991 Reviews and Ratings

Get a Demo

What is MySQL?

MySQL is a popular open-source relational and embedded database, now owned by Oracle.

Read more details.

Categories & Use Cases

Videos

Most Frequent Users

Top 3 industries using MySQL.
Based on HG Insights installation data
Powered by
View all Reviews
#1 most frequent

Professional, Scientific, and Technical Services

27.2%

24,900 installations of 91,686

#2 most frequent

Information

14.5%

13,284 installations of 91,686

#3 most frequent

Manufacturing

8.0%

7,378 installations of 91,686

MySQL Reviews

What users are saying about MySQL.
View all MySQL reviews

Pros

  • Ease of setup and user-friendly interface for querying and implementation
  • Strong performance for read-heavy operations and large data volumes, aided by B-tree indexing
  • Cost-effectiveness due to its open-source nature and low licensing costs

Cons

  • Limited support for advanced SQL features, hindering complex reporting
  • Challenges with horizontal scalability for massive databases and complex applications
  • Potential for slow performance with complex joins and full table scans

Data consistency with MySQL

Incentivized
Verified User
Consultant in Information Technology (10,001+ employees employees)

Use Cases and Deployment Scope

I use MySQL as a core relational database management system to support a variety of business-critical applications. We leverage MySQL for both internal and customer-facing systems, including web applications, reporting dashboards, content management systems, and data pipelines. Its reliability, performance, and open-source nature make it a strong fit for many of our workloads.

Pros

  • Scalability
  • Data consistency
  • Reporting
  • Rapid development

Cons

  • Intégration with AI

Return on Investment

  • Cost
  • Easy to deploy
  • Easy to admin

Usability

Alternatives Considered

EDB Postgres Advanced Server

Other Software Used

3Cloud, AWS Backup, AWS CloudTrail

MySQL is our reliable database choice.

Incentivized
Verified User
Engineer in Research & Development (501-1000 employees employees)

Use Cases and Deployment Scope

MySQL is important to critical aspect of my organizations software product experience. It helps us with transaction management, account data management , know your customer verification documentations and auditing trails etc
Overall, MySQLas our RDBMS of choice for key applications goes beyond merely being a backend infrastructure tool, it helps shape a trustworthy and reliable experience for users of our products.

Pros

  • Strong Query performance as a result of its B-tree indexing capabilities.
  • MySQL functions with minimal maintenance
  • Large and active user community.
  • Proven ACID ( atomicity, consistency , isolation , durability ) compliance.

Cons

  • Limited JSON capabilities.
  • Basic text search capability.
  • Slow with complex joins and full table scans.

Return on Investment

  • For an organization like mine, it is always our goal to prevent financial data corruption situations whereby someone makes a transfer and the money doesn't get to the destination, meanwhile their cards have been debited. MySQL being ACID compliant eliminates this prospect.
  • Building with MySQL ensures that we are able to iterate features faster because it is a well known ecosystem, where we have easy access to an abundance of documentation , developers , libraries etc
  • MySQL is cost efficient because it is open source.

Usability

Other Software Used

Slack, GitLab, Atlassian Jira

MySQL Shines In The Right Situations

Incentivized
Verified User
Strategist in Information Technology (1001-5000 employees employees)

Use Cases and Deployment Scope

We use MySQL to run the database back end of our company websites and a handful of OLTP applications. It provides a lightweight relational database system that is easy to manage and low in cost. Because we use the free version, support can be iffy, but, generally, it just runs without issue.

Pros

  • Read heavy operations
  • Simple setup
  • Cross-platform support
  • Large community
  • Cloud integration

Cons

  • Write heavy workloads
  • Horizontal scalability
  • Analytic workloads
  • Lack of advanced features

Return on Investment

  • No-cost back end for our websites
  • Linux experience for DBAs

Usability

Alternatives Considered

Microsoft SQL Server, IDERA SQL Diagnostic Manager for SQL Server, MongoDB, MongoDB Atlas, MySQL and Redis Software

Other Software Used

Microsoft SQL Server, MongoDB, MongoDB Atlas, Redis Software

Exactly what I expected from a SQL database

Incentivized
Verified User
Employee in Research & Development (51-200 employees employees)

Use Cases and Deployment Scope

Our proprietary CRM software uses MySQL as one of the databases. Its relational capabilities allow us to maintain data coherently even on a large scale, and making it possible to create the complex representation that is a customer and all the relative data about addresses, billing, preferences and so on.

Pros

  • Connect several data through relations
  • Keep data coherent with constraint
  • Fast searches through indexes

Cons

  • Error debug: it's hard to track down problems with deadlocks or timeouts
  • Parameters: it's not always easy to understand what values should database parameters have
  • Storage and memory: indexes occupy a lot of data, and some searches require the DB to have a lot of memory to prevent out of memory errors

Usability

Alternatives Considered

Oracle Database, MongoDB, Google Cloud Datastore and PostgreSQL

Other Software Used

Google Cloud Datastore, Oracle Database, MongoDB

The RDBMS you are searching for

Incentivized
Verified User
Employee in Information Technology (5001-10,000 employees employees)

Use Cases and Deployment Scope

MYSQL is used as a backend database for multiple inhouse products . Its used to store data ranging from 5 G to 2TB in multiple environments such as DEV ,QA and staging . It can easily handle any amount of data and processes it very fast . We also use to test some security related items .

Pros

  • Ease of Setup
  • Minimal Administration
  • Query Execution is decent
  • Can handle large data sets

Cons

  • Concurrency Control
  • Parelle execution capabilities are limited

Return on Investment

  • Using Community can be great , running into issues causes problems
  • Oracle provides its enterprise version which can avoid this
  • A great product when your datasets are smaller and less concurrent users

Usability

Alternatives Considered

Microsoft SQL Server

Other Software Used

Percona Server for MySQL, VMware vSphere, SAP Adaptive Server Enterprise (ASE)

MySQL Alternatives

Products similar to MySQL that may also meet your needs.
View all MySQL alternatives
Microsoft Access
CompareLearn more
Amazon Redshift
CompareLearn more
Google Cloud SQL
CompareLearn more