MySQL Valuable Features
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 »
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 »
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 »
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 »
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 »
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.
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 »
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 »
Database Administrator at a comms service provider with 1,001-5,000 employees
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 »
CCO at a construction company with 11-50 employees
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 »
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.
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 »
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 »
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 »
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 »
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 »
Founder at a non-profit with 1-10 employees
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 »
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 »
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.
Manager at Delta X
MySQL has a lot of documentation, and bug fixing is better in the latest version.View full review »
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 »
It has a community version. When I have to create a new database, I have no problems with licenses.
Table partitioning is most valuable. It is easy to use.View full review »
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 at a construction company with 201-500 employees
The most valuable feature is the ease of use.View full review »
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.
Full Stack Developer at a tech services company with 10,001+ employees
Data Analyst at a tech company with 51-200 employees
It is easy to use.View full review »
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 »
It has a lot of features. The RDBMS, consistency, and multi-user features are valuable.View full review »
Senior Data Analyst at Charutarhealth Org
The replication feature is the most valuable. We are replicating our servers.View full review »
EUC Techical Operation at a tech services company with 10,001+ employees
I like MySQL because of its community.View full review »
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 »
Information Technology Administrator at a tech services company with 51-200 employees
The solution is easy to use.View full review »