Reliable and easy to use database
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, …
Overview
What is MySQL?
MySQL is a popular open-source relational and embedded database, now owned by Oracle.
Recent 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
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
Product Details
- About
- Integrations
- Competitors
- Tech Details
- FAQs
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 Competitors
MySQL Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
MySQL is a popular open-source relational and embedded database, now owned by Oracle.
Reviewers rate Usability highest, with a score of 10.
The most common users of MySQL are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(965)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.
We use MySQL as the database for all of our products and websites. We have two software as a service (SaaS) products that are set up using master/slave replication and several WordPress sites that also use MySQL as a backend. We're very happy with how easy it is to set up, configure and operate MySQL databases. We use the MySQL Community Edition.
- It's very dependable. I know how to get it running and keep it running. I don't have to worry about it going down in the middle of the night.
- For our needs it's fast. Every new version seems to run faster.
- Easy. MySQL has been around for a long time. There is a ton of documentation and tools to make using it effortless.
- Setting up replication takes some effort. It's not bad once you've done it, but I still need to reference the documentation every time I need to set up a new slave.
- Oracle owning MySQL means that they don't put everything into the community edition because they want to sell licenses to their commercial editions.
- Might not be the best performance at very large scales.
October 27, 2016
MySQL Why and Why Not
I have used MySQL for a long long time. I have used it as a student in college for my personal projects and for huge enterprise grade applications in corporate [settings]. The reason I strongly recommend MySQL over other databases is because it is open source, very very cheap and is well documented. It was an obvious choice as novice college developer then and as a seasoned developer now. It's pretty straight-forward to set up and use so it is ideal for projects with short deadlines. Also, it scales well too.
- Well supported by mostly all languages.
- Scales well IF it is configured properly. (A lot of people complain that it doesn't but it did quite well for most of the projects where we used it).
- Easy to get up and running. Setting it up is breeze and with lots of third party software, it has become even better.
- User management and administration is not as simple as it should be.
- Caching and partitioning could be an issue.
- Although it's possible to create PL/SQL procedures, it's not as good as other platforms such as Oracle.
- Poor documentation.
October 20, 2016
Cloud and MySQL Usability Review
We are managing software development tasks in the cloud. The unstructured data from various sources is converted to relational mysql tables that is later used in other apps. The apps usually prefer to use data in JSON format, and we have automated scripts to convert data from these mysql tables into JSON.
- Availability on the cloud.
- Our familiarity with relational, and SQL.
- Availability of guides and other learning resources on the internet to work with MySQL
- I am guessing that for larger enterprise projects, we would probably need a paid edition. Eventually the cost evaluation would help us evaluate the features.
October 07, 2016
MySQL Review
MySQL is being used by the whole organization. We store enterprise reporting data.
- Querying
- Reporting
- Performance
- Indexing of columns
- Big data support
October 05, 2016
Cheap and best db that people can use
This is used by my team for a dashboard that we created. Our whole organization was using Oracle and db2, but we started using this to create our own dashboard which will be shared with all the teams for monitoring purposes. This is very cheap and we didn't have to spend much on this and it's very easy to install and easy for us to troubleshoot issues.
- It's very easy to install and use. Once installed, we didn't have any issues and never had to reach out to our IT teams for support. The UI was very easy to use even for the first timer.
- We have some complex queries for the data in our dashboard and it used to take a lot of time. The dashboard had a lag in showing the data. After migrating to MySQL, data was loading much faster on the UI because of MySQL.
- There was an issue when using the MySQL UI and as most of the team is used to SQL developer, they pressed control and enter and it executed all the update statements that are there on that page instead of executing just that query, which is very annoying.
October 05, 2016
MySQL for the People
The choice to use MySQL was obvious because it was open source, easily accessible and free. I needed to deliver a web app that would target a small initial audience and scale to a wider audience in a short period of time. I could have chosen other offerings but I needed to deliver this app in a short delivery window. With the help of MySQL, I was able to meet that deadline and scale the app to thousands of users. While it was eventually replaced by another application, it always ran smoothly, and never went down. MySQL will always be my first database love.
- Quick deployment
- Ease of use
- Scalability
- Performance
- Full joins are not supported but you can emulate them
- No check constraints
October 04, 2016
MySQL review
We use MySQL for our music recommendation engines, zabbix monitoring backend database, batch job management for the QA team and automatic configuration management for OrderPath. MySQL is used by our operations and engineering departments. It is a great relational database choice and is free of license cost.
- Easy to set up.
- No heavy tuning needed.
- Master-slave gives high availability.
- Auto partitioning would be nice to have!
- Unified storage engine (so user doesn't need to study different options.).
- Stats report (similar to AWR in Oracle).
October 03, 2016
Humble opinion of MySQL
We use Mysql to hold our USD data. This data is used in our final product which queries that mysql database and computes our final response. MySql provides an easy and reliable source for holding data.
- Ease of use. Very easy to learn to use as well as retrieve that data you need.
- Cost. MySQL generally is cheaper than some of its competition.
- Reliable. MySQL is generally more reliable and faster than some of our NoSQL databases such as Hadoop or Hive.
- Can suffer for poor performance scaling. This doesn't effect us too much since the volume of data we store isn't too large.
- There are some limitations that can be frustrating, mainly in the diagnostics.
September 30, 2016
Best lightweight database without complicated adminisration tasks
I use MySQL for one of my projects as a lightweight database to capture and report data from several Excel files.
- I use sub-select to accomplish a complex query tasks.
- I also like text searching in MySQL better than Oracle.
- Updating data directly in the view is very convenient also.
- In-clause with multiple fields like in Oracle would be helpful.
- Full joins instead of left and right joins combined.
September 29, 2016
MySQL leverages application architecture and works well.
We use MySQL database as part of the integrated migration solution on the apps servers as part of migrating customer data from one billing solution to another billing solution. It is used in the client project on a customer side as part of an uprising migration framework. They were integrated with an Oracle Database at the backend to seamlessly ingest data and process and migrate millions of customers to the new transactional databases.
- MySQL is open source and can be easily integrated in the application layer without much hassle of managing a large relational database.
- MySQL performs well in the larger workload and provides multiple configurations for clustering and scalability.
- Monitoring capability for MySQL instances and ability to integrate in one centralized console like Netcool.
- Migrate MySQL database to Oracle - there may be room for improvement.
- Migrate Oracle Database to MySQL database - they may be room for improvement.
September 29, 2016
MYSQL Forever!
We have multiple projects as Masters students in Software Engineering at SJSU be in hackathons or academic projects. MySQL helps quickly deploy the database when the project demands relational schema and it's easy to use SQL queries and drivers help build high quality ACID DB instantaneously with a good DB design.
- Relational Schema
- Support for all major programming languages
- Open source
- The CLI can be more intuitive to the users.
September 29, 2016
MySQL review
In our area we have used it on individual desktops to do prototyping when creating an oracle database may be too time consuming or cost prohibitive.
- Rapid and easy deployment
- Easy administration
- Small footprint
- I would like to see it more closely mimic some Oracle syntax
- I would like it to more easily run as a completely in memory solution
September 29, 2016
MySQL is great, but you need the right professionals to do it right
MySQL is used in our software product, along with MongoDB. Our product manages customer's business files and emails. We use MySQL to store relational data. The product is an enterprise software for the Chinese market. The product has been marketed in China for over 3 years.
- Free.
- Easy to use.
- Easy to find professionals to support it.
- Tools for performance tuning.
- Support more data volumes.
- Professional services in Chinese market.
September 28, 2016
MySQL is tried and true
We use MySQL in a variety of ways both internal to Dewpoint and among our customers:
1. It is the backend utility database for a variety of tools such as Jira, Bugzilla, NoSQL tools, etc.
2. It is an application database for some web based applications.
3. It is a caching database used at local customer sites for larger applications.
4. It is a prototyping database during initial phases of development before deploying on a more expensive RDBMS such as Oracle or SQL Server.
MySQL represents a reliable and simple database that supports standard SQL with good tools and good integration points.
1. It is the backend utility database for a variety of tools such as Jira, Bugzilla, NoSQL tools, etc.
2. It is an application database for some web based applications.
3. It is a caching database used at local customer sites for larger applications.
4. It is a prototyping database during initial phases of development before deploying on a more expensive RDBMS such as Oracle or SQL Server.
MySQL represents a reliable and simple database that supports standard SQL with good tools and good integration points.
- It is incredibly simple to implement even across operating systems such as Windows and Linux.
- It is very easy to configure and manage. Setting parameters and memory profiles is very straightforward, backups are simple, and stopping, starting, and deploying are very easy.
- The different storage engines represent distinctive features sets and allow for flexible feature rich deployments within the same database.
- It follows the more extended name space used by products such as SQL Server and Sybase. This namespace is more flexible.
- MySQL simply doesn't scale as well as commercial databases. It seems to reach a performance plateau where you are then required to shard the data into different instances to get the performance you need.
- The stored procedure and programming language is too limited compared to TSQL or PL/SQL.
- Configuring the different storage engines is cumbersome to enable features like spatial queries. It would be helpful if all features could run out of the InnoDB storage engine.
- It lacks some of the higher end features of commercial databases such as flashback recovery, updateable views, etc.
September 23, 2016
MySQL, Consider it Seriously
We built a robust content management system with mysql with a web front end, a MAMP stack. Our design approach including writing computation-heavy parts of the application in procedures which worked very well. We used triggers to track changes and states of data points that moved between different languages and therefore had to be treated differently. We got a lot of mileage out of an open source platform. Overall, it performed very well.
- Shifting computations to the server-side and leveraging the power of the database engine made our application fast.
- Our mysql databases were stable.
- They were easy to manage in terms of user privileges, backups, etc.
- At the time we built the CMS, we banned subqueries because they were so slow, however, their performance has been improved since then.
August 25, 2016
MySQL really needs to be the database you use
A clustered MySQL instance is used as the data warehouse for a significantly large enough public ISP contract for a third party large UK phone company. This entire platform needs to be available 24/7 either to customer agents or the public for ordering services or reporting problems and MySQL is at the heart of this platform acting as the data warehouse. Equally we needed a data warehouse that could cope with the many hundreds of thousands it not millions of B2B daily transactions with up and down stream provisioning and billing systems. As always, startup and ongoing support costs are constantly questioned and using MySQL enabled us to keep these down.
- Help and Support - Being open sourced there is massive amount of help on the internet via a simple search. 99.99% of the time someone had exactly the same problem! - So this should help reduce, in a production environment, incident handling times . Likewise plenty of info for your development team to read up on to.
- Easy to Setup - Out of the box a simple MySQL environment is just a few clicks of an install shield! It will run on any modern laptop and you may want to install a companion Apache / Tomcat and PHP software to give your dev people their local dev environments.
- Scaleable - MySQL will scale to almost the largest data warehouses (assuming here you can a good db design and implementation). We have been using in a multi-node HA cluster with no problems.
- Management and Development Tools - There are a number of good quality software tools that provided admin and development work spaces features. MySQL Workbench and TOAD for MySQL are good examples.
- Software Cost - Depending upon what you are doing with MySQL the cost for the software licences will be nothing if your application is covered under the GPL licence. There will be technical support costs (if you choose to have these) but these are likely not to be as great as other DB platforms.
- Training - If you have development staff experienced in SQL then they should be able to pick MySQL up with little training. Administration isn't the headache much larger DBs come with.
- Works well with the following - Apache/Tomcat - Oracle Weblogic - JAVA, PHP, JSP, Perl.
- Hardware Cost - When comparing against Oracle we found the costs for a MySQL cluster were less than an Oracle cluster (either an Oracle RAC and defiantly EXADATA environment).
- Some of the bells and whistles of the larger DB solutions are missing. Examples of this include some types of table encryption, solutions like data vaulting, and utilisation of an entire disk for MySQL (not like some DBs that can do file/disk management instead of the OS e.g Oracles ASM). You will also find some types of index and certain forms of partitioning are missing. However you have to ask yourself how often you would use these features anyway!
- PL/SQL - It is now possible to use/create PL/SQL procedures in MySQL but in my opinion this isn't as mature in terms as programming structures as Oracle PL/SQL.
- Backups/Restore - Personally I am not a great fan of the backup/restore features built in to MySQL. I have found they can take a long long time to import/export a table with many many millions of rows of data.
- Table Fields - We have had problems with MySQL to store large binary files (e.g. images/video ) and they are some quirky gotchas covering 'fulltext' searches and indexes that you have to be aware of. These are minor but important and annoying if you want to do something you can't!
August 15, 2016
MySQL - The best solution to web and mobile app data
We're currently using MySQL across the whole organization. MySQL stores all company data from every data source.
- The facility to integrate to various programming languages. We use many diffrent programming languages to implement our business, so we had to choose a database solution that could support these programming languages, or at least the most of them. MySQL supports all programming languages used on our company and makes the integration very easy.
- The flexibility. MySQL is very flexible in many ways. As we have a lot of different data types and our service demands fast data processing, with MySQL we were able to configure it to optimize our process, and of course, customized it to do the best for our company according to our needs.
- With our experience, we felt the lack of a tool to make easier the administration of data in MySQL. The tools provided today are good, but very poor for some features and functions that demand some specificity or complexity.
August 15, 2016
MySQL: A class of its own
It is being used by several of our revenue generating products, so it is used by many teams but not the entire organization as we have other database technology that is used by other products. We like MySQL for reliability, fast data storage, scalability, querying and as a traditional database system. We use MySQL for high availability with replication.
- High availability. Replication is easy to set up and easy to troubleshoot.
- MySQL makes it easy to automate installations.
- There are great support tools available for MySQL.
- MySQL's user management leaves a lot to be desired. I wish it had some of the roles and features that competitors have.
- MySQL is on its way to support more and more NoSQL operations and products. I would like to see more of that.
August 05, 2016
MySQL
I have used MySQL in 2 jobs previously. We had multiple clients and we used MySQL as the database to support them. In addition to that, I use MySQL for some of my side projects as well. It does a pretty good job as a relational database.
- Secure - Provides solid security layers and protects sensitive data from intruders
- It's free or very inexpensive - Important for small companies.
- Memory efficient - I haven't run into cases where the server runs out of memory.
- Speed - It works well with big tables as well
- Scalability - MySQL becomes slow as read/write ratio on the database grows.
- Reliability - I have run into some stability issues. Could be a problem for certain use cases.
- Slow development - I haven't seen a lot of new releases in the last couple of years
August 01, 2016
Mysql is still the king of the Hill !
Mysql is being used across the while organization. MySQL is able to scale to our company's need, serving 10,000s of transactions per second. By adding slaves, we can quickly scale "reads" ; queries requiring to read only data vs adding data or updating / deleting existing ones.
- Replication: Setting up Mysql replication is fairly easy. Replication is robust and stable and with Mysql 5.7, new features will allow to take replication to another level. (Multi-source)
- Configuration: Mysql allows to configure some "variables" live without restarting the server.
- Scales: Mysql can scale pretty well if properly configured and architected in the application eco-system.
- Optimizing queries can be challenging. Having a tool to trace some queries could be useful.
- Roles: Adding support for user role would be useful. Currently done via "proxy" i believe but it seems a little tricky.
August 01, 2016
My database - MySQL!
Through an acquisition a company that used MySQL to store their data was added to our line of products. These new products continue to run on MySQL supporting very large data stores with high availability. We also have several third party and in house tools which utilize MySQL. These tools range from our production change tracking application to an Oracle supported 3rd party application with terabytes of data.
- Cost: MySQL is still available for free. If you have a server, you can set up a MySQL server quickly at no cost.
- Ease of use: Oracle, SQL Server, Vertica and other large players have a steep learning curve to administer. MySQL is less complex. For a quick and easy database, very little knowledge is needed. MySQL is mature and has a vast knowledge base. With the right people, MySQL can become a very scalable solution for many enterprise applications.
- Maturity: MySQL is a mature software package. It has been used on countless applications. It is a very popular pick for web applications as well as installed and SaaS applications. MySQL is clearly not a fad. It is a mature database offering.
- Clustering: MySQL does have some clustering options. None of these compare to RAC from Oracle. Each instance of MySQL requires its own data store, this can become costly. Further, in extremely heavy write environments, the replication between the servers can become backed up, this is a difficult problem to correct, and often severely impacts performance.
- Features: With money comes features. Big name databases such as Oracle and SQL Server have plan caching, robust partitioning, RAC(Oracle), robust optimization and support. Adding Oracle or even third party support to MySQL can be very expensive. This would put an enterprise in the position to consider Oracle or another solution.
- Misunderstanding: This is not necessarily a flaw in MySQL, however in my career I have seen a lot of it. MySQL is a complex database solution. It is not to be taken more lightly than other database products. A bad design from an inexperienced engineer can take a low cost start up application to a high cost emergency as it scales. Architecture, proper query writing, thoughtful indexing and design are paramount to the success of any application. MySQL is no different. I have seen many companies make the mistake of starting with inexperienced engineers and rush a product to market. This may be low cost, or in some cases no cost. When the product matures and volumes increase, problems, sometimes big present themselves.
July 15, 2016
MySQL Healthcare Review
We utilize MySQL to support Healthcare systems. We use it for various reasons. We can run queries to find missing patients. We can also run queries to just run daily or weekly reports for clients. It is an everyday use for our support team. We also use and export data to show to clients.
- Runs Fast
- No bugs
- Multiple Databases
- Some lagging time
- Slower while running multiple queries
- Nothing else
June 14, 2016
MySQL is a great and most inexpensive database but it lacks a bit when you need extra corporate functionalities
In our company MySQL is being used by the IT department/team. We are using the community version which is free and it fulfills our needs definitely. We do not need lot of database management or users for doing several things like administration, data modeling, and generating graphics and if we did the case I would go for MS SQL server. Together I enjoy performance of MySQL as it is faster to read and write operations.
- Performance is better as I found read and writer operations better than MS SQL.
- It is kind of an open-source so the community version is free.
- More companies are using MySQL.
- I think MySQL still has room to improve when comes to growing the read/write operation ratio.
- MySQL tools are not robust and good as the MS SQL management tool. It is probably because a lot of them are free.
- After Oracle owned this product, there have't been major improvements.
June 07, 2016
An era of MYSQL !!!
I started out using MySQL when I was first playing around with web applications that required a database back-end. It works well and is generally pretty fast. I've since switched to using PostgreSQL for most of my development, but I still use MySQL pretty heavily for a number of projects. Would definitely recommend either one as a free and powerful database server as needed, depending on your environment.
MySQL simply works and works well. It is exactly as described: a robust, relational DB which scales nicely to 100s of millions of rows. Plus, many web developers are.
MySQL simply works and works well. It is exactly as described: a robust, relational DB which scales nicely to 100s of millions of rows. Plus, many web developers are.
- MySQL is very easy to install, and thanks to a bevy of third-party tools that can be added to the database, setting up an implementation is a relatively simple task. In addition, it’s also an easy database to work with.
- The general apprehension was that Oracle would change the device into a shut, restrictive environment. Thankfully, however Oracle has fixed its hold on MySQL to some degree, it can even now be viewed as an open-source database choice, as the code is still accessible for nothing on the web.
- Despite the fact that MySQL's ubiquity has wound down to some degree as of late, it stays a standout amongst the most-utilized database frameworks as a part of the world.
- It Suffers From Relatively Poor Performance Scaling
- As anyone might expect, MySQL isn't intended to do everything (nor if it be). The database isn't completely SQL-consistent, and has a tendency to be restricted in ranges including information warehousing, adaptation to non-critical failure, and execution diagnostics (among others).
- MySQL does not support check constraints.
- MySQL does not support a very large database size as efficiently.
June 02, 2016
Reliable and cost effective
MySQL is being used in our organization for storing data in a relational model and also for metadata backends for various other types of operational software. MySQL is a great choice for us due to the simplicity of the environment, the ease of use, and the low cost to operate.
- MySQL is very easy to install.
- There are many third-party tools that can be added to the environment.
- Cost can be low for storing data.
- Scaling can become a problem and can affect performance.
- A basic version of MySQL doesn't come with partitioning.
- MySQL isn't 100% SQL-compliant, like SQL Server is.