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
(964)Attribute Ratings
Reviews
(76-100 of 134)Companies can't remove reviews or game the system. Here's why
December 19, 2018
A scalable and effecient database tool
- A strong and scalable environment. This is key for our use case as each application requires it's own database and a set of tables that are unique to the application. As we have 5 applications in 7 months, we need to easily scale up the project which MySQL is great for.
- A good community of users readily available online. We are able to look up any issues we may have quite quickly.
- It employs a simple coding language that is almost conversational in some instances and this allows for any new developer to pick up the tool with ease. Whilst it's simple, the language allows you to do in depth queries with ease.
- Easier walkthroughs for the reporting tools. We've had some difficulty building up reports from the databases, in order to regularly feedback to the business and there has been little assistance available.
- Setting up a new database can be cumbersome at times, particularly when we want very similar standard tables in each instance, and creating these from scratch has slowed down work a little.
- The ability to save a project in its entirety. We run individual queries across a range of different databases and we have had difficulty grouping these together as a single reusable project in order for us to implement in each new application.
December 19, 2018
MySQL provides a fast and free database to get you started
- MySQL is installed and deployed easily across just about any operating system, allowing for great flexibility in choice of platform
- MySQL is open-source allowing for constant improvement by the community and by individuals looking to adjust how the system works
- MySQL is easy to understand and includes multiple functions and keywords not found in enterprise databases
- MySQL Stored Procedures are lacking in comparison to MSSQL Stored Procedures
- Support for free MySQL is reliant on the community to provide answers and support
December 19, 2018
MySQL Stable and Performant Open-Source Relational DB - Perfect For Early Stage Companies
- Open-Source. Free! So you can have as many instances of MySQL setup as possible
- Large community. MySQL has been around for a very long time, so there's tons of documentation and forums on how to do things and how to fix specific questions.
- Many integrations. Because MySQL is so popular, there are integrations everywhere. For instance I was working with Columnar databases (Redshift, Infobright) and the supported backend engines were MySQL (not MSSQL, Oracle, Postgres, etc.)
- Slow releases. It generally takes several years for new releases to come out, which means less new features.
- Inferior IDE's. Toad, MySQL Workbench, etc. are okay, but some of the IDE's for other SQL Languages (ie: Microsoft SQL Management Studio) have more built in functionalities and are much easier to use
- Harder to scale than older database technologies. It requires some serious engineering effort to scale, whereas this is much easier in a NoSQL database like MongoDB and in some other DB types like Postgres.
December 19, 2018
A great entry to mid level RDBMS
- Rapid deployment and easy management. Getting a database up and running quickly and a low cost of maintenance is essential to adoption.
- Supports standard SQL queries and is supported by many of the standard SQL database frameworks such as SQLAlchemy.
- Supports advanced features such as replication and clustering, allowing the system to scale with need.
- MySQL's ACID compliance is acceptable, but could be better. Competing applications such as PostgreSQL do a better job with this.
- Development has slowed considerably since being acquired by Oracle. MariaDB, a forked version of MySQL, is much more active.
- Replication works, but often ends up out of sync. Clustering works much better.
December 19, 2018
MySQL is an old trusted friend that is always there for you
- We use PHP for our applications and the integration between MySQL and PHP is seamless.
- MySQL has a lot of great documentation to help solve easy and more challenging problems.
- The open source community developing and maintaining MySQL does an awesome job.
- As more and more things move to big data / noSQL, it would be nice to see more of the functionality from those solutions find a place within MySQL
- It may considered antiquated because of some of the other big data / no sql solutions that are available.
November 19, 2018
You get so much for $0.00
- Easy to set up.
- Fairly lightweight.
- Covers a large spectrum of use cases - from data security to database connectivity to much more.
- Can be a bit dodgy to use when highly scaled.
- Offers very few data types to work with.
- The UI occasionally crashes when trying to kill a complex query (esp with nested queries).
November 13, 2018
MySQL is an RDBMS for all seasons and all reasons
Score 9 out of 10
Vetted Review
Verified User
- MySQL can take data from a lot of different sources and import it into a Relational table.
- MySQL is fast and uses very few resources on the host system.
- It is a robust RDBMS that has an almost unlimited number of applications.
- In case you need support, MySQL is owned by Oracle so you can get support for your production systems.
- MySQL has a huge user community behind it and a lot of questions and answers have been published about it.
- MySQL is always improving through active development but needs to add on more enterprise features such as scalability tools and features.
- Some users report problems with stored procedures and triggers.
- Some users report that transactions aren't handled efficiently.
November 06, 2018
MySQL Review
- Simple to develop
- Powerful enough
- Perfromance Scaling
October 26, 2018
Quick MySQL StandUp & Testing!
- Quick SQL Database standup
- PoC Testing outside of EDW
- Easy to use and implement free standing of our full enterprise environment.
- None
October 26, 2018
MySQL is MySQL, none of your SQL
- Ease of language
- Dynamic in terms of different data types
- Efficient for pulling large data
- Integration with other tools is easy
- Easy to write queries
- Integration is easy with other systems
- It’s highly scalable
October 26, 2018
MySQL is my dream
- This is a very good relational database and very fast database.
- Easy to maintain
- Very easy to learn and develop use cases using this.
- Very good for storing metrics data.
- It can be improved to store time series data
- Joins are very heavy and not easy to troubleshoot
- Should have catching concepts
October 24, 2018
software engineer
- MySQL has the structured data that is organized into a table that is easy to manage
- Everyone is familiar with the syntax
- Performance is very good
- Need to support unstructured data
- Need ability to scale
October 24, 2018
Want to know why MySQL?
- Quick processing. MySQL always ensure optimum speeds, and unique memory caches for enhanced performance.
- Reliability. It has features like consistent, isolated, durable transaction support. It also guarantees instant deadlock identification.
- Flexibility of use. It makes maintenance, debugging and updates fast and easy while also enhancing user experience.
- Does not really support larger databases as efficiently as smaller ones. When the data grows, only the simple and indexed query gets good performance, however, a complex query gets comparatively slow, even sometimes unable to fulfill the request.
- A few stability issues. There have been some cases when MySQL works perfectly fine for 1-2 weeks and then it just suddenly crashes.
- Poor performance scaling. SQL does not support auto sharding, so you may need to maintain your nodes manually.
October 22, 2018
Reliability for free
Score 7 out of 10
Vetted Review
Verified User
- The price is just right for small to medium enterprises and startups since it is free
- The software has a lot of functionality
- It can be integrated to work with other products
- It takes a while for the user to get to do incremental backups for the software
- It lacks inbuilt support for XML
- The relational databases need some work done work
August 08, 2018
Great simplicity
- It is open source and easily available
- MySQL went from 4 CPU threads to 64 CPU threads, which doubled the number of concurrent connections
- The simplicity in use and startup is great.
- MySQL 5.6, split one of the crucial locks in the MySQL Server, the LOCK_open, which improved the top performance.
- Big users for example Linux are moving to MariaDB which does not look good on MySQL
- There are no patches being released or public roadmaps provided for it.
- You may spend a lot of time and effort to get MySQL to do things that other systems do automatically, like create incremental backups.
June 15, 2018
The pros definitely outweigh the cons!
- Perfect for organisation and analysing data
- Easy to install and use - very user-friendly interface
- Easily understood documentation and great for having everything arranged in one place.
- Doesn't support ARRAY and other more detailed data types.
- It can be quite slow at times if it's processing large amounts of data.
- The user help guides could be more indepth.
- Easy to create dynamic queries and complex procedures.
- Creating indexes on a large amount of data is very easy as it provides suggestions in the SQL server tool.
- It always provides best query performance with joins.
- It takes time to create indexes on the table if we have a large amount of data.
- Crashing problem when we forcefully cancel the running query.
- It does not handle the undefined exception even if we have specified try-catch blocks.
March 19, 2018
Easy to store relational data.
- Easy to add joins on tables.
- Easy to keep records of every user.
- Protection from an unauthorised user as we have to provide a valid username and password while logging into SQL DB.
- It should create indexes automatically if a table has a large amount of data.
- It should add a feature so that we can restrict access to a particular table from a database.
- Need improvement in query performance.
February 14, 2018
MySQL, your SQL, everybody's SQL!
- Ease of use since this is basically a sort of "starter" tool to get database management going.
- Low cost - Instead of going in semi-blind and spending a lot of money on a BI solution that you are not sure about, you can try the Community version of MySQL and see if it fits your needs.
- Data tool integration is phenomenal and allows for companies to expand their databases into other programs that provide more robust capabilities as well as handling more data as the company grows.
- Independently, MySQL can be tough to use with large datasets. It becomes increasingly slower with the more data you are working with. So unless you are using another database management tool, it can take a while.
- Before the recent upgrades, MySQL took a while to integrate features such as JSON into it. The responsiveness needs to be much quicker to keep up with the increasing demand.
December 12, 2017
MySQL as a teaching foundation
- Good foundation of SQL language
- Good foundation of relational database
- Good foundation of database design
- Free and easy to use
- Plenty of external help documentation [is] not available
- Easier to understand the downloading procedures and where to find certain things, especially for a Mac.
- Speedy System
- Independent Platform
- Mass Data Manipulation
- Above Average Support
- As the platform is adopted more strongly, we fear it may lose speed capabilities
- Search function is great for full text, however not much else
November 01, 2017
MySQL, best zero dollars you'll ever spend
- MySQL is very easy to setup and use. You can create a new MySQL instance in a matter of minutes.
- MySQL comes with a great set of tools out of the box that make database administration as easy as possible. Everything from creating or restoring backups to setting up remote server replication is doable with the built in tools.
- MySQL is highly configurable and can be easily tuned to suit the individual needs of the user.
- Because MySQL is so highly configurable, there is a bit of a learning curve when getting started. Getting setup is easy but research into the different storage engines and tuning parameters is required to make MySQL really efficient for your business needs.
- MySQL uses some non standard SQL syntax by default that can take some getting used to.
- Some SQL standards are implemented in very non standard ways so that tasks are able to be accomplished but the statements created for the task don't translate well to other RDBMS.
October 18, 2017
Nice UX/ Nice UI - In General Good Software
- Easy UX
- Smart UI
- Has a habit of freezing up requiring a restart.
- Glitches sometimes and doesn't save the work that you've put into the system.
- Easy automated backups.
- Size of backups are very manageable.
- Performs well on servers that have not had a lot of money invested in them.
- Reliable performance.
- Upgrading to newer versions of MySQL was sometimes challenging.
- Communication with online backup server stopped working and is pretty complicated to set up.
- Lots of the UI is very basic and limited.
March 30, 2017
Works well for small projects
- It is simple to install and manage
- It's battle tested, many applications are using it.
- The problem with its split to MariaDB broke part of its community
- Some types of data are not consistent, the database does not enforce some kinds of data
- It lacks some formats, like json for exeple