Skip to main content
TrustRadius
MySQL

MySQL

Overview

What is MySQL?

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

Read more
Recent Reviews

Reliable and easy to use database

9 out of 10
November 20, 2023
It is solving the problem of efficient processing of a decent amount of data sets. Before that, all data was stored in an Excel sheet, …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons
Verified User
Director in Professional Services
Information Technology & Services Company, 51-200 employees
Verified User
Engineer in Engineering
Information Technology & Services Company, 11-50 employees
Return to navigation

Product Demos

E-Commerce Website using PHP and MySQL || Project Demo || Part -1

YouTube

Small CRM Project using PHP and MySQL (Free Download)

YouTube

User Registration Form with PHP and MySQL Tutorial 5 - Add Form Validation + Final Demo

YouTube

MySQL database WinForms CRUD Demo. (CREATE,READ,SELECT,UPDATE,DELETE) | C#

YouTube

MySQL Enterprise Edition [Newer Version Available]

YouTube

C# MySQL database WinForms CRUD Demo. (CREATE,READ,SELECT,UPDATE,DELETE)

YouTube
View more demos
Return to navigation

Product Details

What is MySQL?

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

MySQL Videos

What is MySQL?
MySQL is one of the most popular database software options for businesses of all sizes. The software is open source, and highly customizable, so users can set up an instance that meets their needs.
While MySQL is a specific product, NoSQL is a type of database that includes a number of available products. Whether a NoSQL (nonrelational database) product or using MySQL (relational database) is right for you greatly depends on the data you are storing, queries, and flexibility.

MySQL Integrations

MySQL Competitors

MySQL Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

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

Microsoft Access, Google Cloud SQL, and Amazon Redshift are common alternatives for MySQL.

Reviewers rate Usability highest, with a score of 10.

The most common users of MySQL are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(964)

Attribute Ratings

Reviews

(101-125 of 134)
Companies can't remove reviews or game the system. Here's why
February 14, 2017

Easy to set up, maintain, and use. Can't beat MySQL.

Andrew Shell | TrustRadius Reviewer
Andrew Shell
Co-Founder and Chief Technology Officer
Pinpoint Software, Inc. (Internet, 1-10 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
MySQL is my go-to database for all of my PHP applications. I'm not sure how well it's supported in other environments. It would seem a lot of Python apps use PostgreSQL but I found it difficult to configure. If you're deploying a small to medium size app I doubt you could go wrong with MySQL. It's available in most shared hosting environments and all the big open source CMSs support it (WordPress, Drupal, Joomla).
October 27, 2016

MySQL Why and Why Not

Verified User
Engineer in Other
Consumer Services Company, 10,001+ employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
MySQL is a good choice for small and medium scale companies and indie developers. Especially if you are running tight in terms of resources and budget and deadlines. It's easy to set up and get started too. However, for a big organisation, it might not scale well if it's not properly configured. Besides, the administration and user management could be a huge issue if you are a large firm with lot of users accessing the database.
October 05, 2016

Cheap and best db that people can use

Ajay Akunuri | TrustRadius Reviewer
Ajay Akunuri
Production Support Engineer
Macys.com (Retail, 1001-5000 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
This is very useful when we need it for a small project and it's easy to use and manage. This is cheap as well. There are not many options in data manipulations as compared to Oracle. If it is for a big organization, I feel Oracle is better.
October 05, 2016

MySQL for the People

Kevin Dimond | TrustRadius Reviewer
Kevin Dimond
Business Programs Manager, IBM Cloud, Bluemix
IBM (Information Technology and Services, 10,001+ employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
If you need to provide a working prototype quickly, MySQL is the first database I grab. If you need to build a small and efficient web appilcation, MySQL is the first choice. Further considerations must be made if you have large or epic installations that you are attempting to build. However, with that said, MySQL can handle just about anything you throw at it, if it's configured properly and your deployment is well thought out.
October 04, 2016

MySQL review

YL
Yucheng Liu
Sr DBA
Rhapsody International (Music, 51-200 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
I would say MySQL is good for small companies who can not afford an Oracle license cost. For high transaction and high availability usage, you'll need very sharp mysql dbas and developers - the eventual cost may not be cheap. You get what you paid for. That's all!
September 30, 2016

Best lightweight database without complicated adminisration tasks

Ali Ozkabak | TrustRadius Reviewer
Ali Ozkabak
Senior Informatics Engineer
Exelixis (Biotechnology, 51-200 employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
I prefer to use MySQL in smaller well controlled data sets both insert/update and selecting data for my reports. Works very well for me. However, in cases where there is a transactional data with large volume of data, it seems to cause performance issues for me.
September 29, 2016

MySQL leverages application architecture and works well.

Verified User
Professional in Information Technology
Telecommunications Company, 10,001+ employees
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
From my experience, MySQL is suited well for a database that can be easily embedded in the application layer and also for databases that are read-only replicas. They are not well suited for an application that runs or requires complex queries with multiple table joins and explain plans. They are not very robust compared to an Oracle Cost Based optimizer.
September 29, 2016

MySQL is great, but you need the right professionals to do it right

Steve Fan | TrustRadius Reviewer
Steve Fan
Co-Founder, VP & CTO
Y7 Technologies Ltd (Computer Software, 51-200 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
MySQL is an excellent alternative for Oracle database. The architects need to be aware of what to be stored in MySQL. MySQL is not proper for storing un-relational data. However, combining MySQL and NoSQL, creates great solutions for common problems. MySQL needs to be used properly to be effective.
September 28, 2016

MySQL is tried and true

Christopher Weiss | TrustRadius Reviewer
Christopher Weiss
Chief Architect
Dewpoint (Information Technology and Services, 201-500 employees)
Score 8 out of 10
Vetted Review
ResellerIncentivized
Likelihood to Recommend
MySQL works extremely well for small to mid sized web applications using open source stacks like LAMP or Java. The integrations are strong and the administration works out extremely well. MySQL is indispensable as a tools database. You can see this in its consistent usage in this capacity for over 15 years. I would not use MySQL for a large complex enterprise systems with terabyte databases and complex deployments.
September 23, 2016

MySQL, Consider it Seriously

Lyn Liberty | TrustRadius Reviewer
Lyn Liberty
Principal Software Engineer
Smart Destinations Inc. (Retail, 10,001+ employees)
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It really depends on type of project, of course. We had a problem as a team finding contractors to hire who were both familiar with mysql and more advanced database features and data modeling. Since it's open source and free to use, it suffers from being the go-to for very rudimentary application. In addition, I've seen some very idiosyncratic programming with mysql from developers obviously unaware of best practices in ETL and data modeling. With a properly skilled development team, however, you can really get a lot of value from mysql.
August 25, 2016

MySQL really needs to be the database you use

Verified User
Manager in Information Technology
Telecommunications Company, 10,001+ employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend

MySQL is suited to a huge array of individuals and companies of all sizes and who have large and small budgets. It provides a very quick, install and get up and working solution without a massive learning curve for most day to day projects. If you have staff with Oracle/SQLServer skills they will pick MySQL up quickly. It can't do some of the things Oracle and alike can do but for 99% of your projects MySQL should be a serious consideration.

MySQL is indeed suited to being the backend behind web based portals and you will find a number of third party web applications are optimised for MySQL. It is also works magically being called from Spring Web Flow either directly via JDBC or via a Hibernate layer.

Features - You may find MySQL fits your needs on day one of your project but at some point you need a feature that isn't available. So be careful you may find that your cheap setup costs are negated and cost more if you have to change your DB solution at some point.

August 15, 2016

MySQL - The best solution to web and mobile app data

Carlos Eduardo | TrustRadius Reviewer
Carlos Eduardo
CEO (Chief Executive Officer)
Techood Mobile (Information Technology and Services, 1-10 employees)
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
In our experience, in addition to the traditional use of MySQL, it also very well suited to store and process web and online services data. We demand a lot of data processing from web and from our mobile services. MySQL has the perfect fit to supply our business demands and needs.
August 15, 2016

MySQL: A class of its own

Verified User
Professional in Information Technology
Information Technology and Services Company, 51-200 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
It's easy to use, and readily available. It's mostly open sourced although community driven development is not accepted which makes some changes slower. Scalability for high reads/writes is an issue. It's simple and fast. MySQL lacks container types, arrays and true sequence (it uses auto-increment instead). It has several storage backends that can be used as add-ons. MySQL is ACID compliant when used with the InnoDB storage engine.
August 05, 2016

MySQL

Verified User
Engineer in Engineering
Computer Software Company, 51-200 employees
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
If you are a small company and want to get started quickly, MySQL is a pretty good choice. Once you grow past a certain point, scalability becomes an issue and it's time to look at other options. There's plenty of expertise available in market and lot of community support for MySQL.
August 01, 2016

Mysql is still the king of the Hill !

Franck Leveneur | TrustRadius Reviewer
Franck Leveneur
Sr. Mysql DBA
ZipRecruiter (Internet, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
Mysql is well suited for large scale transactional environments. A clear example is a recent post from an Uber engineer who switched from Postgres to Mysql. The fact that Facebook uses Mysql speaks for itself.
FullText search is weak on Mysql, this is understandable as the amount of data we deal with today are in the GB.
ES, Sphix, or Solr are better choices for searching text.
Mysql can scale for data warehouse up to a certain limit and certain type of queries.
ColumnStore architecture is the way to go : RedShift, SnowFLake, MemSQL, and MariaDB Beta of ColumnStore are better choices.
August 01, 2016

My database - MySQL!

Patrick Parkhill | TrustRadius Reviewer
Patrick Parkhill
Advisory Systems Engineer Database Administration
Syniverse (Telecommunications, 1001-5000 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
MySQL is a great database for web applications, cloud applications, and really any application. It has a great feature set and is easy to launch and get off the ground. It gives individuals a chance to explore a database at little or no cost. It gives companies that would otherwise not be able to afford Oracle a chance to start. MySQL is a great relational database solution. It is the M in LAMP, which essentially creates an instant web based application.

MySQL can start to struggle with extreme writes. Vertica, Oracle and other platforms seem to handle these somewhat better.
June 14, 2016

MySQL is a great and most inexpensive database but it lacks a bit when you need extra corporate functionalities

Verified User
Engineer in Information Technology
Entertainment Company, 11-50 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
In my opinion, MySQL is well suited when you need worry less about a database and worry more about service. It is a great database when comes to cost since it is inexpensive or free (community version). But when it comes to various kinds of tasks such as generating reports, graphs, models, etc., I think MS SQL stands in a better place as it feels easier.
June 07, 2016

An era of MYSQL !!!

Verified User
Engineer in Engineering
Computer Software Company, 51-200 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend

High Availablity:

Rock-strong unwavering quality and steady accessibility are signs of MySQL, with clients depending on MySQL to ensure all day and all night uptime. MySQL offers an assortment of high-accessibility alternatives from fast ace/slave replication setups, to particular Cluster servers offering moment failover, to outsider merchants offering remarkable high-accessibility answers for the MySQL database server.

Open Source full support:

Numerous partnerships are reluctant to completely resolve to open source programming since they trust they can't get the kind of backing or expert administration security nets they at present depend on with exclusive programming to guarantee the general accomplishment of their key applications. The inquiries of repayment come up regularly also.

High Performance:

An exceptional storage engine design permits database experts to arrange the MySQL database server particularly for specific applications, with the finished result being stunning execution results.

June 02, 2016

Reliable and cost effective

Verified User
Engineer in Information Technology
Internet Company, 201-500 employees
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Likelihood to Recommend
My SQL is well suited for business type applications. In most business, you'll need a some type of area to store operational type data along with metadata. MySQL is a perfect tool for this. Areas where MySQL is less suited are in areas such as data warehousing, geographic applications, GIS data, or logging a high amount of traffic.
Return to navigation