MySQL Review

It tends to perform better on Linux and other UNIX-like systems, but it needs support for foreign keys.


Valuable Features:

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

Room for 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)

Use of Solution:

Personally, I've been using it for over 10 years, and professionally for three to four years.

Deployment Issues:

I had no problems deploying it.

Stability Issues:

With each release of MySQL Server was useful for any little problems that users detected, so I would say it's quite stable.

Customer Service:

Previous Solutions:

Initial Setup:

It was straightforward, thanks to the workbench that pulls together nearly every MySQL task, and puts them into one easy and friendly GUI.

Cost and Licensing Advice:

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 is quite inexpensive when compared with a Microsoft SQL license.

Other Advice:

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 visitor found this review helpful
1 Comment
Software Developer at a tech services company with 501-1,000 employeesReal User

also with the new 5.7 edition added some other fixes , update, firewall , etc. You can check the new version on their page.

18 January 16
Guest

Sign Up with Email