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
(963)Attribute Ratings
Reviews
(1-3 of 3)Companies can't remove reviews or game the system. Here's why
April 16, 2021
MySQL--Best RDBMS
In my team, we are using MySQL as a relational database management system for internal software development projects. It helps us to store data in a well organized and systematic format, which, in return, results in better management, less utilization of resources, and time savings.
- Very easy and simple to learn and apply
- Robust and secure
- Compatible with almost all types of programming languages, like C#, Java, and PHP, which provides flexibility to deploy databases for different applications
- Not suitable for large data management
- User interface can be improved
- Support for non-relational data will be an added advantage
- Security updates are not that frequent
- Saves time with easy data management
- Cost efficient
- Easy to deploy and set up
- Query data
- Generate reports
- Create database
- Run procedures
No
December 19, 2018
A scalable and effecient database tool
MySQL is currently being used to compile and back up data being generated by our OCR software. It is specifically used within our team for this purpose and means we have a stable, scalable and structured environment for the data.
- 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.
- Allowed us to store data from letters accurately
- Allowed us to make better business decisions based on data
- Allowed us to work quicker and more effecient with a good tool
MySQL is much better. It is much more scalable.
- Database queries
- Data management
- Spinning up new DBs
Yes, but I don't use it
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!
- Project Setup Costs - As MySQL is under a GPL licence and for our project there we no licensing costs (you need to check you are covered for your project). This has a huge saving compared to using Oracle and other such heavy weights.
- Development Cycle - We found that MySQL was well suited for using it within Lean/Agile software development environments. Changes can be made quickly without being over complicated to implement and most of the time by an application DBA or a middleware developer.
- Cluster Design - To date we have had no DB outages (we are using a HA cluster design) and therefore lead to cash and end customers T2R processes have been 100% available.
Compared to Oracle MySQL is lacking some of the advanced features Oracle provides but through a detailed business and technical requirements capture process it became clear we would not need these very advanced features. Oracle is stronger on the backup and restore side of things and here I mean it does seem quicker using Oracle to import/export very large databases/indexes and partitions however we decide to live with the difference. All in all set up and ongoing costs was a significant factor in our decision to use MySQL.
Our business doesn't have significant SQL Server expertise and with the costs and limited choice of OS involved of using SQLServer we eliminated it at a very early stage.
Our business doesn't have significant SQL Server expertise and with the costs and limited choice of OS involved of using SQLServer we eliminated it at a very early stage.
- Installation - An out of the box installation takes just a few minutes.
- Statistics & Performance- Getting any really detailed performance stats e.g. IO, Memory Usage on how the database performs can be difficult and are not as well documented as say Oracle.
Yes
There isn't a mobile interface that ships with the DB but you can use a third party PHPmyAdmin. This gives the ability to manage the most important features of the DB (user management, export of data, running SQL queries, creating indexes etc).