MySQL Archived Reviews (More than two years old)

Filter by:Reset all filters
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Vendor
User at Micro Focus
Jun 10 2018

What do you think of MySQL?

What is our primary use case?

I use MySQL for employee service in an OLTP database.

What is most valuable?

I use MySQL for various purposes. Sometimes I have used MyISAM as a storage engine rather than InnoDB.

What needs improvement?

When working with a cluster wide, I have to use the MySQL cluster version.

For how long have I used the solution?

One to three years.

Which solution did I use previously and why did I switch?

The 5.7 version has very better performance improvement over the previous version.
Vendor
QA Lead at a logistics company with 1,001-5,000 employees
Mar 04 2018

What is most valuable?

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… more»

How has it helped my organization?

To give you an example, initially we didn't have a database server as such, and we had to make use of some database. Now we use something where we can share the instances… more»

What needs improvement?

I feel that some tools which make it easier to create queries or make it easier for other functions would be really interesting to see.

What's my experience with pricing, setup cost, and licensing?

I'm not sure about pricing, I don't deal with the pricing. It's an organization decision.

Which solution did I use previously and why did I switch?

I've used a lot of different solutions. MySQL is one of the top among them. Usability and scalability are some of the reasons we went with MySQL.

What other advice do I have?

No one tool fits the bill for every company. Do a feasibility study, and get to know what is can do before going in and developing.

Which other solutions did I evaluate?

There were many options.
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
425,794 professionals have used our research since 2012.
Real User
IT Manager
Feb 28 2018

What do you think of MySQL?

How has it helped my organization?

Web portal database.

What is most valuable?

Free usage Performance Community

What needs improvement?

Scaling.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

There have been some problems with big table operations.

What do I think about the scalability of the solution?

Some problems with big table operations, and a struggle to keep the servers responding in peak situations.

How is customer service and technical support?

I don't have enough information about it, as I normally look for community support.

How was the initial setup?

Straightforward, and and easy to run.

What's my experience with pricing, setup cost, and licensing?

Can range from free to quite…
Real User
Information Technology Technician at a tech vendor with 51-200 employees
Feb 14 2018

What is most valuable?

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.

How has it helped my organization?

Since it has many integrations to web applications, it is very easy to install and deploy open source web applications.

What needs improvement?

How to scale out with shard clusters. The way how to handle replications needs to be improved, as we noticed that there are some performance drop of (using only one core for example)

What's my experience with pricing, setup cost, and licensing?

Be sure to take backups of the solution, as this will check that the blocks are okay. We decided to use "DB Protection for MySQL" as it has options to perform block level incremental forever, and… more»

Which solution did I use previously and why did I switch?

We have been using many different types of databases, and will most likely use this one for part of our systems, as it is has so much integration.

Which other solutions did I evaluate?

Yes, we checked MongoDB, PostgreSQL and MariaDB.
Haim Tzadok
Reseller
Co-Founder/CEO at Grigale LTD
Feb 04 2018

What do you think of MySQL?

How has it helped my organization?

It dramatically improved use for several of my customers.

What is most valuable?

This depends on my customers' use.

What needs improvement?

SQL and NoSQL use.

For how long have I used the solution?

More than five years.

What do I think about the stability of the solution?

When configured correctly, no stability issues.

What do I think about the scalability of the solution?

When configured correctly, no scalability issues.

How are customer service and technical support?

Very good.

Which solution did I use previously and why did I switch?

MySQL Support Services by Percona. I switched to Oracle MySQL services because of a better ROI.

How was the initial setup?

There is no obvious answer. It depends.

What's my experience

Muhammad Nurazhan Moin
Real User
Senior Web Manager at a university with 501-1,000 employees
Feb 04 2018

What is most valuable?

* Open-source * Multi-platform * Lightweight * Simple to set up, configure and tune * Support for enterprise-grade features like clustering, master-slave replication, even… more»

How has it helped my organization?

Due to the open source licensing model, it has allowed small businesses like ours to adopt enterprise-grade database systems without incurring significant licensing costs.

What needs improvement?

It would be helpful if there were a graphical user interface to administer, configure, and tune it. If it had something similar to Microsoft’s DTS engine then it would be… more»

What's my experience with pricing, setup cost, and licensing?

MySQL Enterprise Support is not cheap, though might still be cheaper than Oracle or SQL Server. They may not have local support depending on where you’re based, but there… more»

Which solution did I use previously and why did I switch?

I’ve used SQL Server and Oracle for database systems. SQL Server is an excellent solution, in particular the DTS (Data Transformation System) which is not available for… more»

What other advice do I have?

As long as your application supports it well, and you are familiar with the scaling options and its limitations, you can’t go very wrong with MySQL, as it is a very mature… more»

Which other solutions did I evaluate?

I’d been using other database systems like Microsoft’s SQL Server and Oracle Database before trying out MySQL. There are forks of MySQL maintained outside of Oracle, like… more»
Real User
Director at RC Ghosh Group of Companies
Jan 23 2018

What is most valuable?

The most valuable feature of MySQL is the informative error outputs of command line interface.

How has it helped my organization?

We use MySQL for enterprise data storage as well as part of the back-end of websites and web applications.

What needs improvement?

MySQL needs improvements on its diagnostic features.

What's my experience with pricing, setup cost, and licensing?

Enterprise editions and support are definitely needed for the heavy users who need direct support.

Which solution did I use previously and why did I switch?

Not applicable. No previous solution.

What other advice do I have?

One should ensure the availability of proper hardware before any optimization attempt from the software level.

Which other solutions did I evaluate?

No.
Real User
Head of Business Technology at a tech services company with 501-1,000 employees
Jan 23 2018

What is most valuable?

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.

How has it helped my organization?

Due to the large user base, a large amount of software modules and plugins for rapid application development are possible. From an operational viewpoint, this is also a very big advantage.

What needs improvement?

It does not stand out regarding scalability. When the company size increases, the user base having actual experience with (very) large MySQL solutions is reduced.

What's my experience with pricing, setup cost, and licensing?

When you know the setup will continue to grow, make sure you have the paid support.

Which solution did I use previously and why did I switch?

No.

Which other solutions did I evaluate?

MariaDB/Galera.
Real User
ERP System Analyst at a tech services company with 501-1,000 employees
Jan 03 2018

What do you think of MySQL?

We could write books about MySQL and every book could have a different focus: setup, optimization, backup, etc. So, this review will be about sharing some of the experiences that I have had. So, MySQL is probably the most used RDBMS for web applications. The server is really easy to install, literally a straightforward installation. It is very fast and stable and at the same time not resource hungry compared to some other RDBMS products. For smaller projects, you will not even need to do any "after install" tweaks or configurations, just install and you are ready to go. Nevertheless, for some more demanding projects, you will need to investigate and optimize your setup to fit the requirements. What is the best configuration for a MySQL server? There is no single best configuration.…
Real User
Software Architect at a tech consulting company with 51-200 employees
Dec 19 2017

What is most valuable?

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… more»

How has it helped my organization?

We do software development for our customers on both Windows and Linux. Since these tools are available for both Windows and Linux, we can leverage the knowledge of these… more»

What needs improvement?

Only one of the engines, InnoDB, supports ACID transaction control. The best performance engine, MyISAM, has no transactional control support. It would make a lot of sense… more»

What's my experience with pricing, setup cost, and licensing?

With no licensing fees, the business opportunity is great for both the customer and an ISV like my company. This is the case, as long as you use these tools for… more»

Which solution did I use previously and why did I switch?

For Windows development of non-critical solutions, we previously used SQL Server Express exclusively. However, now we use either SQL Server Express or MySQL, depending on… more»

What other advice do I have?

Most small and medium enterprises require many non-critical solutions. They clearly they do not have large budgets for these kinds of solutions, so it makes a lot of sense… more»

Which other solutions did I evaluate?

We did evaluate other solutions, mainly PostGreSQL, which is also a very good product. We run a benchmark comparison first, then we run a small lab with the development of… more»
Vendor
Senior Application Programmer/Analyst, Team Lead at a university with 10,001+ employees
Dec 12 2017

What is most valuable?

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… more»

How has it helped my organization?

MySQL is widely supported. We were able to integrate it with several different projects using various different programming languages with no issues. Worked with Java… more»

What needs improvement?

The weakest link is replication. MySQL’s replication is touchy and doesn’t support master-to-master setups. MySQL’s replication was implemented by playing back SQL… more»

What's my experience with pricing, setup cost, and licensing?

There are tuning and monitoring benefits for people who purchase MySQL rather than using the free version.

Which solution did I use previously and why did I switch?

MySQL has replaced Microsoft SQL Server in several cases. MySQL is easier to manage and much more cost-effective.

What other advice do I have?

The porting code to or from MySQL is not that complicated, but the date type/format and functions are the biggest hurdles. Handling booleans data type is less efficient… more»

Which other solutions did I evaluate?

Looked at Microsoft SQL Server and PostgreSQL.
Vendor
Open Source Database Consultant
Oct 29 2017

What is most valuable?

* Vertical scalabity on hardware * Better hardware usage * Access performance * Addressing consistency, scalability and performance issues

How has it helped my organization?

Storage and searching quickly on data is no longer an issue facing us using Excel.

What needs improvement?

Hardware scalability and parallel treatment can and will be improved in the next few years.

What's my experience with pricing, setup cost, and licensing?

Don't use the license version. Open source is enough.

Which solution did I use previously and why did I switch?

We switched to a different solution because of data access issues, speed, and consistency.

What other advice do I have?

You will have a lot of work, but you will also avoid a lot of issues due to product immaturity on the database market.

Which other solutions did I evaluate?

There are a lot of alternative to paid features. It's very hard to find support for this feature.
Vendor
MySQL DBA
Aug 23 2017

What is most valuable?

Usually, we use the application for our team to ensure the data is correct.

How has it helped my organization?

We majorly use the application now. We can use MySQL to read for our select queries. This helps us to achieve stability.

What needs improvement?

In MySQL, you can only have one master. The master's scalability was always a problem. The cost towards the locking and the patent. What happens, we will be running the MySQL network, and what happens… more»

Which solution did I use previously and why did I switch?

Yeah, we used to cheat off MySQL. But in the end, it was somebody else's design. So, we migrated to MySQL. We just migrated from there to here.

What other advice do I have?

You just need to identify why and what are the requirements. Also, you need to listen to news feeds regarding the features you are getting into and the features you will to use from it. Take the time… more»

Which other solutions did I evaluate?

It always depends on the scenarios of the requirement - what all the current scenarios come from. Are these application teams or is that someone who is just getting the product? If someone majorly… more»
Vendor
Data Scientist / Consultant with 501-1,000 employees
Jul 31 2017

What do you think of MySQL?

What is most valuable?

Open Source (It’s free) One can easily find help on the web

How has it helped my organization?

You can easily build data models both on-premise and on the cloud.

What needs improvement?

The work bench has some bugs that are mostly GUI related.

For how long have I used the solution?

I have used this solution for three years.

What do I think about the stability of the solution?

I did not encounter any issues with stability.

What do I think about the scalability of the solution?

I did not encounter any issues with scalability.

How are customer service and technical support?

I use the community version. There are ample “Open Source” resources on the Internet.

Which solution did I use previously and why did I switch?

We used Microsoft SQL…
Consultant
IT Consultant, Business Owner, Lecturer at a tech consulting company with 10,001+ employees
Jul 31 2017

What is most valuable?

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… more»

How has it helped my organization?

For any web project today you are going to need a database system. If you use any Content Management System, MySQL is most of the times the database of your choice. MySQL is easy to use, most… more»

What needs improvement?

Although MySQL should cover most of the needs of an average user, there are constrains that need improvement. For example, MySQL doesn’t support check constraints. MySQL’s performance is not optimal… more»

Which solution did I use previously and why did I switch?

MySQL has been the only solution for all of our web projects.

What other advice do I have?

For us, MySQL is the choice for all of our projects. It is simply to use, supported by all content management systems and, of course, Open Source. We haven’t had any major issues, and since we have… more»

Which other solutions did I evaluate?

When we started using MySQL, it was more or less the best Open Source RDBMS for web projects. Today, you have multiple options, such as PostgreSQL, SQLite and MariaDB, therefore the choice for a… more»
Consultant
Software Development Manager at a tech services company
Jul 31 2017

What do you think of MySQL?

What is most valuable?

It is free and bundled with cPanel.

How has it helped my organization?

Cost effective.

What needs improvement?

Not at the moment in my current work environment.

For how long have I used the solution?

Two years, began when I started at my current workplace.

What do I think about the stability of the solution?

So far, so good due to limited clients at the moment.

What do I think about the scalability of the solution?

So far, so good due to limited clients at the moment.

How are customer service and technical support?

There is no technical support since it is a CE.

Which solution did I use previously and why did I switch?

No.

How was the initial setup?

Straightforward.

What's my experience with pricing, setup cost, and licensing?

Vendor
Powerbuilder Consultant at a government with 1,001-5,000 employees
Jul 27 2017

What is most valuable?

* 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

How has it helped my organization?

Using MySQL helps to keep the costs down. With immense material available on the web, training is easy too. This is the de facto DB for web development with PHP. If you… more»

What needs improvement?

The simplicity of the product lets people abuse it. I've seen so many people create tables and add indices in PHP code. Some of these web developers only know some things… more»

What's my experience with pricing, setup cost, and licensing?

This started as Open Source project under Sun. With Oracle acquiring Sun, MySQL is now owned by Oracle (not the community). Oracle promised to keep it open sourced, but… more»

Which solution did I use previously and why did I switch?

We did not use a different solution for the applications that use MySQL. I mostly use Oracle for larger, enterprise software.

What other advice do I have?

This is a relational database tool for small to medium sized applications. However, this didn't start as a Relational DB, so if you want a truly Relational Database for an… more»

Which other solutions did I evaluate?

We evaluated MS Access, SQLite, PostgreSQL, FireBird, and Oracle.
Consultant
Systems Administrator at Nubity Inc. at a tech services company
Jul 19 2017

What do you think of MySQL?

What is most valuable?

Easy: Installation Customization Use

How has it helped my organization?

Data is: More ordered Reliable Available in time and form

What needs improvement?

Scalability: In large databases, they become slow.

For how long have I used the solution?

12 years.

What do I think about the stability of the solution?

No.

What do I think about the scalability of the solution?

Yes. In large databases, response times are high.

How are customer service and technical support?

10 out of 10.

Which solution did I use previously and why did I switch?

We used this solution, but changed for another because the database was very large.

How was the initial setup?

Configuration was easy and with much support material.

Which other solutions did

Consultant
Developer at a tech services company with 51-200 employees
Jul 19 2017

What is most valuable?

* Compatibility * Stability * Maintenance These are very important points to keep in mind while deploying consumer facing products, it has to work.

How has it helped my organization?

It’s been used as the main databases for a lot of the developments we have done. As for special features it offers, I wouldn’t say there’s a key one, but I do appreciate the stability it has.

What needs improvement?

* Real-time * Event driven results * Geolocation data * Non-text storage

What's my experience with pricing, setup cost, and licensing?

Since Oracle bought MySQL, I’ve seen a slow development. I would recommend the community server if you have to have MySQL, but I wouldn’t license or purchase it.

Which solution did I use previously and why did I switch?

No, in fact, I switched away from it in new developments.

Which other solutions did I evaluate?

PostgreSQL.
Antonio Arcucci
Vendor
CEO at a software R&D company with 1-10 employees
Jul 17 2017

What is most valuable?

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.

How has it helped my organization?

Without MySQL, we used a single centralized database. With MySQL, we can now have many standalone databases where every developer can perform local tests.

What needs improvement?

Improvement areas are Security and ORM, for example: It may be interesting to check the user-level access rights at the row level and a robust support to JSON model object (like NoSQL database).

What's my experience with pricing, setup cost, and licensing?

There is no cheap commercial license for standalone applications.

Which solution did I use previously and why did I switch?

Yes, I first used Microsoft SQL Server, then I went to MySQL because the cost is lower.

Which other solutions did I evaluate?

Yes, I have evaluated other database solutions. I have evaluated PostgreSQL and MongoDB.
Consultant
Web Developer at a tech services company with 201-500 employees
Jul 17 2017

What is most valuable?

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… more»

How has it helped my organization?

It gives us the opportunity to create backups of our databases easily and loop through them with minimum effort.

What needs improvement?

I think that the stored procedures and the development tools to write and debug large queries could be improved.

What's my experience with pricing, setup cost, and licensing?

I think that the Open Source product would cover the needs of most projects. In some cases, the advanced features are needed. They could use the enterprise edition, which… more»

Which solution did I use previously and why did I switch?

We used many SQL database solutions like PostgreSQL and SQLite and NoSQL databases like MongoDB. The choice depends on the project.

What other advice do I have?

I believe that it is the ideal solution for a variety of projects with a small learning curve compared to other solutions. It allows you to be efficient quickly.

Which other solutions did I evaluate?

We have evaluated and used different products like SQLite. It depends on the requirements and the needs of the project.
Real User
Director of Information Technology at a tech services company
Jul 16 2017

What is most valuable?

Installation, because in a few seconds, the product was up and running.

How has it helped my organization?

It was the first step of the Service Desk.

What needs improvement?

ITIL implementation: GLPI has a poor ITIL implementation in the sense that not all ITIL processes are implemented, e.g., no Service Catalog is present.

What's my experience with pricing, setup cost, and licensing?

It was open source and license-free.

Which solution did I use previously and why did I switch?

I have not used a solution like this before.

What other advice do I have?

Not choosing an open source software for this kind of solution. Now, we are looking at ServiceNow Express.

Which other solutions did I evaluate?

Yes, but commercial ones (ManageEngine, EasyVista, Remedyforce).
Vendor
Member of Technical Staff at a tech company with 501-1,000 employees
Jul 13 2017

What do you think of MySQL?

What is most valuable?

Simple syntax and simple administration are the most valuable features.

How has it helped my organization?

It allows us to maintain very large tables without jumping through the hoops that are required by the commercial products such as Oracle.

What needs improvement?

Multi-master replication could be a bit more reliable.

For how long have I used the solution?

Counting the earlier versions, we are using this solution for over ten years.

What do I think about the stability of the solution?

Compared to the other database solutions, there were no stability issues as such.

What do I think about the scalability of the solution?

Sharding is relatively straightforward.

How are customer service and technical support?

We run the Community version, so…
Consultant
SENIOR DEVELOPER at a tech services company with 51-200 employees
Jul 13 2017

What is most valuable?

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.

How has it helped my organization?

It facilitated fast processing of the millions of records for billing of the the call detail records in the Telecom company. The company needed to recover calls, in addition to immediately detecting frauds in the telephone calls so as to block the line and generate large losses. With the help of stored procedures, functions and triggers, we created an engine to recover most of the calls with a… more»

Which solution did I use previously and why did I switch?

We were using PostgreSQL. The reason why we switched to this solution was that of the easy administration.
Consultant
Senior Production Support Engineer at a tech company with 501-1,000 employees
Jul 13 2017

What is most valuable?

MySQL is very flexible, has excellent performance, and it's simple to use.

How has it helped my organization?

Once we needed to use a database to distribute a product for my company and we chose MySQL, it was easy to use and it is very small, but powerful.

What needs improvement?

Maybe the way to build clusters needs to be improved. They could also improve the installation process.

What's my experience with pricing, setup cost, and licensing?

MySQL is one of the best database options. The Community version is great.

Which solution did I use previously and why did I switch?

We did upgrade the version with improvements to the product.

What other advice do I have?

Using MySQL could be an excellent option for you.

Which other solutions did I evaluate?

We used Oracle and SQL Server, but their prices and licensing were so expensive.
Vendor
Software Engineer at a tech company with 51-200 employees
Jul 13 2017

What is most valuable?

The most valuable features are: * MySQL Database Servers * MySQL Connectors * MySQL Workbench.

How has it helped my organization?

MySQL has improved our internal procedures by providing high performance, ease of use, and cost savings.

What needs improvement?

Security in the data files needs manipulation.

What's my experience with pricing, setup cost, and licensing?

According to the specific business and technical requirements, you can choose your MySQL Edition that you wish by consulting the official site.

What other advice do I have?

It can benefit any business by a straightforward way of implementing and using it.

Which other solutions did I evaluate?

We looked at the Microsoft SQL Server.
Real User
IT Manager at a retailer with 1,001-5,000 employees
Jul 13 2017

What do you think of MySQL?

What is most valuable?

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.

How has it helped my organization?

It permits services such as data warehouse and retail.

What needs improvement?

The online backup needs to improve.

For how long have I used the solution?

I have used this solution for 15 years.

What do I think about the stability of the solution?

We did encounter stability issues.

What do I think about the scalability of the solution?

There were no scalability issues.

How are customer service and technical support?

Not applicable because we don't purchase…
Vendor
Academic application support at a university with 1,001-5,000 employees
Jul 12 2017

What is most valuable?

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.

How has it helped my organization?

Before we used MySQL, we used to access the data used for the dynamic web pages directly from our enterprise data stores and that was a massive performance bottleneck. With MySQL, the data can be… more»

What needs improvement?

From where we are, most of the improvements are being handled. With the new improvements that were introduced in MySQL 5.7 and with the testing that we have done to this point, we are looking at… more»

What's my experience with pricing, setup cost, and licensing?

The enterprise version has a number of extra components that makes it worth the price, but if all you want is a stable DB for web applications, then stick to the open version. We use enterprise… more»

What other advice do I have?

Ensure you know what you want to use it for and make sure it is the right fit for the job. Do not allow developers to tell you what your DB should look like, as that is the best way to performance… more»

Which other solutions did I evaluate?

There were not a lot of other options open to us.
Vendor
Intern at a tech vendor with 1,001-5,000 employees
Jul 12 2017

What is most valuable?

It is Open Source and easy to access.

How has it helped my organization?

My company does not use MySQL. However, it is often used at universities and is suitable for beginners. It is used for many projects.

What needs improvement?

From the perspective of the company, you can count on reliable Microsoft SQL or Oracle. If MySQL gets solid, it will be a good solution.

What's my experience with pricing, setup cost, and licensing?

If you have money, it would be better to use Oracle.

Which solution did I use previously and why did I switch?

I have used MS SQL and Oracle. However, now I have no money and am using MySQL.

What other advice do I have?

MySQL is a good choice for startups and beginners.

Which other solutions did I evaluate?

I thought about other Open Sources, but I chose MySQL, which I have already used.
Consultant
DevOps SRE at a tech services company with 51-200 employees
Jul 08 2017

What is most valuable?

ACID attributes are the most valuable feature, as data reliability is a top concern.

How has it helped my organization?

The backend of the production traffic happens at this level.

What needs improvement?

The dynamic scalability, clustering, dynamic replicas safeguard against failures, ease of setup and use all need to be improved. * MySQL was originally meant for a single server; now with the 5.7… more»

What's my experience with pricing, setup cost, and licensing?

It is a GPL license, only the support is priced but as there is a good community so buying support is optional.

What other advice do I have?

Do your research and make sure for your use case that MySQL is the best choice, before making any commitments.

Which other solutions did I evaluate?

I wasn't involved as this predates me at the organization, but today if this re-happens MySQL won't be the best choice.
Real User
Telecommunications Engineer at a comms service provider with 1,001-5,000 employees
Jul 03 2017

What is most valuable?

* SQL Merge * Replication * Views * Stored Procedures * Triggers * Cursors This is just like the enterprise grade Oracle DB. MySQL now supports replication (master-master… more»

How has it helped my organization?

The main benefit for us is that it's totally free, unless you need to pay for support.

What needs improvement?

I would like to see additional side management tools and IDEs.

What's my experience with pricing, setup cost, and licensing?

Just pay for any license if you need some enterprise support for your project or any additional support tools that Oracle ships with the enterprise version. During the… more»

Which solution did I use previously and why did I switch?

We did not use a solution prior to this one.

What other advice do I have?

Go with the Linux version. It is more stable and manages the system resources better.

Which other solutions did I evaluate?

We evaluated MSSQL, Oracle DB, Informix, and MariaDB.
Consultant
DevOps Lead Engineer at a tech services company with 51-200 employees
Jun 30 2017

What is most valuable?

It is open source and AWS provides a managed solution.

How has it helped my organization?

Amazon has come up with Aurora, a MySQL hybrid that has helped us get up to speed without actually thinking about MySQL underlying optimizations.

What needs improvement?

Catching up with proprietary technologies like Oracle and PostgreSQL is the challenge right now.

What's my experience with pricing, setup cost, and licensing?

Keeping something similar to AWS, and as easy as Amazon, will be the best thing for any small business like mine.

Which solution did I use previously and why did I switch?

We did not use a different solution before.

What other advice do I have?

Until you have expertise in data migrations and what you are doing with data, MySQL can be really easy and dangerous at the same time. MySQL doesn't give you a warning… more»

Which other solutions did I evaluate?

I did evaluate other solutions, but MySQL stood out because of its ease of use. Perhaps my prior experience has made me be biased towards MySQL.
Consultant
CEO at a tech services company with 51-200 employees
Jun 30 2017

What do you think of MySQL?

What is most valuable?

SQL capability, functions and ease of optimization.

What needs improvement?

Software and web development.

For how long have I used the solution?

15 years.

What was my experience with deployment of the solution?

No issues.

What do I think about the stability of the solution?

No issues.

What do I think about the scalability of the solution?

Manageable.

How is customer service and technical support?

Customer Service: Used open source and never needed customer service. The product is quite mature. Technical Support: NA

How was the initial setup?

Straightforward.

What about the implementation team?

In-house.

What was our ROI?

Good.

What's my experience with pricing, setup cost, and licensing?

The open source product is…
Rehana Parvin
Real User
Database Administrator at a recruiting/HR firm with 1,001-5,000 employees
Oct 22 2016

What is most valuable?

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.

How has it helped my organization?

The user friendly interface which is easy to interact with such as creating backups, tables, views, and the EER model.

What needs improvement?

It has lot of options to interact with. Sometimes it is hard to find the appropriate options quickly. They need to add descriptions somewhere as to where a user can go to find the proper menu easily when required. Another problem is that… more»

Which solution did I use previously and why did I switch?

I used phpMyAdmin. It is also a graphical interface but you have to buy the product while MySQL Workbench is free.

What other advice do I have?

This product is good as it is a graphical interface. It's easy to do all MySQL database administration very easily. You just need to play around to be more familiar with it. The MySQL Workbench interface is well prepared to design a… more»
Vendor
Senior Staff Engineer at a tech vendor with 501-1,000 employees
Aug 30 2016

What is most valuable?

This product’s most valuable feature to me is active-active (multi-master) cluster support for MySQL.

How has it helped my organization?

We have been using the multi-master solution from the Percona cluster. It seems to work as expected. We use it as an embedded component of a solution we sell. It has provided a low-cost, high-availability solution without complex… more»

What needs improvement?

It should provide detailed debugging with transaction IDs at the application level to understand deadlocks, especially under bursty workloads. It should also provide partitioned tables and a clustered index, like Oracle, to take advantage… more»

What other advice do I have?

Ensure that it meets your scaling needs, and has features for handling parallelism in the application.

Which other solutions did I evaluate?

This product’s active-active cluster feature was the reason for choosing it. One of the reasons PostgreSQL was not considered – a decision taken before I joined the company - was its lack of mature multi-master cluster support. It also… more»
Vendor
IT Director at a energy/utilities company with 501-1,000 employees
May 18 2016

What is most valuable?

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… more»

How has it helped my organization?

The availability of resources for MySQL has been the biggest benefit for our organization.

What needs improvement?

I'd like to see Oracle provide more certification for it.

What other advice do I have?

Choose your database based upon your ability to be able to hire people and support the product, like supporting JD Edwards with a MySQL database. Not everyone can work one database with JD Edwards as well as they can another one. So just make sure you've got the compatibility and skill-set.
Vendor
Project Manager at a non-tech company with 10,001+ employees
Mar 04 2016

What do you think of MySQL?

Pros:-  1) MySQL is an open source database under the GNU General Public License, that means developers can use it at no cost as long as the associated projects are also open source.  2) MySQL is ideally suited for small/medium sized organizations for faster performance.  3) MySQL can be used in client/Server architecture as well as it can also be embedded in standalone applications.  4) MySQL is fast, east to use, highly extensible, lightweight, scalable, and reliable database.  5) MySQL supports clustering in the network for redundancy.  6) MySQL provides flexibility to modify environment variables/kernel settings to limit the amount of memory usage for increasing performance.  7) MySQL is strongly recommended for web applications, middleware and LAMP…
Vendor
Software Tester & SQA at a manufacturing company with 501-1,000 employees
Feb 28 2016

What is most valuable?

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… more»

How has it helped my organization?

Again, I couldn't name an positive aspect precisely. Maybe, the fact that using MySQL and Java gives it a big portability and, at the same time, short time responses within your product (my case)… more»

What needs improvement?

None that I can name. At the moment I worked with MySQL, there was nothing I couldn't do with the product.

What's my experience with pricing, setup cost, and licensing?

It's free.

Which solution did I use previously and why did I switch?

There was no solution in use previously.

What other advice do I have?

It helped me within my projects. For a free product, it works very well and it's easy to use and configure. Don't try the most sophisticated products, that have big names, and cost a ton. Just try… more»
Consultant
Junior Technician Intern at a tech services company with 501-1,000 employees
Jan 20 2016

What do you think of MySQL?

What is most valuable?

Privileges Command line

How has it helped my organization?

I don't have any as this was my first time using it.

What needs improvement?

I think it is where it needs to be. MySql PaaS. But, you do need to have experience with SQL to use it.

For how long have I used the solution?

I've used it for 12 months.

What was my experience with deployment of the solution?

There were no issues deploying it.

What do I think about the stability of the solution?

It has been perfectly stable for us.

What do I think about the scalability of the solution?

We've been able to scale it without issue.

How are customer service and technical support?

Customer Service: 4/10 Technical Support: 7/10

Which solution did I use previously and why did I switch?

MS…
Vendor
Expert Advisor at a mining and metals company with 51-200 employees
Jan 05 2016

What do you think of MySQL?

What is most valuable?

At this time, pricing and footprint.

How has it helped my organization?

This database enabled us to web present our content in a cost efficient way.

What needs improvement?

I am not up to date on this issue.

For how long have I used the solution?

At the time pricing and footprint.

What was my experience with deployment of the solution?

This was the IT consultant's task to solve.

What do I think about the stability of the solution?

No issues encountered.

What do I think about the scalability of the solution?

Not really, as our DB was small. With time, we got version issues, as our DB engine was so old and not updated.

How are customer service and technical support?

Customer Service: I've never used it. Technical Support: I've never used…
Consultant
Software Developer at a tech services company with 501-1,000 employees
Oct 31 2015

What is most valuable?

* 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… more»

What needs improvement?

* Limited storage capacity * Support for foreign keys * Stored procedures * The biggest disadvantage of MySQL is MyISAM system, which doesn't support well transactions (lack of efficiency)

What's my experience with pricing, setup cost, and licensing?

Because MySQL is an open-source , the system is under GNU Licence. The system isn't always free, but it's more affordable. If you intend to sell your software as a proprietary product, you would need to purchase a commercial license, which… more»

Which solution did I use previously and why did I switch?

What other advice do I have?

From my perspective, MySQL is a product that allows you to be efficient, but the decision goes down to the situation and what you're looking to accomplish.
Vendor
Constructor of the computer systems at a security firm with 51-200 employees
Oct 29 2015

What do you think of MySQL?

What is most valuable?

Reliability Security Flexibility Functionality Availability - controllability anywhere and with different methods

What needs improvement?

MyISAM tables could be more reliable.

For how long have I used the solution?

I've been using the Workbench Server for six years.

What was my experience with deployment of the solution?

I have had no problems deploying it.

What do I think about the stability of the solution?

I have no stability problems.

What do I think about the scalability of the solution?

I currently do not need to scale on my network.

How are customer service and technical support?

Customer Service: I only have the free version, which does not have customer service. Technical Support: I only have the free version, which does not have…
Vendor
Jr. Production Engineer at a marketing services firm with 51-200 employees
Oct 19 2015

What is most valuable?

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.

How has it helped my organization?

In order to change the size of InnoDB transaction log files, you have to follow this procedure. Beware that if you don’t follow these instructions step-by-step, your server may not restart or rather it will start with InnoDB storage engine disabled and an error in the logs. So, here’s what you want to do: 1. change (or add) the following variable in my.cnf: innodb_log_file_size = .. 2. stop MySQL server 3. make sure you see a successful shutdown of InnoDB in the MySQL error log 4. move away old log files (at this point I have to double check where they are) by running the following command: mv… more»
Vendor
Service Operations Manager at a tech vendor with 51-200 employees
Aug 06 2015

What is most valuable?

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.

What needs improvement?

Configuration templates and reliability both need work.

What's my experience with pricing, setup cost, and licensing?

Chose your database based on traffic type and desired functionality, not on the initial cost.

What other advice do I have?

If you have the in-house knowledge MySQL can be a great product. If you do not I would recommend using MSSQL instead. Take a look at the environment you plan to implement including the application and traffic model.
Vendor
Engineer with 51-200 employees
Jan 13 2015

What is most valuable?

* Speed * Cost

How has it helped my organization?

MySQL provides a low cost and effective SQL Database solution for smaller companies that don’t require the overhead and cost associated with RDBMS tools like Oracle

What needs improvement?

Replication and HA features, but that is to be expected at this entry point

What's my experience with pricing, setup cost, and licensing?

The initial setup cost and maintenance costs are built into the OS costs for all of my implementations and are insignificant.

Which solution did I use previously and why did I switch?

Before using MySQL I used Oracle and Informix for RDBMS.

What other advice do I have?

MySQL is a great RDBMS, but make sure it will integrate with all of the clients you will be using and the rest of your infrastructure. The problems usually have more to do… more»

Which other solutions did I evaluate?

I usually look at MySQL, PostgreSQL and Oracle.
Consultant
Database Manager at a tech services company with 501-1,000 employees
May 01 2014

What is most valuable?

• 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… more»

What needs improvement?

• MySQL has a limited storage capacity. It doesn’t support large databases. • Database transactions are not handled efficiently. • Unlike Oracle, MySQL doesn't have Tablespace, Role management, snapshots, synonym and packages. • For transferring data, MySQL doesn’t support other languages being executed from within the system, and neither does it supports XML. • Compared to Oracle, MySQL database… more»

What other advice do I have?

MySQL is an open source database management system and is used by most of the most famous networking sites. It is more popular in websites and PHP integration. It can be executed under a number of operating systems like Linux, UNIX, Mac OS and Windows. MySQL supports ODBC interface which allows MySQL to be addressed by all the usual programming languages that run under Microsoft Windows.
Vendor
Head of Data Center at a university with 1,001-5,000 employees
Dec 18 2012

What is most valuable?

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… more»

What needs improvement?

Back in the days, our only gripe about MySQL was that it was a purely command-line based system. We don't really see it as disadvantage though, as it allowed it to be fast and very reliable. This has been addressed through the years with graphical management systems for MySQL. MySQL is a highly recommended product. I give it five stars as it really gets the job done without much of a hassle. Being… more»

What other advice do I have?

Just be ready though to work at the command line should you wish to use MySQL in its free form. It may not be the most intuitive user interfaces available, but it also makes MySQL a simple yet very reliable database for most people's needs.
Consultant
Developer at a tech consulting company with 51-200 employees
Aug 04 2012

What is most valuable?

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… more»

What needs improvement?

1) Does not provide good development and debugging tools, so it’s cumbersome to write large SQL statements.2) MySQL uses temporary tables to execute queries, so it consumes more space.3) MySQL is missing some RDBMS features like stored procedures, foreign keys, transaction, rollback, and subselect. And it also does't support triggers.It is widely used in web applications, and several software… more»

What other advice do I have?

And if some one is looking for Database which performs simple processes like storing and displaying data only, then MySQL is the right choice.
Consultant
Infrastructure Expert at a tech services company with 51-200 employees
Jul 13 2012

What is most valuable?

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… more»

What needs improvement?

DELETE and UPDATE statements that use a LIMIT clause without an ORDER BY are non deterministic. Statements using any of the following functions cannot be replicated properly using statement-based replication: LOADFILE (), USER ().
Consultant
Infrastructure Expert at a tech services company with 1,001-5,000 employees
Jul 12 2012

What is most valuable?

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.

What needs improvement?

It is a community driven project, which means that support is sometimes scarce and hard to find. Also, it really doesn't have an IDE per-se, like MSSQL does.

What other advice do I have?

I use MySQL on a regular basis, specifically whenever I am managing or installing a Wordpress instance. Combined with PHPMyAdmin, MySQL is an excellent database solution for small to medium sized businesses or installations. I would recommend using a better supported database like Oracle or MSSQL for mission critical tasks on an enterprise level, but MySQL is completely capable of performing the… more»
Vendor
Developer at a tech company with 51-200 employees
Jul 02 2012

What is most valuable?

• 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.

What needs improvement?

• It doesn't support stored procedures. • You probably wouldn't use it for heavy-duty installation. • There is no active directory for integration with Microsoft SQL Server or other data bases.

What other advice do I have?

As a developer I have used many database engines but MySQL is by far the best known and most popular Open Source database engine.
Vendor
Senior Manager of Data Center at a integrator with 51-200 employees
Jul 01 2012

What is most valuable?

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

What needs improvement?

Few cons in MySQL are 1) Increased complexity in InnoDB 2) Slower performance when using InnoDB as compared to MyISAM for using simple queries 3) Only identical MyISAM tables can be merged. 4) No active directory integration as in SQL server 5) It does not support check constraints

What other advice do I have?

MySQL is indeed the world's most popular open source database. It has been designed on the hyper threading infrastructure and supports multi-threaded architecture for using multiple CPU's. It works on index compression with B-Tree disk tables popularly known as MyISAM. Its efficiency depends on the implementation of SQL functions with optimization of library classes.

What is MySQL?

Until its recent acquisition by Oracle, MySQL was possibly the most renowned open source database enterprise package that could be accessed completely for free. With the merger, the server increased both its features and its price tag, but there is still a free version available to the general community to contribute ideas and suggestions.

MySQL is a fast and relatively inexpensive database management system. It can easily integrate with a wide variety of programming languages, and it is considered to be a very reliable option. One of the most prominent features that customers seem to enjoy is the easy scalability of this system.

MySQL customers

Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.

BUYER'S GUIDE
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.