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.

Categories & Use Cases

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%

25,213 installations of 92,825

#2 most frequent

Information

14.5%

13,432 installations of 92,825

#3 most frequent

Manufacturing

8.1%

7,500 installations of 92,825

MySQL Reviews

What users are saying about MySQL.
View all MySQL reviews

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 Database Review

Incentivized
Manidipa KunduView profile
Data Analyst in Quality Assurance at Gfactors (11-50 employees employees)

Use Cases and Deployment Scope

We use MySQL mostly for relational data base system for our core data base related work. It work as a tool for storing structured data and many web services dependency on MySQL for retrieval and storage.Business problems we solve using MySQL includes data management and reporting ,Data warehousing and analytics.

Pros

  • MySQL usability is easier compare to other database.
  • MySQL supports many SQL features to handle light analytical workloads.
  • MySQL with the InnoDB storage provides full ACID compliance which is suitable for transactional systems where data integrity is critical.

Cons

  • For complex reporting or analytical queries it has limited advanced SQL features.
  • Weak JSON and NoSQL capabilities for applications that require flexible document storage.
  • partitioning challenges for horizontally scaling a massive database

Return on Investment

  • cost is low compare to other data base software.
  • Medium to High Negative ROI (for growing systems) for scaling limitations
  • Negative ROI due to hidden operational costs to backups, replication lag, failover setups.

Usability

Alternatives Considered

SQLite, MariaDB Platform and MongoDB

Other Software Used

SQLite, MariaDB Platform, MongoDB

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

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