TrustRadius: an HG Insights company

MySQL

Score8 out of 10

971 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

Who Buys & Uses MySQL

MySQL Reviews

What users are saying about MySQL.
View all MySQL reviews

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

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 database for Modern Enterprise Applications

Incentivized
Sharang DwivediView profile
Database Engineer in Information Technology at Infosys Ltd. (10,001+ employees employees)

Use Cases and Deployment Scope

For a customer onboarding web application, we have used MySQL database. For web application MySQL database had been preferred choice in the past which provides both open source and licensed feature. Among other reason MySQL DB is easy to setup , simpler feature set, fewer advanced features, but lightweight, stable, and fast for read-heavy workloads.

Pros

  • Performance of SQL read operations
  • Easy of setup
  • Open source
  • Very low license cost

Cons

  • Scalability options
  • Backup and Recovery options
  • Limited extensibility, fewer user-defined functions and plugins
  • Enterprise grade High Availability feature

Return on Investment

  • Cost saving due open source feature and low cost license
  • Need for enterprise edition for advanced features
  • Easy to setup in on prem or in cloud

Usability

Other Software Used

PostgreSQL, Oracle Database, Azure SQL Database, MongoDB

Best database in open-source

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

Use Cases and Deployment Scope

We use the MySQL database for applications like Confluence, Jira, and a few other Java-based applications. As it is Open source, we have also been using it for application development and testing purposes.
MySQL is a very lightweight database, which makes it faster and easier to manage and our applications run smoothly on the MySQL database.

Pros

  • As its open source, we can modify the code as per our need.
  • For developing and testing purposes, we can extensively use it without thinking about cost as its free to download
  • As it's lightweight, we don't have to worry much about resources like CPU, memory, etc.

Cons

  • As it's open source, there is a lack of support when it's required.
  • Its good for small scale applications, but for large scale operation, there still needs some improvements in feature and performance.
  • MySQL is not very suitable for OLTP and analytics-based applications.

Return on Investment

  • MySQL database is open source and freeware, so it saves a lot in IT revenue.
  • It's compatible with most Operating systems and applications, so we haven't encountered any compatibility issues so far.
  • With limited resources, MySQL has given high performance to our applications saving a lot on resource cost.

Usability

Alternatives Considered

Oracle Database and Microsoft SQL Server

Other Software Used

Oracle Database, Microsoft SQL Server, PostgreSQL

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