MySQL Valuable Features
Patryk Golabek
CTO at Translucent Computing Inc
I treat these products kind of as a throwaway versus what a DBA would be. From an organizational point of view, it's difficult to actually define the most valuable features because we have so many different databases. For some of them, Postgres for example, which uses MySQL, is just personal preference with is no real difference. Unless you get to really high volumes or through-putting. So in our case, because of legacy reasons, we started using MySQL, which was a popular database. It's not a bad database, so there was no reason for us to change it to the Postgres. We do use Postgres right now for other tools, but for a main database for application purposes, we still stick to MySQL. And I think it's just because of legacy, there's no real advantage of one over the other right now.
We built up the scripts already. Because once you start integrating the scripts into your company, your deployment scripts, test scripts, etc. you just leave it over time because it takes effort to change. But in terms of advantages or features, you can go feature by feature with any database and if you add up the totals, there's no real advantage here between Postgres or MySQL.
View full review »
Prince Raju
Lead Data Analyst at Ernst & Young
Code is easy to write and code, it's easy to understand. That's why it's widely used. The queries are very easy to understand and [write the] code. For coding, it's very easy.
View full review »
Alireza-Nikseresht
CEO at Shiraz University
MySQL is an open-source product and has good community support. If you encounter any problem, you can easily ask other members of the community to help. They help you a lot. On top of being free, MySQL is a cross-platform database, meaning it can work on both Windows and Linux. It is very good for us.
View full review »Buyer's Guide
MySQL
April 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,740 professionals have used our research since 2012.
Guruprasad Gonjare
Director Cloud Architecture at LTIMINDTREE
Compared to other databases, MySQL is cheaper and we used the community edition which was free of cost. ML is fully integrated with the database in HeatWave. It also has many other features. MySQL is a far better solution in terms of pricing.
View full review »
CharlesBrewer
Managing Director at NaMax Limited
For starters, it's free, which is always nice, and it's also pretty straightforward to use. It's a nice conventional database. We don't need the sort of flexibility that you get with most SQL databases and stuff like that, so we are happy with a good old-fashioned relational database. It's totally good for that.
It works. It's reliable. We haven't done any configuration management for probably about two years, but as far as I remember, that was pretty straightforward as well. It's doing what it needs to do as far as we're concerned.
View full review »
Mohini Kushwaha
RPA Developer at Dimiour India Private Limitied
MySQL's most significant attribute is its capability to create, modify, and maintain databases. This is crucial and advantageous in procedures, such as SOAR. Therefore, all SQL functions are beneficial to any backend developer or developer who requires data storage.
The solution is easy to use and the user interface has worked well in my usage.
View full review »
PrinceKumar2
Associate Cloud Engineer at Rishabh Software
- Ease of Use: MySQL is relatively easy to set up, configure, and manage, especially with tools like MySQL Workbench and command-line utilities. Its widespread popularity also means there is ample documentation, tutorials, and community support available for users.
- Open Source and Cost-effective: MySQL is open-source software, which means it is free to use and can be customized according to specific requirements. This makes it a cost-effective choice for startups, small businesses, and projects with budget constraints.
RU
Ravi Upadhyayula
Senior Consultant at Tata Consultancy
While MySQL offers strong basic functionality.
View full review »
Ruhul Amin
Executive Officer at Midland Bank Plc
The installation process for the most scalable solution is remarkably quick, taking only a short amount of time. While restoration may theoretically take longer, I've achieved rapid setup with my system, often within a minute.
View full review »
Deepak Sahu
Consultant at Dell Technologies
MySQL can handle multiple rules of a database within seconds and extract required information for the business case, especially with well-optimized queries.
View full review »
Kevin Honde
Data Solution Architect at Econet Wireless Zimbabwe
The feature I found most valuable was the cluster setup.
View full review »GG
reviewer1432350
Computer & Information Systems Manager at a real estate/law firm with 51-200 employees
I like the simplistic view of MySQL to build custom queries and things like that as compared to SQL Server, which seems more cluttered.
SQL Server has a query analyzer. MySQL pretty much does the same, and performance-wise, it has less overhead for connecting to our ERP system. It seems more responsive and cleaner. With MySQL, you get what you need without any overbloating, for which Microsoft is known. That's why they have so many constant security patches for everything because there is so much stuff, which degrades performance.
View full review »
Prince Barai
Back End Developer at Agnos Inc.
MySQL is an easy-to-use solution that provides stability, reliability, flexibility, performance, security, and high availability.
View full review »
Shivaprasad C S
Programmer at Ministry of Interior
I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures.
View full review »
Serge Dahdouh
CEO at Les Roches International School of Hotel Management
MySQL is easy and convenient for me. I don't need to rely on anyone. I can write the code and extract the information. It is fast if you know how to use it. The solution is not expensive, and most of the developers know how to use it. It is easy to create tables. The solution is stable and has good performance. The connection with AWS gives regular updates, which is manual otherwise and a nightmare.
View full review »AB
reviewer2089122
Associate Consultant at a computer software company with 501-1,000 employees
The solution helps us perform with our databases and extract data.
The solution is free.
View full review »
PeterKrall
Freelance Software Engineer + Director of a company at Peter Krall Consulting
My main reason for using MySQL for this small customer database company and for some kinds of scientific projects was that I had to do the installation myself. I didn't have a database administration team behind me. Therefore, I was looking for something very easy to handle. MySQL is easy to install, connect, and do all such things.
View full review »JK
James Kulundu
Data Analyst at KPMG East Africa
SKIP LOCKED is a valuable feature. It prevents us from deleting things we put in the database. It's mostly for background jobs in the software development site in MySQL 8. It is a new feature. The solution easily integrates with other tools and systems in our IT environment.
View full review »
Philippe Liénard
CEO at csm
Maher Shahzalal
Backend developer at Alphatraduction
The relations in the database, the dynamic workflow, and the ability to connect with all columns. It's useful for e-commerce.
View full review »
Ahmed-Ramy
CEO at TMentors
We use it for different projects, mainly when we have lots of data and the customer can't afford to pay the license of SQL Server, which is not a cheap one.
That's the main reason you use MySQL or Postgres or other databases. It's less expensive.
The solution is stable.
The scalability is very good.
It's a mature solution that's been around for decades.
It is very easy to set up the product.
Egzon Maloku
Senior Pantheon ERP Implementer & Head of Accounting at Datalab
I like MySQL's feature that helps to automate things.
View full review »SG
Satishbabu Gunukula, Oracle ACE
Works
MySQL is a relational database and it is easy to install, handle day-to-day activities, and manage backups. It is compatible with a lot of other shared database solutions.
MySQL Workbench is the graphical user interface tool and it helps with development, data modeling, data migration, and day-to-day administration.
MySQL has cross-platform support for multiple operating systems. The backups on a Linux machine can be restored on a Windows machine, and vice versa.
MySQL supports multiple window displays and it is useful for developers and users who don’t have much database knowledge.
View full review »CG
CharlesGuise-Brown
Clinical Data Management Principal at Vertex-in-Healthcare
We are completely comfortable with the database’s performance and it is a mature product. My organization was looking for an open-source database for our smaller customers like the community edition. For bigger customers, we can scale into commercial and supported editions.
View full review »CN
reviewer937698
Principal Software Engineer at a manufacturing company with 1,001-5,000 employees
It is free, which is probably its most valuable feature. It is a pretty full-featured relational database. It really does everything we need it to do.
View full review »
Anand Viswanath
Project Manager at Unimity Solutions
The optimized process is valuable. I have seen websites that take ages to load and show the data. Many web applications with lakhs and lakhs of data will take forever to show specific results. The database performance is optimal for the application we developed. The speed is very good. There were no delays in fetching data from the back end and showing it on the front end.
View full review »AJ
Amos Babatunde Jayesimi
Officer IT data processing at Stanbic Bank Ghana, Ltd.
The solution has all the essential features. We can manipulate bulk data, clean up data, divide it into compartments, and optimize it.
View full review »ND
reviewer1456815
Specialist Geosciences Data Consultant at a energy/utilities company with 10,001+ employees
The most valuable component for me is SQL Developer. It is pretty simple to use and I don't have anything really bad to say about it. It supports multiple window displays and all of the connections are available. A lot of people use Toad for this type of work, but I have not myself.
The functionality that I use most often is querying the data model.
View full review »
it_user253797
IT Consultant, Business Owner, Lecturer at a tech consulting company with 10,001+ employees
MySQL is an Open Source RDBMS, which means you keep your costs low, as long as you don’t need to have support and/or you have your own MySQL expert. However, MySQL also offers the enterprise edition for users that would like support and more advanced features.
When it comes to features, MySQL offers all the features of a RDBMS system, including monitoring tools, backup and recovery, high availability and easy migration from other databases.
View full review »
Marco Ismael González Rangel
Solutions Architect at Teravision Technologies
The most valuable feature of MySQL is auto-scaling.
View full review »
Caroline Bentolila
Process Automation Analyst at Stone
The most valuable feature of MySQL is its reliability and performance.
NM
reviewer1378032
Database Engineer at a retailer with 10,001+ employees
MySQL is open-source. There are a lot of open-source communities trying to come up with their own patches, and to come up with their own features, which help MySQL develop faster than traditional databases like Oracle, which is closed source.
The solution is also compatible with a lot of other databases, like Percona, and it's compatible with MariaDB. It's also compatible with a lot of other shared database solutions.
Since MySQL is mostly used as a relational database in a lot of organizations, a lot of other solutions are being merged with MySQL and it's a rather easy process.
Unlike a lot of closed source services, the new features are solely based on customer feedback. The customer feedback of open source is way larger than the closed source application.
View full review »AG
Arief Gunawan
Product manager at Metrodata Electronics Tbk PT
The one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support. Therefore, for a senior level product like MySQL it is different than a product like MariaDB or MongoDB which are also open source databases but they depend on the community for support.
People just assume it is less expensive. The product is not expensive. But they also have a strong principle behind data backup and supporting that product. That's why it's quite interesting, because it's open source but it has a principle behind it.
View full review »it_user448206
Senior Application Programmer/Analyst, Team Lead at a university with 10,001+ employees
MySQL’s strength is in its fast connection, query and insert performance. I’ve benchmarked MySQL against several NoSQL and SQL databases and found it to be faster for getting lots of data inserted quickly.
View full review »
Ismail Yushaw
Supervisor at GGoC1
The most valuable feature of the solution stems from the fact that it helps me to get my work done. I am more interested in getting my work done than any feature it comes with since, as long as it gets my work done, it can actually help me achieve my objectives.
AV
Andre Visser
Technical Director at Metrofibre Networx
The use of MySQL is really dictated by the software we use. So we have put software that dictates the use of MySQL and MongoDB. We think we've found the goal of the company related to strengthening its business systems.
View full review »
Milton Palacin
Solution Architect at SBS
The feature I found most valuable is activity performance.
View full review »AM
Ariful Mondal
Global Data Architecture and Data Science Director at FH
It's a good tool, a good database platform. Everything you can do, you can do for free.
I like that it's open-source and that it's free.
View full review »
JohnMitchell
jmitchell@natbankmw.com at NBM
The solution is very simple. It's easy to use. That's the most important feature.
We do have it supported by various programs we run with it.
View full review »SJ
reviewer936300
Director Of Sales Marketing at a energy/utilities company with 10,001+ employees
The solution is very stable.
The scalability has been great.
The deployment process is pretty fast.
View full review »
Anays Micolod
Programmeuse Python 3 at Université Grenoble Alpes
The easy access to the data and the ability to sort the data with multiple methods are very valuable features.
It's quite easy to grasp and is really well documented, which are huge plus points.
View full review »PA
reviewer1769190
Software Engineer at a financial services firm with 10,001+ employees
MySQL is easy to use, has fast performance, and it is comfortable for end-user to use. The schema level and structure we are using are very simple and easy to understand. Additionally, packaging tool development is straightforward and the data is presented in a way that is very simple to understand.
View full review »LK
Lawrence Katuruza
Systems Administrator at Dairibord
One of the most valuable features is MySQL's ability to run our email system. We use a system called Colab.
View full review »Kevin Honde
Data Solution Architect at Econet Wireless Zimbabwe
It's our database due to the fact that it's cheaper and is actually free to use.
The product is very easy to use, yes.
It's quite stable.
The solution is very compatible with many versions of Linux. Most of Linux is free, so it's easy to implement with MySQL. Whether it's Ubuntu, CentOS, or different types of Linux, it's the same across other operating systems, and therefore it's very easy to use and compatible with any demand that comes from developers. At the end of the day, MySQL is compatible with most of the platforms.
The solution has been very easy to scale so far.
The installation process is very easy.
View full review »AC
goforitandy
IT Consultant at Woohoogeeks
The Cross-platform support for MySQL is great, as you don't need to worry about which platform or operating system you need to install the platform. This allows for interoperability.
Like other databases, it has a rich set of functions, such as stored procedures and its own procedural language, which is akin to Oracle SQL. It also has trigger and cursor commands you would expect with a good database language.
Views are updateable, which is useful when you need to amend a specific view of data for different circumstances.
It has it's own Data Definition Language (DDL), and provides an Information Schema, to view what is "under the bonnet" of your database.
View full review »
Waqar Malik
System Analyst at National University of Sciences and Technology
The tool is open-source and there is no cost involved in its use.
View full review »
Ertugrul Akbas
Manager at ANET
MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses.
MySQL advantages and valuable points include:
- MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
- MySQL uses a standard form of the well-known SQL data language.
- MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, Java, etc.
- MySQL works very quickly and works well, even with large datasets.
- MySQL is very friendly to PHP and Java at the same time. Both PHP and Java are our development languages.
AM
ARJUNMarya
Enterprise Architect at a computer software company with 1,001-5,000 employees
MySQL's clustering features are very strong, and you can automate scripting, so that helps. We wrote a Terraform script and ran it.
PJ
reviewer1461639
Deputy Director General at a computer software company with 1,001-5,000 employees
It is very easy to install and has all basic database features.
View full review »RP
Rehana Parvin
Database Administrator at a recruiting/HR firm with 1,001-5,000 employees
The EER diagram is the most important feature for me as the EER diagram can show the inner picture of the database, such as the relationship between the tables very easily. We can also add, modify or delete EER diagrams very easily.
View full review »
Tapas Karmakar
Oracle Technology Artchitect and Specialist at Wizertech Informatics Pvt. Ltd.
The IO segregation in CGE is valuable.
View full review »AR
reviewer1620885
Vice President & Head of IT Governance at a financial services firm with 1,001-5,000 employees
The solution is great for small applications in particular.
The performance is good.
The solution originally was designed as an open-source product. It has a community edition that anyone can use for free.
The initial setup is simple and straightforward.
View full review »DB
Deepak Bansal
Founder at Art World Web Solutions
The connectivity with PHP is quite good.
It is easy to integrate, and the fees are less than Oracle and other services.
View full review »HE
Haitham Elwany
IT Infrastructure & Data Platform Sr. Manager at a financial services firm with 1,001-5,000 employees
The performance is great.
This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge.
View full review »it_user304758
Powerbuilder Consultant at a government with 1,001-5,000 employees
- Relational database (Although it's not 100% compliant with Standard SQL)
- Performance
- Open Source
- Ease of setup and use
- Ease of use with PHP, Python, and Java
LM
LeonMofor
Ingénieur Etude et Développement / Technical Lead Java at ATOS
Mysql is free : it's an open source project, so you can use it with no cost.
Mysql is well documented, and has a big community.
MySQL adheres to the current SQL standard, although with significant restrictions and a large number of extensions. Through the configuration setting sql-mode you can make the MySQL server behave for the most part compatibly with others like IBM DB/2 and Oracle.
There are a number of convenient user interfaces for administering a MySQL server.
MySQL has supported the storing and processing of two-dimensional geographical data. Thus MySQL is well suited for geographic information systems applications.
MySQL supports the ODBC interface.
For client programming you can use, among others, the languages C#, C, C++, Java, Perl, PHP and Python.
KV
Karel Van Der Walt
Data Architect at ACPAS Loan Management Software
Table partitioning is most valuable. It is easy to use.
View full review »MM
Muhammad Nurazhan Moin
Senior Web Manager at a university with 501-1,000 employees
- Open-source
- Multi-platform
- Lightweight
- Simple to set up, configure and tune
- Support for enterprise-grade features like clustering, master-slave replication, even Sharding (to some extent) which is an advanced feature
SN
SaifNan
Director at BAB
The product is flexible and easy to use.
View full review »PE
reviewer1621470
Lead Project Manager, Owner at a tech services company with 11-50 employees
The feature that I have found most valuable is its ubiquity. MySQL is everywhere, so if I need to find a developer to do things to it that I don't know, it's very easy to find someone who has expertise in it.
View full review »ZG
ZelalemGedefie
Senior System Administrator at Debre Markos University
I am totally satisfied with MySQL. I like its performance, ease of use, stability and scalability.
OK
OmidKoushki
Solution Architect at KIAN company
When comparing MySQL to other solutions it is easier to use and boots up faster. Additionally, when you want to query a lot of data, MySQL is better in performance.
View full review »HP
Hetul Patel
Senior Data Analyst at Charutarhealth Org
The replication feature is the most valuable. We are replicating our servers.
View full review »AR
AlmiroRocha
Information Technology Infrastructure Manager at a comms service provider with 201-500 employees
MySQL gives us all of the critical features that we need in a database, but without the costs.
The most valuable feature is that we can implement clustered solutions.
View full review »HT
Haim Tzadok
Co-Founder/CEO at Grigale LTD
This depends on my customers' use.
View full review »it_user231711
Telecommunications Engineer at a comms service provider with 1,001-5,000 employees
- SQL Merge
- Replication
- Views
- Stored Procedures
- Triggers
- Cursors
This is just like the enterprise grade Oracle DB. MySQL now supports replication (master-master or master-slave) of our DB to support our company's multiple geo-locations and PoPs.
It supports the original Oracle SQL operations such as Merge, as well as the creation of Views to your tables. This brings additional convenience to our organization.
View full review »it_user178848
Engineer with 51-200 employees
- Speed
- Cost
VC
reviewer938061
Sr. Solution Architect at a computer software company with 5,001-10,000 employees
The solution is easy to use. As the query patterns are very similar to SQL, this simplifies the use and understanding of the solution.
View full review »YT
YongSheng-Tang
Unemployed (previous role was Solutions Specialist, System Integration)
SQL is just a relational database. It is open source. It's pretty good. I have been using it for a long time.
View full review »PN
PareshNayak
Oracle Cloud Infra Architect at Wipro Limited
It has a lot of features. The RDBMS, consistency, and multi-user features are valuable.
View full review »MW
Mac Wang
Project Manager at Realnux
This solution is very easy to use. It's stable and very quick. MySQL is a light database. It's not very complex. It's easy to develop, easy to maintain, and easy to back up and restore.
View full review »HC
Hector Cuna
Sysad Database Administrator Lead at USSC
It has a community version. When I have to create a new database, I have no problems with licenses.
RS
reviewer1252344
COO at a tech vendor with 1-10 employees
All of the databases basically have the same set of features.
What I've been most pleased with is the cost point, performance, and ease of use.
It is very easy to configure, it's easy to deploy, and it's cross-platform capabilities are quite nice.
View full review »it_user578346
Head of Business Technology at a tech services company with 501-1,000 employees
The large user base and the amount of available plugins and modules. A lot of the software components have been trialed and tested for often more than 10 years. It is rock solid from that viewpoint.
View full review »
Ruben Conti
Owner at Intersoftware sas
MySQL is easy to integrate. It works with just about every language.
View full review »IR
reviewer1392807
Manager at a tech services company with 51-200 employees
MySQL has a lot of documentation, and bug fixing is better in the latest version.
View full review »it_user1282806
Infrastructure Platform Engineer at a cloud provider with 51-200 employees
The solution is free to use, which is its most valuable aspect.
The interface is quite good.
The stability and scalability are very good.
Overall, it's an excellent solution. We don't have to implement anything else.
View full review »it_user702249
Web Developer at a tech services company with 201-500 employees
MySQL is strongly recommended for web applications and LAMP architecture systems. The most valuable feature of this product for me is its graphical interface which allows me to do the database administration easily. Another important feature is its reliability, the decent performance, and the fact it is an open source product.
View full review »CR
reviewer1650315
Senior Java Developer at a computer software company with 11-50 employees
I like the JSON stuff.
View full review »it_user242553
Academic application support at a university with 1,001-5,000 employees
Speed and stability of the MySQL DB are the most valuable features since we use it as the data store for most of our web applications.
View full review »it_user279822
DevOps SRE at a tech services company with 51-200 employees
ACID attributes are the most valuable feature, as data reliability is a top concern.
View full review »SA
reviewer1544529
Project Manager at a computer software company with 1,001-5,000 employees
The solution is so stable. I have encountered no problems.
RM
reviewer1531995
Senior Director IP led Services (PES) at a computer software company with 1,001-5,000 employees
This is a good traditional database, it supports JSON and it is whatever you need for a simple solution. It fits well, is easy to use and provides good service.
GO
reviewer1301145
CEO at a computer software company with 11-50 employees
Apart from the features that are in the enterprise part, we find the database to be
valuable. The connectors and the backup features are valuable as well. We use the
basic database. We don't really use the extra features. Our clients like the security
features in the database.
it_user158343
Software Architect at a tech consulting company with 51-200 employees
We design web solutions for customers with PHP (Linux) and ASP.NET MVC (Windows). MySQL offers a simple, no frills, but effective DBMS solution with a very low hardware footprint. Since it has no licensing fees, it offers great TCO for our customers.
View full review »it_user369420
Software Tester & SQA at a manufacturing company with 501-1,000 employees
I couldn't name just one most valuable feature. You can use it under different cases, but most of the time I needed the database as a part of my project. I think, in one moment you will prefer the InnoDB database, so you can store and execute procedures and roll-backs.
View full review »it_user1122
Infrastructure Expert at a tech services company with 1,001-5,000 employees
MySQL is open source, highly extensible and scalable, and is available from a web interface via PHPMyAdmin, which is excellent because it's platform independent.In almost all instances that I have used MySQL, it has handled whatever I threw at it and hasn't failed me yet.
View full review »
VR
reviewer1519272
Full Stack Developer at a tech services company with 10,001+ employees
It is easy to use. It is simple to implement, which makes it suitable for our projects because we have deadlines. MySQL is also open-source, which is another plus point.
View full review »it_user3405
Partner at a tech services company with 51-200 employees
- Its ease of use
- It's secure.
- It's fast.
- It has high-end processing.
- It can distribute across clouds.
- It has the ability to run on any operating system.
it_user208659
QA Lead at a logistics company with 1,001-5,000 employees
The most important features would be querying, the query language where you have the data definition or data modification language, as well. In some cases, we have to create our own tables for testing purposes. In that case, having SQL Server is much easier compared to what's available.
View full review »it_user722220
MySQL DBA
Usually, we use the application for our team to ensure the data is correct.
View full review »it_user216924
Data Scientist / Consultant with 501-1,000 employees
- Open Source (It’s free)
- One can easily find help on the web
DY
reviewer1399998
Deputy Manager at a university with 1,001-5,000 employees
This product is a good teaching tool for students who want to learn about networked databases.
View full review »it_user755235
Director at RC Ghosh Group of Companies
The most valuable feature of MySQL is the informative error outputs of command line interface.
View full review »it_user755103
Open Source Database Consultant
- Vertical scalabity on hardware
- Better hardware usage
- Access performance
- Addressing consistency, scalability and performance issues
it_user492180
Director of Information Technology at a tech services company
Installation, because in a few seconds, the product was up and running.
View full review »it_user333624
Software Developer at a tech services company with 501-1,000 employees
- Excellent performance, mainly due to the format of its default table, MyISAM - low disk space, CPU, and memory
- Flexibility offering multiple variations such as Berkely DB , InnoDB, Heap and MyISAM
- Reliability. Although the system runs on Windows without flaws, it tends to perform better on Linux and other UNIX-like Systems.
- Availability
- Open-Source System, open storage database engine
- Used by many websites (e.g. LinkedIn, Facebook, Verizon, and PayPal)
- It's inexpensive when compared to other common databases like Microsoft SQL Server.
- As a developer myself, I enjoy using it at no cost as long as the associated projects are also open-source.
it_user1065
Senior Manager of Data Center at a integrator with 51-200 employees
The best features in MySQL, making it one of the most used databases globally, are-
1) Multi-threaded architecture for multiple CPU utilization and kernel threading
2) Use of triggers and crash recovery techniques
3) Indexed Conditional Pushdown
4) Integration with LAMP/WAMP
5) Easy setup with Memcached for increasing performance and scalability
View full review »
RP
reviewer1362969
IT Specialist at a government with 1,001-5,000 employees
One of the best features is this solution is easy to use.
View full review »AA
Antonio Arcucci
CEO at a computer software company with 1-10 employees
The most valuable feature is the fact that the product is cross-platform, because it reduces server TCO, for my small company. This is very important.
View full review »it_user450789
Member of Technical Staff at a tech company with 501-1,000 employees
Simple syntax and simple administration are the most valuable features.
View full review »it_user424227
SENIOR DEVELOPER at a tech services company with 51-200 employees
The multiple engine replication is the most valuable feature. This neuralgic process for billing needs high availability and that is where we need this robust, but simple solution. If one server fails, we switch to the other transparently.
View full review »it_user304542
DevOps Lead Engineer at a tech services company with 51-200 employees
It is open source and AWS provides a managed solution.
View full review »
KopanoRamaphoi
Consultant at Rpc Data
The solution is easy to use.
View full review »MU
Manzeel Uprety
Co-Founder at Mero Reading Room
I have found the following features valuable:
- NetFlow of the whole system
- Information flow and scaling
- Communication between multiple collaborators and stakeholders
- Its user-friendly features.
it_user436011
IT Director at a energy/utilities company with 501-1,000 employees
MySQL database is the database on which we run JD Edwards. You could run it on Unix or you could run it on Oracle or something else. Our choice was to run it on MySQL because of the availability of resources in our area. There are more MySQL database resources available around Houston than there would be those that are familiar with, say, Oracle Database.
View full review »it_user1020
Head of Data Center at a tech company with 51-200 employees
MySQL has established itself not only as the most popular open-source database, but the most reliable one as well. In my more than six years as system administrator managing various websites and web servers, MySQL has been our server of choice for web applications. It wouldn't be acquired by Oracle if it did not see it that way too.What I like most about MySQL is that it's relatively easy to install, fast, lightweight and reliable. It's available for both Windows and Linux, making it a very good alternative to other open source databases back then, which only runs on Linux. PostgreSQL for example did not have a Windows installer before. This made it very difficult to adopt it for mixed-OS environments and that is why we use MySQL.
View full review »
GS
Geraldo Santo
CTO at a tech services company with 1-10 employees
We use the basic features of MySQL. The interface that allows us to see the parameters of the server is good.
View full review »KB
teamlead968247
Team Leader Presales at a comms service provider with 51-200 employees
The fact that it is free is what appeals to me the most.
View full review »it_user582915
Software Development Manager at a tech services company
It is free and bundled with cPanel.
View full review »it_user703740
Software Engineer at a tech company with 51-200 employees
The most valuable features are:
- MySQL Database Servers
- MySQL Connectors
- MySQL Workbench.
it_user130032
CEO at a tech services company with 51-200 employees
SQL capability, functions and ease of optimization.
View full review »AS
Azis Susetio
EUC Techical Operation at a tech services company with 10,001+ employees
I like MySQL because of its community.
View full review »it_user649608
IT Manager
- Free usage
- Performance
- Community
it_user346572
Systems Administrator at Nubity Inc. at a tech services company
it_user1164
Infrastructure Expert at a tech services company with 51-200 employees
It has a relational database system.
Client/Server Architecture
SQL compatibility (Structured Query Language) .MySQL has the features of the current SQL standard (at the moment SQL: 2003).
SubSELECTs: From version 4.1, MySQL is capable of processing a query in the form of SELECT * FROM tablename1 WHERE x IN (SELECT y FROM tablename2).
MySQL supports views from MYSQL version 5.0.
Stored procedures: Is capable of storing codes: MySQL has supported SPs since version 5.0.
Triggers: MySQL has supported triggers in a limited form from version 5.0
Unicode: MySQL has supported all conceivable character sets since version 4.1, including Latin-1, Latin-2, and Unicode (either in the variant UTF8 or UCS2).
User interface: There are a number of convenient user interfaces for administering a MySQL server.
Full-text search: Full-text search simplifies and accelerates the search for words that are located within a text field. If you employ MySQL for storing text (such as in an Internet discussion group), you can use full-text search to simply implement an efficient search function.
Has got statement-based replication.
It's one of the simplest ways to create databases.
View full review »
DM
reviewer1435281
IT at a construction company with 201-500 employees
The most valuable feature is the ease of use.
View full review »it_user793887
Works at Micro Focus
I use MySQL for various purposes. Sometimes I have used MyISAM as a storage engine rather than InnoDB.
it_user344865
Developer at a tech services company with 51-200 employees
- Compatibility
- Stability
- Maintenance
These are very important points to keep in mind while deploying consumer facing products, it has to work.
View full review »it_user229656
Senior Staff Engineer at a tech vendor with 501-1,000 employees
This product’s most valuable feature to me is active-active (multi-master) cluster support for MySQL.
View full review »it_user369264
Junior Technician Intern at a tech services company with 501-1,000 employees
- Privileges
- Command line
it_user359547
Expert Advisor at a mining and metals company with 51-200 employees
At this time, pricing and footprint.
View full review »it_user244500
Constructor of the computer systems at a security firm with 51-200 employees
- Reliability
- Security
- Flexibility
- Functionality
- Availability - controllability anywhere and with different methods
it_user325773
Jr. Production Engineer at a marketing services firm with 51-200 employees
MySQL 5.6 has a great many new features, including, but certainly not limited to, a number of performance improvements.
However, besides the widely talked-about features such as InnoDB, there's also support for full text search, optimizer, performance schema improvements and GTID.
View full review »CL
reviewer1410678
Data Analyst at a tech company with 51-200 employees
It is easy to use.
View full review »it_user677721
Information Technology Technician at a tech vendor with 51-200 employees
How it uses clustering.
The API's to PHP, ruby, perl, java, python, and many more high level programming languages makes it easy for us to deploy new features fast.
it_user3876
Database Manager at a tech company with 51-200 employees
• It is inexpensive as compared to other common databases like Microsoft SQL Server or Oracle.
• MySQL is an extensible, open storage database engine that integrates seamlessly with a number of programming languages and other web-based technologies.
• MYSQL is an open source system under the GNU General Public License. Developers can use it at no cost as long as the associated projects are also open-source.
• Having excellent performance, MYSQL is used by many internet powerhouses like yahoo as their back-end database. MYSQL has great performance due to format of its default table, MyISAM. MyISAM databases use little disk space, memory and cpu. The system runs without flaw and perform better on all platforms including windows, Unix and Linux.
View full review »
it_user285990
Service Operations Manager at a tech vendor with 51-200 employees
It depends on the use and implementation, as I prefer to use Galera or XtraDB because of replication and failover functionality. However, the ability to scale horizontally is much better than other vendors. Also, the transactional functionality is good.
View full review »CM
reviewer1514799
Project Business Analyst RPA at a consultancy with 11-50 employees
What I really like about MySQL is the opportunity to search for information and organize it any way I like. If you know the queries and you add the code, you can organize information any way you like.
View full review »it_user417285
Senior Production Support Engineer at a tech company with 501-1,000 employees
MySQL is very flexible, has excellent performance, and it's simple to use.
View full review »it_user239649
IT Manager at a retailer with 1,001-5,000 employees
This product is valuable because it is used in production environments. Online backup can be implemented by activating a temporary storage similar to the Oracle's flash recovery area and introducing Percona innobackupex. This is possible from version 5.6.
it_user1077
Developer at a tech company with 51-200 employees
1) It is freely available under the terms of GNU General Public License.2) MySQL works seamless on various platforms and environments.3) It is mainly used in Client/Server environment and it can be embedded in standalone applications.
4) Support SQL standards, and also provide Multi-thread environment.5) Offers high performance due to its unique storage engine architecture as well as it's core written in powerful languages such as C and C++.
View full review »
it_user602400
Intern at a tech vendor with 1,001-5,000 employees
It is Open Source and easy to access.
View full review »it_user1044
Developer at a tech company with 51-200 employees
• Free to download and use
• Loads of new features over 4.1 version.
• Excellent support for a range of platforms.
• Performs well in small and medium applications.
• Most popular Open Source database engine.
• Supports advanced concepts such as replication.
• Performs extremely well in the average case.
View full review »
Buyer's Guide
MySQL
April 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,740 professionals have used our research since 2012.
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros
sharing their opinions.
Updated: April 2024
Popular Comparisons
Tableau
SQL Server
Oracle Database
MariaDB
SAP HANA
Teradata
PostgreSQL
Firebird SQL
IBM Db2 Database
Vertica
Amazon Aurora
LocalDB
CockroachDB
IBM Netezza Performance Server
SingleStore
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More:
- Primary Use Case
- Valuable Features
- Room for Improvement
- Customer Service and Support
- Initial Setup
- ROI
- Pricing
- Other Advice
- Which solution do you recommend for embedding reporting? Why?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Why are MySQL connections encrypted and what is the biggest benefit of this?
- Considering that there is a free version of MySQL, would you invest in one of the paid editions?
- What is one thing you would improve with MySQL?
- How does MySQL compare with Firebird SQL?
- When evaluating Open Source Databases, what aspect do you think is the most important to look for?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Which database is the best for session cashing?
- Which low-code (no-code) database solution do you prefer?
